Access to SQL Server by SQL Query Analyzer or Management Studio

Access to SQL Server by SQL Query Analyzer or Management Studio

Image result for Access to SQL Server by SQL Query Analyzer or Management Studio

As Acumatica runs on SQL server, we may need, time to time to access our Database by Management Studio. And there could be connectivity issue if we try it, just out of the box…

Most of the times, since we are on the cloud, the SQL server is somewhere outside, not in our office. To access it, we need to follow three simple steps:

1. Open up firewall on SQL server side for the port used by SQL Server for listening.
2. Make sure we specified correct port on the SQL server properties.
3. Make sure on the CLIENT side we choose the same port to access the server.

First.
Open the firewall for SQL port 1433 for Inbound Connections. This need to be done AT THE SERVER SIDE. So please Remote to the server then open this up:

The post Access to SQL Server by SQL Query Analyzer or Management Studio appeared first on Big Data Made Simple – One source. Many perspectives..

Big Data Made Simple – One source. Many perspectives. » SQL

Share: