Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Using a static port Expand / Collapse
Author
Message
Posted Tuesday, August 14, 2012 9:50 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:00 AM
Points: 590, Visits: 1,582
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

Post #1344822
Posted Tuesday, August 14, 2012 10:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:34 AM
Points: 6,166, Visits: 13,309
you're opening the SQL Server configuration manager program, correct?


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1344830
Posted Tuesday, August 14, 2012 10:12 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:00 AM
Points: 590, Visits: 1,582
I am indeed
Post #1344845
Posted Tuesday, August 14, 2012 10:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:34 AM
Points: 6,166, Visits: 13,309
can you post a screenshot of what you see?

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1344858
Posted Tuesday, August 14, 2012 10:30 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:42 PM
Points: 23,003, Visits: 31,493
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



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1344864
Posted Tuesday, August 14, 2012 10:58 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 2:28 PM
Points: 33,062, Visits: 15,174
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.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1344885
Posted Wednesday, August 15, 2012 2:01 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:00 AM
Points: 590, Visits: 1,582
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?
Post #1345148
Posted Wednesday, August 15, 2012 4:37 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:00 AM
Points: 590, Visits: 1,582
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
Post #1345201
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse