connect to Navision

AST

hello,
I have SQL Navision client instaled outside local net. I use VPN with firewall. Which port should be unlocked to connect ?

kriki

None, you should use Citrix or Remote desktop to connect to your database.
Navision sends a lot of data from server to client (a little less from client to server)
Or you should have a good connection (100MB) between client and server.
In this case you should look in the services file to see which ports SQL uses.

[Topic moved from Navision forum to SQL General forum]

bbrown

The default port would be 1433 (SQL Server). But follow the above advice.

garak

first check on wich port your sql server work. Normaly its the 1433. but the server can also be configured with dynamic port. so with every reboot a new port can be used. This you can check under SQL-Server-Networkconfiguration.

But in a VPN it's better to use citrix or MS remote server.

regards