N/A
WORKAROUND 1:
The SQL Server 2005 Configuration Manager allows you to create aliases to SQL server.
1. Start| Program files| Microsoft SQL Server 2005| Configuration Manager| SQL Server Configuration Manager
2. Go down to SQL Native Client Configuration and expand it.
3. Right click on the Aliases and click New Alias. The IP address of the server is not required.If the server hosts more than oneSQL Server, you canenter the instance name.
From Books Online:
To set a SQL Server alias:
1.In theObject Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.
2.Right-clickSQLServerAgent, and then clickProperties.
3.In the SQL Server Agent Properties dialog box, clickConnection, and type the alias name in theAliaslocal hostserver fieldto which SQL Server Agent should connect.
NOTE: SQL Server Agent will not work correctly unless you select an alias that refers to the local instance of SQL Server.
Note: The Alias Name should be the @@Servername. The serverName of a alias should be the IP Address
This Solution includes contributions from:
http://sqlblog.net/post/2008/07/11/Connecting-to-SQL-server-instance-using-an-Alias-instead-of-the-server-name-or-IP-name.aspx
http://decipherinfosys.wordpress.com/2007/11/26/using-a-server-alias-to-connect-to-sql-server-instances/http://msdn.microsoft.com/en-us/library/ms175176(SQL.90).aspx
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center