Article ID: 2269959 - View products that this article applies to.
A System Center Configuration Manager 2007 site fails to upgrade to Service Pack 2 and reports SQL Error: The server service principal name already exists. You may also see the following in the Configmgrsetup.log file:
<MM-DD-YYYY HH:MM:SS> ***SqlError: [Microsoft][ODBC SQL Server Driver][SQL Server]The server principal '<Domain>\Server1$' already exists.
This can occur when a server in a site server role is renamed and the SPN's and SQL logins remain associated with the old computer name.
1. Remove the <Domain>\<OldServerName> login record from the Configuration Manager database using SQL Management Studio.
2. Remove the old Service Principle Name using ADSIEdit:
3. Add the new, proper SPN using the following command:
setspn –A MSSQLSvc/<SQL Server computer name>:1433 <Domain\Account>.
Note: See How to Configure an SPN for SQL Server Site Database Servers for more information.
4. Run SP2 setup again. This time it should complete successfully.
How to Configure an SPN for SQL Server Site Database Servers: http://technet.microsoft.com/en-us/library/bb735885.aspx
Configuration Manager Service Principal Name Requirements: http://technet.microsoft.com/en-us/library/bb735877.aspx
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.
Article ID: 2269959 - Last Review: September 16, 2010 - Revision: 3.0