Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    26

    Unanswered: Things to do when changing SQL Server name

    Hi all,

    My SQL Server instance name, and SQL Server group are different to my machine name, so we are planning to change it.

    From what I read, all you have to do is rename the SQL Server, rename the Windows SQL group, drop the SQL Server group than recreate the group with the new machine name, is this all we have to do? what else do I have to do? And what backout plan should I take.

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    One of the annoying things you will have to do is reset the owning server on any SQL Agent job. There might be an easier way to do it in SQL 2005, but I think in SQL 2005 I resorted to just updating the table in msdb.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •