Establish Remote Connection to Microsoft SQL Server Database

Establish remote connection in database using following process.

• 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.

See Also