Microsoft SQL Server 2005/2008R2:SQL Alias-User friendly names for connecting SQL Server
For More information about SQL Alias,Read this Follow this steps to create sql alias. 1.Just Go to -->Programs-->SQL Server 2005/2008R2-->Configuration Tools-->SQL Server Configuration Manager--> Click on SQL Native Client 10.0 Configuration. Click on Aliases Right click -->New Alias. Fill Information about SQL Connection. Alias Name:Server1 Port No: 1433 Protocol :TCP/IP Server:(Instance Name)192.168.0.16\SQL2005 Click Ok. Alias created. Use Alias name instead of Original Connection Settings.