How to Connect to MSSQL Server Remotely?

How to Connect to a MSSQL Database Server Remotely?

Remote Database Connection in MSSQL

Sometimes it is required to access the database from your local machine or computer. Or else you need to connect from any other remote location. In such cases, remote MSSQL Database connection would help you.Follow the steps below, to connect MSSQL Database from remote location.
Step 1: Open Microsoft SQL Server in your computer.
Step 2: Enter the server name, choose authentication type as Server Authentication, enter the username and password and click Connect.
Connect To Mssql Remotely
Step 3: Once connected, you can access your database listed on the top left side.
Access Mssql Database Remotely
Step 4: You can create tables, views etc, in the database.


Related Topics

Parallels Plesk Panel Version 12.5