How Do I Change the IP Address Listened by the SQL Server Database
Question
In case of a server IP address change, a connection error may occur on the SQL Server database. To rectify the fault, change the server IP address listened by the SQL Server database. How do I change the IP address listened by the SQL Server database?
Answer
- Choose Start > Microsoft SQL Server 2012 > SQL Server Configuration Manager.
The SQL Server Configuration Manager window is displayed.
- Choose SQL Server Network Configuration > Protocols for MSSQLSERVER. In the right pane, right-click TCP/IP and choose Properties.
Here, MSSQLSERVER indicates a SQL Server database instance name. It must be replaced by the actual instance name.
- In the TCP/IP Properties dialog box that is displayed, set the IP address listened by the SQL Server database to the IP address of the eSight server, and click OK.
- In the Warning dialog box that is displayed, click OK.
- Restart the SQL Server database.