Got it

How Do I Change the IP Address Listened by the SQL Server Database?

Latest reply: Jul 25, 2018 11:22:03 919 2 0 0 0

Question

In case of a server IP address change, a connection error may occur on the SQL Server database. To remove the error, 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

  1. Choose Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Configuration Manager.

    The SQL Server Configuration Manager window is displayed.

  2. Click Protocols for MSSQLSERVER. In the right pane, right-click TCP/IP and choose Properties.

     

  3. 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.

This article contains more resources

You need to log in to download or view. No account? Register

x

Thanks for sharing with us.
View more
  • x
  • convention:

good info
View more
  • x
  • convention:

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.