![sql native client 10 alias sql native client 10 alias](https://4.bp.blogspot.com/-fSenvP0YAnM/VLBk8K2EANI/AAAAAAAAAbs/HzaRpHU7xX8/s1600/Step2.png)
![sql native client 10 alias sql native client 10 alias](https://www.sqlshack.com/wp-content/uploads/2019/10/alias-details.png)
Write-Output "Alias $Name already exists" Write-Output "Alias $Name created successfully!" $subkey.SetValue($Name,"DBMSSOCN,$SQLServerName,$Port") Write-Host "Unable to create the key '$key' in '$parentKey' on machine '$machine'. Please verify that the SQL Client Tools are installed." Write-Host "Parent key not found in the registry of '$machine'. $parentTemp = $reg.OpenSubKey($parentKey,$true) # The key doesn't exist, open the parent key and create the subkey. $subkey = $reg.OpenSubKey($parentKey + $key, $true) Please verify that the remote registry service is running and that you have administrative access to that machine." Write-Host "Unable to connect to the registry of machine '$machine'. $reg = ::OpenRemoteBaseKey($hive, $machine) # Connect to the registry (also works for remote machines) # If the $Machine parameter was not provided, use the local machine. $parentKey = "SOFTWARE\\Microsoft\\MSSQLServer\\Client\\" Add-SQLServerAlias -Name "SHPDB" -SQLServerName "SRV-CTG-SQL01" -Port 1433 -Machine SRV-CTG-SHP01 The only thing this tool does, is create a string value in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo If you don’t want to do this manually, there’s also a way of doing this with PowerShell. You can also select a custom port if you use TCP/IP or keep the default. You provide a name, the type of connection (Named Pipes, TCP/IP) and a server name. In this tool, you have an “Alias” tab, where you can set it. As you can see from Figure 6, aliases created by SQL Server Configuration Manager can be seen by the SQL Server Client Network Utility. To view or create aliases, click on the Alias tab (Figure 6). When you want to set an alias, you run cliconfg.exe on each SharePoint server. To bring up the utility, click on Start, then Run, and run cliconfg.exe. Definately not cool because when someone looks at the Servers in Central Administration, it will list the old name and it’s not clear that this is not a server anymore but an alias.
#SQL NATIVE CLIENT 10 ALIAS INSTALL#
If you install SharePoint and you reference the database server directly, your only way of pointing SharePoint to the new database server painlessly, is to create an alias at that time, set the name of the alias to the name of the old database server and have it point to the new server. If you use an alias, the only thing you need to do at that moment, is change the target of your alias and you’re good to go. Setting a SQL alias is a best practice because it makes your life a whole lot easier when you want to change the actual database server in some point of time. This tool is available on every SharePoint server because it’s part of the SQL Server Native Client prerequisite. You use the SQL Server Client Network Utility (cliconfg.exe) for this. Setting a SQL alias on every SharePoint server is a common task when you are installing SharePoint.