|
CAUSE
This issue may occur in situations when there are entries that exist in Active
Directory from a previous installation of SharePoint Portal Server, and these
entries prevent Microsoft SQL Server from registering itself correctly in
Active Directory.
RESOLUTION
To resolve this issue, follow these steps:
1. On the server in the server farm, that is running Microsoft
SQL Server, click Start, and then click Run.
2. In the Open box, type cmd, and then click OK.
3. Type the following line at the command prompt, where
ServerName is the name of the server that is running Microsoft SQL Server 2000,
and then press ENTER:
setspn –l ServerName
A list of service principal names that are currently registered for the server
are displayed.
4. From the list of currently registered service principal
names that is displayed earlier in step 3, make a note of each service
principal name that starts with the following text:
MSSQLSvc
5. Delete each service principal name entry that starts with
MSSQLSvc. To do so, type the following line at the command prompt, where
ServicePrincipalNameEntry is the service principal name entry that starts with
MSSQLSvc and ServerName is the name of the server that is running Microsoft SQL
Server, and then press ENTER:
setspn –d ServicePrincipalNameEntryServerName
Repeat this step for each service principal name entry that starts with
MSSQLSvc.
6. Restart the server.
7. Create the configuration database.
|