We were needing to move a DS 6.9 server from older Windows 2003, to new 2008 R2, with PXE integrated. Previously we were having external SQL 2005, and we decide to integrate SQL in the same server (only 350 clients) with SQL 2008 R2. To keep client config, we decide to keep same IP and name. We prepare a server with a temp name "SERVER1B", to replace the original "SERVER1", and rename/change IP to substitute.
1st, our server strangely refused to get back the name of the original server (previously down and deleted from the AD).
We were having to get out of the domain (workgroup), rename it, and get back into the domain. The error was:
Computer Name/Domain Changes
---------------------------
The following error occurred attempting to rename the computer to "SERVER1":
The system cannot open the device or file specified.
We rename the server, and apply the suggested SQL command from http://msdn.microsoft.com/en-us/library/ms143799.aspx
sp_dropserver 'SERVER1B' -- temp name
go
sp_addserver 'SERVER1','local' ---previous server name, deleted before
go
sp_helpserver -- to display check result
go
But still have issue to use remote client DS 6.9 console, with Windows authentication, ok with SA account, but ODBC was getting ISSP error. It was necessary to correct KERBEROS with the following action, because a "bad" SPN registration
>setspn /Q MSSQLSvc/server1.domain.ch:1433
MSSQLSvc/server1.domain.ch:1433
Existing SPN found!
C:>setspn /Q HOST/server1.domain.ch
Checking domain DC=domain,DC=ch
CN=SERVER1,CN=Computers,DC=domain,DC=ch
WSMAN/SERVER1.domain.ch
WSMAN/SERVER1
TERMSRV/SERVER1
TERMSRV/SERVER1.domain.ch
RestrictedKrbHost/SERVER1
HOST/SERVER1
RestrictedKrbHost/SERVER1.domain.ch
HOST/SERVER1.domain.ch
Existing SPN found!
C:>setspn -L administrateur
Registered ServicePrincipalNames for CN=Administrateur,OU=Admin,OU=0_BIP,DC=domain,DC=ch:
MSSQLSvc/server1.domain.ch:1433
C:>setspn -d MSSQLSvc/server1.domain.ch:1433 administrateur
Unregistering ServicePrincipalNames for CN=Administrateur,OU=Admin,OU=0_BIP,DC=domain,DC=ch
MSSQLSvc/server1.domain.ch:1433
Updated object
C:>setspn /A MSSQLSvc/server1.domain.ch:1433 server1
Checking domain DC=domain,DC=ch
Registering ServicePrincipalNames for CN=SERVER1,CN=Computers,DC=domain,DC=ch
MSSQLSvc/server1.domain.ch:1433
Updated object
C:>setspn /Q HOST/server1.domain.ch
Checking domain DC=domain,DC=ch
CN=SERVER1,CN=Computers,DC=domain,DC=ch
MSSQLSvc/server1.domain.ch:1433
WSMAN/SERVER1.domain.ch
WSMAN/SERVER1
TERMSRV/SERVER1
TERMSRV/SERVER1.domain.ch
RestrictedKrbHost/SERVER1
HOST/SERVER1
RestrictedKrbHost/SERVER1.domain.ch
Hope this can be usefull information for you.
But I must say, do not play ! Do the rename of the server BEFORE, installing SQL and DS6 !! It will be a better Idea :)