E Manager port changes

Is there a way when you try to do a server registration in Enterprize Manage
r
(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!!You will need to use the Server Network Utility to change ports.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"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!!|||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...
>
>

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...
>
>