Confused about Configuration Manager's TCP/IP settings

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

Configuring SQLMail on Standalone PC

Hi,
I want to try some programs using SQL Mail on my Local/Standalone PC.
I do not have a network connection and only have a dialup connection.
How do I setup/configure SQLMail in SQL2000? When I read about it, it
says that I need to have mailbox/profile setup. But I don't have
Exchange Server too.
Somehow I got hold of Exchange Server 2000 120-Eval edition. But I am
unable to install the same, because it says that it needs Active
Directory to be setup first.
Now my Win2K Server is already installed and I don't have Active
Directory setup. Is it possible to setup Active Directory on a
Local/Standalone PC which doesn't have Network card.
Please let me know if there is any possible way to write and test some
programs on a Standalone Win2K Server with is not connected to any
server. What will be the prerequisites of Standalone PC to use
SQLMail locally for testing purpose.
Thanks,
KamleshCan you use SMTP instead? http://www.aspfaq.com/2403
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Kamlesh" <kamlesh2000@.yahoo.com> wrote in message
news:2644c0f6.0311212150.7bba5122@.posting.google.com...
> Hi,
> I want to try some programs using SQL Mail on my Local/Standalone PC.
> I do not have a network connection and only have a dialup connection.
> How do I setup/configure SQLMail in SQL2000? When I read about it, it
> says that I need to have mailbox/profile setup. But I don't have
> Exchange Server too.
> Somehow I got hold of Exchange Server 2000 120-Eval edition. But I am
> unable to install the same, because it says that it needs Active
> Directory to be setup first.
> Now my Win2K Server is already installed and I don't have Active
> Directory setup. Is it possible to setup Active Directory on a
> Local/Standalone PC which doesn't have Network card.
> Please let me know if there is any possible way to write and test some
> programs on a Standalone Win2K Server with is not connected to any
> server. What will be the prerequisites of Standalone PC to use
> SQLMail locally for testing purpose.
> Thanks,
> Kamlesh