Contents
To do this, follow these steps:
- Make sure that you use a user account that’s a member of the following:
- Start the SQL Server Client Network Utility (cliconfg.exe).
- On the General tab, verify that TCP/IP is enabled.
- On the Alias tab, click Add.
- In the Server alias box, enter the name of the new SQL Server alias.
SQL Aliases are optional (but recommended), and are a great way to configure your SharePoint environment. They allow for flexibility in case the SQL instance is changed, or the server names/IPs change then it’s possible to only “re-point” to the new servers. SQL Aliases are configured on each SharePoint Server.
How do I detach a content database in SharePoint 2013?
On the Application Management page, in the Databases section, click Manage content databases. Select the web application for which you want to detach a content database. Click the content database that you want to detach. On the Manage Content Database Settings page, select the Remove content database check box.
How are SQL aliases configured on a SharePoint Server?
SQL Aliases are configured on each SharePoint Server. This is very important to remember! Let’s dive in and configure our aliases. On Windows Server 2012 R2 & Windows Server 2016, we have an utility called cliconfg. There are 2 versions: 32-bit and 64-bit.
Where do I enter alias for SQL Server?
Server name => The SQL Server’s name ( for default instance) or ServerName\\Instance ( if named instance) Now when installing SharePoint, enter the alias when asked for the database server.
If you’re moving from a single-server farm to an AlwayOn Availability Group then you should use the cliconfg.exe. This procedure must be performed on all servers in the SharePoint Server farm that connect to the instance of SQL Server that hosts the databases.
How to change the name of a SharePoint Server?
In the Network libraries area, click TCP/IP. In the Connection parameters area, in the Server name box, enter the new server name and instance to associate with the alias, and then click OK. This is the name of the new server that is hosting the SharePoint Server databases.