• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

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?
0
tofitadmin
Asked:
tofitadmin
1 Solution
 
Chris MangusDatabase AdministratorCommented:
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.
0
 
cyberkiwiCommented:
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Tackle projects and never again get stuck behind a technical roadblock.
Join Now