Post reply

change of machine name on which MS SQL is installed

  • June 9, 2004 at 7:21 pm

    #83019

    Dear All

    I have a query .

    There is a intranet application which is a JSP/MS SQL application.Tomcat and MSSQL has been installed on one machine and the other machines are accessing the application from this machine.

    Now the machine name and IP address needs to be changed .

    So how will the application be affected ..

    If any one has an idea that what all changes would be reqd to be done please let me know

    Thanks in advance

  • June 10, 2004 at 6:37 am

    #509827

    If this is running sql 2000, when you rename the machine the sql server won't run.

    You would need to use sp_dropserver <servername>, then sp_addserver <newname>,local to bring it back

    Also last time I renamed a sql 2000 box, and found that I couldn't amend any maintenance jobs as the server thought they where owned by a master server. This was because the jobs where owned by the old server name, changeing the name in the msdb job table sorted it out no problem.

    Hope this helps

    Steven

  • June 10, 2004 at 7:43 am

    #509853

    if you get things out of order, (the above technique works), you can connect from the console of the server to "(local)" or "." to get back in and change the name of the SQL Server.

     

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

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