Which ports to open for SQL server

[Zargo]

Hi all,

I know that 1433 is the default port to open for SQL server. Are there other ports to open when i want to communicate with my sql server (from my client machine) to fire some queries and show this in my application at the client side?

At the moment i'm getting sql server does not exist or access denied messages.

I appreciate any idea.

Rgrds,

Zargo

 

[jrbarnett]

You want TCP port 1433 and UDP port 1434, unless your SQL server is on a named instance (in which case the port is dynamically assigned at startup).

John