Share
ReportHello 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
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!
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
