I need another opinion about the SQL Server Configuration Manager's TCP/IP settings...
Recreation steps:
Start, (All) Programs, SQL Server 2005, Configuration Tools, SQL Server Configuration Manager.
Expand the "SQL Server 2005 Network Configuration"
Select the "Protocols for x" where "x" is the named-instance or "MSSQLServer" for default.
On the right-hand pane, right-click "TCP/IP" and select "Properties."
Select the "IP Addresses" tab.
Visually on the screen I have this:
- IP1
Active Yes
Enabled No
IP Address 106.xx.xxx.xx
TCP Dynamic Ports
TCP Port 1433
- IP2
Active Yes
Enabled No
IP Address 127.0.0.1 <-loopback
TCP Dynamic Ports
TCP Port 1433
-IPAll
TCP Dynamic Ports
TCP Port 1433
Questions:
1. If I want to change the listening port, I change all three at the same time?
1a. Does a value in the IPAll section override the individual IPx sections?
2. What does "enabled" mean? How can IP1 and IP2 not be enabled?
3. What does "active" mean? How can something be both active yet not enabled?
(4. Any plans to change the "NULL=False, 0=True" values for the Dynamic Ports?)
Hey Jeff,
answers to some of your questions (from Configuration Manager "help"):
Use the TCP/IP Properties (IP Addresses Tab) dialog box to configure the TCP/IP protocol options for a specific IP address. Only TCP Dynamic Ports and TCP Port can be configured for all addresses at once by selecting IP All.
Active
Indicates that the IP address is active on the computer. Not available for IPAll.
Enabled
If the Listen All property on the TCP/IP Properties (Protocol Tab) is set to No, this property indicates whether SQL Server is listening on the IP address. If the Listen All property on the TCP/IP Properties (Protocol Tab) is set to Yes, the property is disregarded. Not available for IPAll
Thanks Kevin. Hey, we could use someone like you on our team!
But this is still a miscommunication issue. Follow-up was posted on the MS Feedback Center...
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=151162
No comments:
Post a Comment