SQL Server

  • Hi,

    I have installed MS Sql Server 7.0 on windows2000 Advanced Server and it is running fine. After few days I have changed the Name of the System. Now Sql Server is not running properly. How can change the settings in SQl Server sothat it can work with the New name.

    Ramesh A

  • by default sql 7.0 takes the name of computer overwhich it has installed use sp_addserver and drop server to set it to new name

  • be sure when you run sp_addserver, you inclde the LOCAL option

    Steve Jones


  • Another way is to run the sql server installation setup again. This would just update the sql server's name and nothing would happen to the databases and other objects present in the server.

    But its safe u take a backup.



    Parasu Raman

    Parasu Raman

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

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