Remote Access to Microsoft SQL Database Server

Remote access to a SQL server is important because it allows users to access the server from anywhere, at any time. This enables remote workers to access the data they need when they need it, even if they are not physically in the same location as the server. It also allows IT admins to access the server from any location to provide support and troubleshoot any issues, without having to be physically present. Remote access also increases security, as admins can monitor the server from any location and can quickly react to any threats or suspicious activities.

1) Configure Microsoft SQL Server database for Remote access :

1. Launch Microsoft SQL Server Management Studio.
2. Connect to Database with the help of windows authentication.
3. Right click on Server > Navigate to Properties > Connections.
4. Click on Allow Remote connection to this server.

5. Click OK and save the changes.

2) Configure the SQL Server Configuration Manager :

1. Launch SQL Server Configuration Manager.
2. Navigate to SQL Server Network configuration.
3. Right click on TCP/IP > Enable.
4. Once TCP/IP is enabled, right click again on TCP/IP > Properties > IP Addresses > IPAll.
5. Provide SQL port 1433 under TCP Port > Click on Apply > Click on OK.
6. In the SQL Server Configuration Manager, select SQL Server Services  and restart all services.
Note : Restart is required to make the changes to come into effect.
7. If services are in a stopped-state, then follow the below-mentioned steps to start services.

Note : SQL port (1433) should be allowed in the firewall if the user is accessing from a different network.

3) Access SQL server Database :

1. Navigate to Microsoft SQL Server Management Studio and click on connect.(From where you want to access)
2.  Provide the SQL Server name (IP address of machine where SQL Server database is hosted)
3. Provide the Username of SQL server database.
4. Provide the Password of SQL server database and click on Connect.

5. Now you will be able to access the database.

Leave A Comment

Your email address will not be published. Required fields are marked *