Announcements
No record found.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
