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
|