Post reply

renaming the named instance in sqlserver2000

  • May 28, 2009 at 3:24 am

    #131952

    Hi i have sql2000exp edition(named) and 2005 dev(default) edition installed on same machine

    when i tried to change the instance name

    using

    sp_dropserver sp_addserver

    i tried with above queries after finishiing

    i checked select @@servername

    iam getting o/p -- null(it is not showing changed name)

    even i restarted the services and server also

    pls give the correct solution

    Thanks in advance

  • May 28, 2009 at 3:27 am

    #1001277

    What is the exact code you are using.

    Normally it is just...

    sp_dropserver old_servername\instancename

    GO

    sp_addserver new_servername\instancename, local

    GO

  • May 28, 2009 at 3:58 am

    #1001286

    Thanks for u r reply

    i did the same syntax

    but when i exicuted sp_helpserver it is showing the changed name(new instance name) but

    when i connect to that server it is showing the same old instance name

    and when i run

    select @@servername it is showing null

    pls any good sugessions will be apriciated

    thanks

  • June 2, 2009 at 6:14 pm

    #1003723

    Are you making use of aliases under SQL Server Configuration Manager?

    MJ

Viewing 4 posts - 1 through 3 (of 3 total)

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