tofitadmin
asked on
SQL 2008 Express
Good Evening,
I am having troubles on trying to access my SQL 2008 Express databases. We accidently removed the domain user account and recreated the account and now we are not able to access one of our databases. Is there a simple fix for this?
I am having troubles on trying to access my SQL 2008 Express databases. We accidently removed the domain user account and recreated the account and now we are not able to access one of our databases. Is there a simple fix for this?
Under the hood, SQL Server doesn't track domain accounts by name but actually by SID. You're going to need to delete the domain account from your SQL server and then recreate it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.