Home Forums SQL Server 2008 SQL Server 2008 Administration SQL named instance alias as server name RE: SQL named instance alias as server name

  • April 13, 2012 at 3:53 am

    #1473109

    You can setup a SQL Alias using a .reg file, here is a sample keep in mind that its from a windows XP client so may need to be modified for Windows 7, Server 2008 etc...

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo]

    "AliasName"="DBMSSOCN,ServerName\\instance"