SQL 2005 security accounts missing after server restore

I had to do a full restore of a Windows SBS 2003 server using Backup Exec, turns out Backup Exec was failing to backup the service states, registry, and AD, so I pretty much had to start from scratch.

I restored the database folders, and re-installed several apps, but the server still does not have the SQLServer2005MSSQLUser$ServerName$MSSQLSERVER accounts.

Is there a guide for recreating these?
totalimpactAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
totalimpactConnect With a Mentor Author Commented:
I went through that site, but could not get anything to work, ended up removing sql and reinstalling applications from their default state.
0
 
bgoeringCommented:
Take a look at http://blogs.msdn.com/b/sqlserverfaq/archive/2009/08/20/informational-understanding-and-troubleshooting-msp-error-29512-sql-server-setup-was-unable-add-user-domain-username-when-you-try-to-install-sql-server-2005.aspx

You can ignore the stuff about clustered server, but the article has a good write up on the local accounts your are referencing.

Good Luck
0
 
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.