Post reply

SQL Server Name differnt to Computer Name

  • February 8, 2006 at 10:45 pm

    #170887

    When you install SQL Server the SQL Server Name is the same as the Computer Name. We are setting up a standby machine (with a different computer name), installing SQL Server restoring the databases etc. At the last minute we plan to pull the existing SQL Server off the network and change the name of the SQL Server (but not the computer) to that of the old server and also give it the same IP address.

    Are there any unxepected consequences in doing this?

    Thanks,

    Dick Campbell

  • February 9, 2006 at 12:01 am

    #619680

    you might not  be able to connect

    you can explore named instances, failover clustering, logshipping instead

    the change will happen on the apps level via an ini file most probably

    HTH

  • February 10, 2006 at 3:59 am

    #620067

    If your applications connect using the IP-address there will be no problem.

    just be sure to follow this: http://www.databasejournal.com/scripts/article.php/1496451

    and http://support.microsoft.com/default.aspx?scid=kb;en-us;281642

     

    Your sqlserver will only be available using the HW-computername or using a DNS-Alias for it. In your case, using a dns-alias may be the way to go, so you can migrate connections later on.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • February 10, 2006 at 12:38 pm

    #620260

    I'd shy away from IP addresses totally. That's what DNS was meant to do for you !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • February 10, 2006 at 3:32 pm

    #620295

    Just to clarify one point, what are the issues in having the computer name and SQL Server name different? Is it best to keep them the same.

    By the way, the thing that concerns me is that we are replicating the data to about 10 MSDE databases. Replication uses SQL Server names so I assume that we need to preserve the SQL Server name. The plan is to disconnect the old sever rename the new one and connect it. We will then run the Replication Create script (generated on the old server).

    I am begining to think that I should change the computer name, IP address and SQL Server name of the new machine to be that of the old one.

    Thanks for the comments so far.

    Dick Campbell

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

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