Monday, March 19, 2012

Can the port change automatically?

We were having problems with our SQL Server so we rebooted
it and when it came back up it was listening on a
different port.
Does anyone have any idea on how this could happen?
Thanks
Kris Bilou
If you specify 0 for the port number in the server network
utility, it will use a dynamic port.
And named instances will use a dynamic port.
-Sue
On Wed, 21 Apr 2004 08:21:26 -0700, "Kris Bilou"
<kbilou@.suncor.com> wrote:

>We were having problems with our SQL Server so we rebooted
>it and when it came back up it was listening on a
>different port.
>Does anyone have any idea on how this could happen?
>Thanks
>Kris Bilou
|||I understand the dynamic ports but we were using a static
port.
When I shut it down it was using 1245 as it should and was
specified in server newtwork. When I started it back up
it used 1246.
I didn't change it and there were no errors that 1245 was
in use.
[vbcol=seagreen]
>--Original Message--
>If you specify 0 for the port number in the server network
>utility, it will use a dynamic port.
>And named instances will use a dynamic port.
>-Sue
>On Wed, 21 Apr 2004 08:21:26 -0700, "Kris Bilou"
><kbilou@.suncor.com> wrote:
rebooted
>.
>
|||Dynamic ports. See Sue's post.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment