renaming the named instance in sqlserver2000

  • 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

  • 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

  • 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

  • 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