SharePoint – Configure SQL Alias

      No Comments on SharePoint – Configure SQL Alias

Ok, this is a pretty basic one but you’ll be amazed how many people don’t know how to do them.  SQL aliasing as been around for years and in the future I expect DNS to replace it.  However for those of you that are wondering what the process is.

First thing to note is that the executable for SQL aliasing is within the operating system so you don’t need to download additional SQL tools to do this.

Run the command “CLICONFG.EXE”  (note there is no “i” in config…..that one always catches me out!)

Enable TCP/IP

SQL Alias - Client network utility

Add an Alias

SQL Alias - add library configuration

A couple of things to note here.

– The network libraries needs to be set to TCP
– The “Server Alias” is the name that will be presented to the application,  in this case SharePoint
– The “Server Name” is the real name of the SQL instance
– If the SQL server hosting the instance has a number of named instances on it then it will be using dynamic ports (ensure the SQL Browser service is running on the SQL server otherwise you won’t be able to use the automatically determine the port used).  If however the instance is the default instance on the SQL server deselect the “Dynamically determine port” check box and set the port to 1433.

Now to test that everything is working  you simple need to create a blank TXT file and rename it to a .UDL file.  You’ll notice the icon picture change.  Double click this and you’ll be presented with this screen.

SQL Alias - Data link properties

Fill in the source name, this is the alias name you set above, in this example “SharePointSQL” and provide credentials if required and test the connection.

Leave a Reply

Your email address will not be published. Required fields are marked *