Explain how to make remote connection in database?

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

  1. Use SQL Server Surface Area Configuration Tool for enabling the remote connection in database.
  2. Click on Surface Area Configuration for Services and Connections.
  3. Click on SQLEXPRESS/Database Engine/RemoteConnections
  4. Select the radio button: Local and Remote Connections and select ‘Using TCP/IP only’ under Local and Remote Connections.
  5. Click on OK button / Apply button
Tagged . Bookmark the permalink.

Leave a Reply