[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL 2008 Express

Posted on 2010-09-07
2
Medium Priority
?
289 Views
Last Modified: 2012-05-10
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
Comment
Question by:tofitadmin
2 Comments
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 33623358
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
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 2000 total points
ID: 33623363
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Loops Section Overview
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question