Creating SQL server alias

  1. Run SQL Server configuration manager, in SQL Server Network configuration enable TCP/IP
    sql server configuration manager
  2. Enable TCPIP protocol – just select Yes from the dropdown
    enable tcp ip
  3. Make sure SQLBrowser service is set to Automatic startup and is running
  4. In SQL Native Client create new alias (Alias Name = what you want the “virtual” instance to be named, leave PortNo blank, Protocol = TCP/IP, Server = the existing instance to which the alias points)new_alias

See also: Liam Westly – How to setup a SQL Server alias and when is a connection alias useful for developers?

Advertisements

Tagged: ,

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

smsagent

Tips, tricks and time-savers for the Windows and ConfigMgr administrator

To The Point

Anything about Technology and Business

Brian's Power Windows Blog

Microsoft in the Enterprise. Windows, Hyper-V, Exchange, SQL, and more!

PowerScripting Podcast

Shownotes and links for the PowerScripting Podcast, a podcast to help people learn Windows Powershell

Learn Powershell | Achieve More

What is this Powershell of which you speak?

%d bloggers like this: