SQL

Access to SQL Server by SQL Query Analyzer or Management Studio

05th May `14, 08:02 AM in SQL

As Acumatica runs on SQL server, we may need, time to time to access our Database by Management…

BDMS
Guest Contributor
 

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:

Read More
MORE FROM BIG DATA MADE SIMPLE