Post reply

Renaming the Server

  • September 26, 2003 at 10:05 am

    #59492

    If we rename our server, will it be necessary to re-install SQL Server?

  • September 26, 2003 at 10:10 am

    #476042

    Do you have replication running in the server?

    If no, it is much easier. After renaming the server, you can run, sp_addserver 'YourServer', 'Local', 'duplicate_ok'. To verify the server has been renamed, run SELECT @@SERVERNAME

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

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