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!)
Add an Alias
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.
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.