Deployment and Imaging Group

 View Only

Renaming a SQL server known troubles 

Aug 07, 2014 05:49 PM

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 :)

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Aug 07, 2014 05:54 PM

We see the SPN was badly associated a domain admin account "Administrateur".

And the HOST record, does not display the 1433 SQL port.

We delete the MSSQLSvc/server1.domain.ch:1433 administrateur

We add the setspn /A MSSQLSvc/server1.domain.ch:1433 server1

That's it, we recover the Windows integrated authentication OK for ODBC.

Thanks a lot Xavier M. for the help.

Related Entries and Links

No Related Resource entered.