Post reply

SQL Server

  • October 22, 2001 at 12:24 am

    #57999

    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

  • October 22, 2001 at 1:35 am

    #419153

    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

  • October 22, 2001 at 10:31 am

    #419168

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

    Steve Jones

    steve@dkranch.net

  • October 23, 2001 at 10:46 pm

    #419229

    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.

    Cheers

    Regards

    Parasu Raman


    Regards
    Parasu Raman

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

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