Post reply

Rename SQL Server 2005 question

  • December 31, 2008 at 2:02 pm

    #129714

    After renaming a SQL Server 2005 server does anyone fix or renames the 6 local groups that the SQL install creates?

    How about fixing the sql logins created from those groups?

    Has anyone else discovered any hidden things that need fixed after a server rename that is not covered by the documentation?

    Thanks Everyone!

  • December 31, 2008 at 2:28 pm

    #919832

    I know of one gotcha that I've experienced on both 2000 and 2005. Most of it wasn't my fault, but I've found a case where the computer name and SQL server servername don't match.

    You can check that by running this:

    -- get current SQL Server name\instance name

    SELECT @@SERVERNAME

    -- get current machine name and instance name

    SELECT SERVERPROPERTY('MachineName'), SERVERPROPERTY ('InstanceName')

    Here's the link to more info:

    http://support.microsoft.com/kb/303774

    MCITP, Database Administrator
    A hodgepodge of Information Technology and Life
    LinkedIn Profile
    My Twitter

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

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