Post reply

Renaming sql server 2000, how do I such thing?

  • February 27, 2006 at 1:50 am

    #112964

    Dear all,
     
    I've got a Sql2000k installed over win2003 server and I would like to change the server name. Now, appears on the top of MMC 'local'. Host name on the domain is 'nnaa' and I want to have as Sql Server name 'n500'. I've tried launch sp_dropserver 'nnaa' and then sp_addserver 'n500','local', stopping the services and so on but at the end of the time unsuccessfully, what else is needed? am I confusing concepts or simply the only solution is reinstall?
    Moreover, as a result, @@servename inform the name desired...
     
    Thanks for any input or rectification,

  • February 27, 2006 at 3:58 am

    #623411

    You first of all have to change the Windows server name. And then you have to change the SQL Server name in the same way you already pointed out, using sp_dropserver and sp_addserver.

    Karl
    source control for SQL Server

Viewing 2 posts - 1 through 1 (of 1 total)

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