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)\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