Archive

Posts Tagged ‘SQL Server 2008’

How to: Create a Server Alias for Use by a Client (SQL Server Configuration Manager)

July 25, 2011 Leave a comment

I don’t create, or connect to, new database instances that often, so this post is just a quick reference for me.
Enjoy,
Tim

——————
MSDN:
http://msdn.microsoft.com/en-us/library/ms190445.aspx

Aliases created with SQL Server Configuration Manager can be used with any client application. The connection strings described in SQL Server Configuration Manager Help can be useful for programmers who create their own connection strings.
To access alias information in SQL Server Configuration Manager Help
In SQL Server Configuration Manager, expand SQL Native Client Configuration, right-click Aliases, and then click New Alias.

  1. Press F1, or click Help.
  2. The New Alias (Alias Tab) topic describes the New Alias dialog box, and contains links to valid connection strings for each type of protocol.