rickgaribay.net

Space shuttles aren't built for rocket scientists, they're built for astronauts. The goal isn't the ship, its the moon.
posts - 275, comments - 169, trackbacks - 33

My Links

News

Where's Rick?

Windows 8 Unleashed, Microsoft Tempe, 11/2
AzureConf, Channel 9 Studios, 11/14
Desert Code Camp, 11/17
VS Live! Las Vegas, 3/25-3/29
VS Live! Chicago, 5/13 - 5/16


About Me
I am a developer, architect, writer and speaker, passionate about distributed .NET technologies and Application Lifecycle Management. I am currently the General Manager of the Connected Systems Practice at Neudesic.





    follow me on Twitter



    Archives

    Post Categories

    Published Works

    Renaming SQL Server 2005

    When using VPC, it is common to clone machines and rename servers, which can pose a problem for platforms such as BizTalk Server which are configured to connect to a given machine name at installation/configuration time.

    The first step in managing a rename is to reconfigure BizTalk using the BizTalk Configuration Tool, but there is an additional step that is required from a SQL Server perspective.

    If you perform the following query within the master table in the SQL Server that houses the BTS databases, you will get a record that includes the following:

    select * from sys.servers

    server_id       name
    =============================
    0                 CurrentServer

    Where the server name has changed to something like "NewServer" it is necessary to not only rename the machine and assign it a new SID, but also to rename the SQL server name.

    To do so, execute the following statement which drops the server name (don't worry your databases will still remain intact):

    exec sp_dropserver 'CurrentServer' GO

    Next, execute the following statement, providing the new server name:

    sp_addserver 'NewServer', LOCAL GO

    Now, run the same query as above and the result should include the new server name:

    server_id       name
    =============================
    0                 NewServer

    Once this is complete, you will more than likely need to unconfigure and reconfigure your BTS installation. There are some components where this is not required, but I haven't quite figured out which are which yet.

    Print | posted on Wednesday, January 16, 2008 4:22 PM | Filed Under [ Hardware Misc. ]

    Comments have been closed on this topic.

    Powered by: