Answers

Question and Answer:

  Home  Basic SQL Server

⟩ Do you know how to make remote connection in database?

The following is the process to make a remote connection in database:

Use SQL Server Surface Area Configuration Tool for enabling the remote connection in database.

Click on Surface Area Configuration for Services and Connections.

Click on SQLEXPRESS/Database Engine/RemoteConnections

Select the radio button: Local and Remote Connections and select ‘Using TCP/IP only’ under Local and Remote Connections.

Click on OK button / Apply button

 127 views

More Questions for you: