Wednesday, March 21, 2012

E Manager port changes

Is there a way when you try to do a server registration in Enterprize Manager
(SQL 2000 version) to set which port it will connect on? I know the default
is 1433 but the one I want to register is on 1210 and can't be changed so I
need the Manager registration to try to connect on that port number. I know
the ODBC allows you to set the port to connect on but don't see that in EM.
Thanks!!
If you are trying to register a server use servername, port
ServerA,1210
Or are you trying to change the port the server listens on?
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Transam388" <Transam388@.discussions.microsoft.com> wrote in message
news:FFEB71DE-5705-48D2-A23D-AF72A2E9B824@.microsoft.com...
> Is there a way when you try to do a server registration in Enterprize
> Manager
> (SQL 2000 version) to set which port it will connect on? I know the
> default
> is 1433 but the one I want to register is on 1210 and can't be changed so
> I
> need the Manager registration to try to connect on that port number. I
> know
> the ODBC allows you to set the port to connect on but don't see that in
> EM.
> Thanks!!
|||OK, that was it. I tried doing the old telnet style IP : Port instead of a
comma. Thank you!! This is the best place for quick and USEFUL
information!! Thanks to both of you and merry Christmas!
"Kevin3NF" wrote:

> If you are trying to register a server use servername, port
> ServerA,1210
> Or are you trying to change the port the server listens on?
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Transam388" <Transam388@.discussions.microsoft.com> wrote in message
> news:FFEB71DE-5705-48D2-A23D-AF72A2E9B824@.microsoft.com...
>
>

No comments:

Post a Comment