Post reply

naming sql server instance

  • July 28, 2006 at 9:17 am

    #191593

    I have a sqlserver 2000 isnstance and when I am looking at its properties in Enterprise Manager its showing its name as local.

    But how can I rename it to some meaningful name.

     

    Thanks.

  • July 28, 2006 at 9:45 am

    #652153

    Local means that it is the default instance on your local machine.  The only way to change it would be to re-install SQL Server on that box as a named instance. 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • July 30, 2006 at 1:11 am

    #652246

    You can use EM to create a new Server registration using the machine name instead of local.

    Drawback is that (local) connects EM to SQL Server via the memory network protocol while the machine name probably uses TCP/IP.

    Andy

  • July 31, 2006 at 8:02 am

    #652384

    I'm not sure if this is what you are after or not, but check out master..sp_addserver.  Once you run the proc with your new server name, you will have to stop and restart SQL server for the new name to show up in the results of select @@servername.

     

    Good Luck,

    Steve

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

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