Recovery Manager for SharePoint Premier Edition
Migration Manager for Sharepoint
Server Administrator for SharePoint
Migration Suite for SharePoint
Migrator for SharePoint Online
Original article is here:
Some applications can not use a connectionstring on a given TCP port number or a named database instance. This can be solved by a SQL Alias. Usually this is created using SQL Server Configuration Manager, but a installation of SQL Server Client Connectivity is actually not required.
A SQL Alias can be created as a Connectivity alias using the tool"cliconfg.exe", that is a part of Windows Data Access Components (WDAC, formerly MDAC).
The "cliconfg.exe" comes in two builds
IMPORTANT: Since Site Admin is 32 bit applications we need to create 32 bit Alias.when you are on a 64-bit (x64) Windows. On a 64-bit Windows the 64-bit "cliconfg.exe" is default.Usually you have to be local administrator to add a new alias.Any SQL Alias if it is 32-bit or 64-bit created by "cliconfg.exe" can be created and edited in SQL Server Configuration Manager if the SQL Client Connectivity is installed.
The registration of a SQL Alias is placed in the registry:
Like any other entry in the registry they can be managed by the native API or by Windows Management Instrumentation (WMI) using a COM tool like Windows Scripting Host (WSH) by JScript or using a .NET tool like PowerShell.
The PowerShell cmdlet New-ItemProperty can be used like this:
[String]$RegPath = 'HKLM:\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo'[String]$RegName = 'SPSQL'[String]$RegData = 'DBMSSOCN,DBSERVER.bacon.lan,54321'New-ItemProperty -Path $RegPath -Name $RegName -PropertyType String -Value $RegData
DBMSSOCN is the TCP/IP network libary.
Jennifer LuPiba is a senior product marketing manager on the Dell Software Windows Management team, helping organizations embrace the cloud, deliver next-generation applications, reduce risk and increase efficiency and enable the modern work styles.