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.

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

>--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[vbcol=seagreen]
>.
>|||Dynamic ports. See Sue's post.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.