Hello guyz! am trying to login into a restored 2009 database. This is the error "the login failed when connecting to SQL server AMOS"
*This post is locked for comments
Hi! You should try this: http://mibuso.com/blogs/kriki/2009/02/18/how-to-get-access-when-you-cant-get-into-your-nav-sql-db/
Good luck!
Hi,
Basically you need to clear the existing credentials by opening the DB using SQL and fire the below queries (for that db):-
delete from dbo.[Member Of];
delete from dbo.[User];
delete from dbo.[Windows Access Control];
delete from dbo.[Windows Login];
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.