HOWTO Create a SQL Server Alias with the SQL Server Client Network Utility

The SQL Server Client Network Utility configuration tool allows you to manage protocols, aliases, database library options, and network libraries on a computer. In particular it allows you to creates an alias to a SQL Server instance, equivalent to adding a shortcut to SQL Server on a computer. Installing the SQL Server Client Network Utility is a lot quicker that installing the SQL Server Management Studio and tools.

The SQL Server Client Network Utility can be downloaded as part of the SQL Server Feature Pack. The SQL Server 2008 SP2 feature pack includes this utility, and a number of others.

To create an alias:

  1. Start the utility (typically installs in %SYSTEMROOT%\system32\cliconfig.exe)
  2. Select the “Alias” tab
  3. Click “Add”
  4. Enter the alias name
  5. Enter the details for the SQL Server instance you want to connect to
  6. Click OK

This will create an alias on that particular computer. If you have other computers that need an alias, this procedure needs to be run on each one.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: