Post reply

Changing SQL port

  • July 11, 2008 at 2:57 am

    #841311

    From Gary L. Fry's post:

    Make sure that the port is indeed available. If it is not and you assign the port number of a port that is used the sql instance will not come online and when you attempt to change the port back to a unused port or dynamic port and bring the instance online it will fail again. When you look at configuration manager you will find that the bad port is there again.

    So that applications that request a dynamic port will not use the port desired for SQL Server, you will need to reserve the port. Please read "How to reserve a range of ephemeral ports on a computer that is running Windows Server 2003 or Windows 2000 Server" at http://support.microsoft.com/kb/812873/

    Also be sure not to reserve a port that is needed by another service.

    "Service overview and network port requirements for the Windows Server system" at http://support.microsoft.com/?kbid=832017#5

    For applications not provided by MS, search the internet for a list of common ports.

    SQL = Scarcely Qualifies as a Language

  • July 12, 2008 at 1:18 pm

    #842012

    ok thanks alot for help..:)

    ..>>..

    MobashA

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply