Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Using a static port
Add to briefcase

Using a static port Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Kwisatz78
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: 2 days ago @ 7:53 AM
Points: 547, Visits: 1,412
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
Perry Whittle
Posted Tuesday, August 14, 2012 10:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:11 AM
Points: 5,242, Visits: 11,262
you're opening the SQL Server configuration manager program, correct?

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1344830
Kwisatz78
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: 2 days ago @ 7:53 AM
Points: 547, Visits: 1,412
I am indeed
Post #1344845
Perry Whittle
Posted Tuesday, August 14, 2012 10:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:11 AM
Points: 5,242, Visits: 11,262
can you post a screenshot of what you see?

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1344858
Lynn Pettis
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 @ 9:46 AM
Points: 21,832, Visits: 27,858
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
Steve Jones - SSC Editor
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 @ 5:09 AM
Points: 31,526, Visits: 13,864
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
Kwisatz78
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: 2 days ago @ 7:53 AM
Points: 547, Visits: 1,412
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
Kwisatz78
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: 2 days ago @ 7:53 AM
Points: 547, Visits: 1,412
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.