Setting up a Native Client Alias

[David_Fergen]

Instructions for setting up a Native Client Alias:

The program name is CLICNFG.EXE and is usually under c:\windows\system32 

https://sqlandme.com/2011/05/05/create-sql-server-alias-cliconfg-exe/  

Enable the TCP/IP on the general tab and then add the individual replicas on the Alias tab. 

If you add an alias to force the connection to use TCP, make sure you set the instance name on the end of server name if using a non-default instance. 

NOTE: May have to use fully qualified name of SQL Servers. 

Here is a query you can use to find out if named pipes is enabled: 

  

SELECT 'Named Pipes' AS [Protocol], iif(value_data = 1, 'Yes', 'No') AS isEnabled 

FROM sys.dm_server_registry 

WHERE registry_key LIKE '%np' AND value_name = 'Enabled' 

UNION 

SELECT 'Shared Memory', iif(value_data = 1, 'Yes', 'No') 

FROM sys.dm_server_registry 

WHERE registry_key LIKE '%sm' AND value_name = 'Enabled' 

UNION 

SELECT 'TCP/IP', iif(value_data = 1, 'Yes', 'No') 

FROM sys.dm_server_registry 

WHERE registry_key LIKE '%tcp' AND value_name = 'Enabled'