Wednesday, August 29, 2012

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.

 



No comments:

Post a Comment

Dear User,

Thank you very much for your kind response