Tuesday, February 14, 2012

Changing default port

I know this is not rocket science but I can't get it done. Used the Network
Utility to change the default port but SQL still says still listening on
1433. Stped-restarted the instance and then the entire server. Nothing else
is using the new port....netstat, Port Query, show nothing connected. Any
ideas?"Monty" <montysl@.nospam.hotmail.com> wrote in message
news:OqmQK1IgEHA.592@.TK2MSFTNGP11.phx.gbl...
> I know this is not rocket science but I can't get it done. Used the
Network
> Utility to change the default port but SQL still says still listening on
> 1433. Stped-restarted the instance and then the entire server. Nothing
else
> is using the new port....netstat, Port Query, show nothing connected. Any
> ideas?
That should have been enough to change the port assignment, check the
following article in case you missed something:
http://support.microsoft.com/defaul...kb;en-us;823938
Steve|||Just out of curiosity, are you using the Client Network Utility or the
Server Network Utility.
If it is the latter when you go back and check the setting does it reflect
the new value or 1433?
Rand
This posting is provided "as is" with no warranties and confers no rights.

No comments:

Post a Comment