Last modified at 3/15/2014 11:42 AM by Koen Zomers

1. CliConfg

An excellent article describing how to use cliconfg to create a SQL Alias for use with SharePoint can be found at:

http://mmman.itgroove.net/2012/07/setting-up-a-sql-server-alias-with-sharepoint-server-2010/

In short, for 64 bits Windows operating systems run:

C:\windows\syswow64\cliconfg.exe

For 32 bits Windows operating systems run:

C:\windows\system32\cliconfg.exe

2. PowerShell

Doing the same, but then via PowerShell is being described at:

http://habaneroconsulting.com/blog/posts/Create_a_SQL_Alias_with_a_PowerShell_Script.aspx

3. Registry

Third option to create a SQL database alias is manually via the registry by following these steps:

  1. Open the Registry Editor by pressing Windows+R, typing regedit and pressing enter

    SharePoint_SqlAlias_Regedit_Run.png

  2. If your server is running a 64 bits Windows (most likely), navigate to:

    HKLM:\Software\Wow6432Node\Microsoft\MSSQLServer\Client\ConnectTo

    If your server is running a 32 bits Windows (less likely), navigate to:

    HKLM:\Software\Microsoft\MSSQLServer\Client\ConnectTo

  3. Right click somewhere in the whitespace on the right, click Newfollowed by a click on String Value

    SharePoint_SqlAlias_Regedit_RightClickNewString.png

  4. Enter the name you wish to use to use as an alias. So this will be the name you will use within your SharePoint configuration and which on the background will point to your real SQL Server.

  5. Now right click on the alias you just created and click on Modify

    SharePoint_SqlAlias_Regedit_ModifyAlias.png

  6. In the Value data field, enter the following:

    DBMSSOCN,<yourdatabaseserver.domain.com>,<sql port number>

    Replace the <..> fields with their actual values

    SharePoint_SqlAlias_Regedit_AliasValue.png

  7. Click OK to close the Edit String dialog window. You can now close the Registry Editor and use your SQL DB alias.