Post reply

Rename server

  • March 13, 2019 at 4:48 am

    #382012

    Hi all!

    I have a server named : EDVARDWIN8\SQLEXPRESS2012

    It should have the name SP-DESKTOP\SQLEXPRESS

    I tried to use the find function on this page, and found:

    sp_dropserver 'EDVARDWIN8\SQLEXPRESS2012'
    GO
    sp_addserver 'SP-DESKTOP\SQLEXPRESS', 'local'
    GO

    Both run without errors

    But my server still have the old name if I use:

    SELECT @@SERVERNAME

    What Am I doing wrong?

    Best regardsw

    Edvard Korsbæk

  • March 13, 2019 at 5:03 am

    #2024299

    I read a bit about it, and found that a restart of the PC gave:

    SELECT @@SERVERNAME

    SP-DESKTOP\SQLEXPRESS

    Which is exactly what i want. Problem is, that i cannot connect to the new servername, just the old.

    So- Something is still missing

    Best regards

    Edvard

  • March 13, 2019 at 5:15 am

    #2024301

    do you have SPNs which point to the old instance Name?

  • March 13, 2019 at 5:21 am

    #2024302

    What i do is to call the DB with the usual syntax servername,dbname,login,password

    Today I am using servername as  the 'Old name', and i want to use the 'new name'.

    I am using a Clarion program for the job, and i do not expect anybody here to know how it handles this.

    Best regards

    Edvard Korsbæk

  • March 13, 2019 at 5:26 am

    #2024303

    My question still remains: Do you have SPNs for SQL Server Service Accounts which might point to the old instance?

  • March 13, 2019 at 5:38 am

    #2024304

    I have no knowledge about SPN.
    I tried to download the Kerboros configuration manager, and it is as I see it installed, but I cannot find the program.

    BTW  - The server is installed on  a usual  WIN 10 PC, not a server.

    Best regards

    Edvard Korsbæk

  • March 13, 2019 at 5:45 am

    #2024305

    Well, you don't need the KCM, simply check in the SQL Server configuration Manager if the Database Engine is running under a service account. If it does check on the service account if there's any SPN by cmd. If the server configuration manager exposes NT SERVICE something accounts, you might have to check the computer account if a SPN is set.

    Where SQL Server is installed, doesn't matter. If it has enough permissions it'll register a SPN by itself.

  • March 15, 2019 at 3:28 pm

    #2024661

    After having read on the stuff, I have found out, that I can change the last part of the name, but NOT the machine name, so I think it stops there.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply