You’re offline. This is a read only version of the page.
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,
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];
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!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,104
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (