Sunday, February 19, 2012

Connecting Enterprise Manager on non-standard port?

Is it possible to configure Enterprise Manager to connect to a remote
server on a non-standard port, without changing the port for ALL of
the registered servers?
I see that I can use the Client Network Utility to change the "default
port" for TCP/IP. But I have several servers registered, and only one
of them uses a non-standard port.
One would think that the port should be one of the Server Registration
Properties, but it doesn't appear to be.
I found one thread that came close to addressing this question, but it
dead-ended before getting quite to the point:
http://groups.google.com/groups?hl=e...server.clients
When registering the server, use the following format:
servername, portnumber
e.g.
sqlabc, 5500
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Allan Cady" <allancady@.yahoo.com> wrote in message
news:d563b154.0412041625.534c2b@.posting.google.com ...
> Is it possible to configure Enterprise Manager to connect to a remote
> server on a non-standard port, without changing the port for ALL of
> the registered servers?
> I see that I can use the Client Network Utility to change the "default
> port" for TCP/IP. But I have several servers registered, and only one
> of them uses a non-standard port.
> One would think that the port should be one of the Server Registration
> Properties, but it doesn't appear to be.
> I found one thread that came close to addressing this question, but it
> dead-ended before getting quite to the point:
>
http://groups.google.com/groups?hl=e...ndard%2522%26m
eta%3Dgroup%253Dmicrosoft.public.sqlserver.clients
|||Excellent, that does the trick. Thank you!
Just out of curiosity... do you happen to know if this is documented
in BOL? I don't see it.
"Mike Epprecht \(SQL MVP\)" <mike@.epprecht.net> wrote in message news:<#FO4niu2EHA.3128@.TK2MSFTNGP14.phx.gbl>...
> When registering the server, use the following format:
> servername, portnumber
> e.g.
> sqlabc, 5500
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Allan Cady" <allancady@.yahoo.com> wrote in message
> news:d563b154.0412041625.534c2b@.posting.google.com ...
> http://groups.google.com/groups?hl=e...ndard%2522%26m
> eta%3Dgroup%253Dmicrosoft.public.sqlserver.clients
|||Hi
I have found any, but EM uses the same format as you would specify for a ADO
connection.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Allan Cady" <allancady@.yahoo.com> wrote in message
news:d563b154.0412051800.2250e979@.posting.google.c om...
> Excellent, that does the trick. Thank you!
> Just out of curiosity... do you happen to know if this is documented
> in BOL? I don't see it.
>
> "Mike Epprecht \(SQL MVP\)" <mike@.epprecht.net> wrote in message
news:<#FO4niu2EHA.3128@.TK2MSFTNGP14.phx.gbl>...[vbcol=seagreen]
http://groups.google.com/groups?hl=e...ndard%2522%26m[vbcol=seagreen]
|||It occurred to me that I can also do this (specify an alternate port)
by defining an alias for the server in the Client Network Utility.

No comments:

Post a Comment