Link to home
Start Free TrialLog in
Avatar of totalimpact
totalimpact

asked on

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?
Avatar of bgoering
bgoering
Flag of United States of America image

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
ASKER CERTIFIED SOLUTION
Avatar of totalimpact
totalimpact

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Steve Wales
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.