Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In my devopment environment (Win 2008 server) are running two sql server 2008 instances (default and named instance).

Already one Sql alias is configured and pointing to the default instance. I want a second alias pointing to the named instance but have no idea how to achieve this.

share|improve this question

migrated from May 28 '12 at 6:12

This question came from our site for professional and enthusiast programmers.

In SQL Server Configuration Manager, expand SQL Server Native Client Configuration, right-click Aliases, and then click New Alias.

In the Alias Name box, type the name of the alias. Client applications use this name when they connect.

In the Server box, type the name or IP address of a server. For a named instance append the instance name.

In the Protocol box, select the protocol used for this alias. Selecting a protocol, changes the title of the optional properties box to Port No, Pipe Name, or Connection String.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.