Post reply

Using a static port

  • August 14, 2012 at 9:50 am

    #280258

    I am wanting to use a static port for SQL but something that has always confused me with the following article.

    http://msdn.microsoft.com/en-us/library/ms177440(v=sql.100).aspx

    It mentions to right click and select properties to identify the IP port to configure, however this option does not exist. In which case how do I know which IPn address to configure?

    Thanks

  • August 14, 2012 at 10:01 am

    #1525619

    you're opening the SQL Server configuration manager program, correct?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • August 14, 2012 at 10:12 am

    #1525633

    I am indeed

  • August 14, 2012 at 10:27 am

    #1525642

    can you post a screenshot of what you see?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • August 14, 2012 at 10:30 am

    #1525646

    Kwisatz78 (8/14/2012)

    I am wanting to use a static port for SQL but something that has always confused me with the following article.

    http://msdn.microsoft.com/en-us/library/ms177440(v=sql.100).aspx

    It mentions to right click and select properties to identify the IP port to configure, however this option does not exist. In which case how do I know which IPn address to configure?

    Thanks

    Just to make it easier for others to see what you are referencing:

    http://msdn.microsoft.com/en-us/library/ms177440(v=sql.100).aspx

  • August 14, 2012 at 10:58 am

    #1525666

    The IP address is a field in the IP8, IP5 sections. If it's a large HEX address, it's an IPv6 address. IPv4 ones are shown as the normal 192.168.0.10 nomenclature.

  • August 15, 2012 at 2:01 am

    #1525892

    Hi - Just to show you what I mean here is a screenshot of what I was doing, (sorry its so big) as you can see when I right click on the IP address there is no properties option.

    As this was the only IP address and bearing in mind what Steve said then the instance must be the one highlighted.

    Also another weird thing is, I have changed the default instance to use 7979 and my named instance to use 7980 by changing the value in the IPAll section. Now if I try to connect to my default instance on 7979 it connects correctly, if I connect to SERVER\WEB instance on 7980 it connects correctly, however it also allows me to connect to SERVER\WEB on port 7979 and brings up the default instance databases.

    Surely that can't be right, or have I set my ports incorrectly?

  • August 15, 2012 at 4:37 am

    #1525938

    Ok I have been playing around with this and have come to the conclusion that I can connect to either SQL instance as long as the port has been specified because there is only one IP on the server.

    i.e I can connect to the same instance by putting in SERVER,port or SERVER\INSTANCE,port

Viewing 8 posts - 1 through 7 (of 7 total)

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