Tuesday, March 18, 2008

Moving SQL Server database to another domain

Our SQL Server database was installed on a domain controller and later moved to a standard server in another domain. When trying to add SP2 to our SQL Server installation, I got errors like this:
Setup was unable add user DOMAIN\SVCUSER to local group DOMAIN\SQLServer2005SQLAgentUser$SVR$INSTANCE01
MSP Error: 29528
Transforming table Error

Fix:
Create local SQL Server groups for services and assign the users as you need them.
Remove "group" keys in the registry. You will know which ones as they all have word "group" in the name.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

Then install SP2.
Keys will get re-created.