SQL Database Concepts Question:
Download Questions PDF

Do you know how to make remote connection in database?

Basic SQL Server Interview Question
Basic SQL Server Interview Question

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

Download Basic SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
Explain how to use Linked Server?Do you know how to send email from database?