SQL Database Concepts Question:

Do you know how to make remote connection in database?

Tweet Share WhatsApp

Answer:

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

Read All 113 Basic SQL Server Questions
Previous QuestionNext Question
Explain how to use Linked Server?Do you know how to send email from database?