Sunday, March 11, 2012

Enterprise Manager Port?

What port does SQL Server Enterprise Manager need open to connect to a
remote database? I'm not finding documentation on this.Shabam
By default SQL Server uses port 1433. This is the port Enterprise Manager
will attempt to use when connecting to SQL Server. If the SQL Server you are
attaempting to connect to was set up to use another port you will need to
use the SQL Server Client Network Utility to set up an alias to the port
being used.
Hope this helps
John
"Shabam" wrote:

> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>
>|||It's up to the Remote SQL Server and the client network utility. By default
named pipes and TCP port 1433 (UDP port 1434 is a broadcast port for server
name but not necessary) Check the SQL Error log on the remote server to see
what protocol it is listening on. Then check the SQL Server client network
utility on your workstation. Create an alias if necessary.
"Shabam" <chalupa@.yomama-nospam.com> wrote in message
news:3bidnexq3dFh_6TfRVn-gg@.adelphia.com...
> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>

No comments:

Post a Comment