Multihomed windows 2003 server

For that reason, this article assumes that you will configure SQL Server to listen on a fixed port. The other ports that are the different SQL Server components use can be configured by using the same general steps. If you already know the IP addresses available to your computer and that are used by SQL Server, you can skip these procedures. The ipconfig command sometimes lists many possible connections, including connections that are disconnected. The ipconfig command can list both IPv4 and IPv6 addresses.

Note the IPv4 addresses and IPv6 addresses that are being used. But this information is not used in this example.

One of these is for the IP address of the loopback adapter, This example uses fixed ports instead of dynamic ports which could change upon restart. For this example, assume that both IP addresses are listening on the default port, After you know the IP addresses that the computer uses and the ports that SQL Server uses, you can create firewall rules, and then configure those rules for specific IP addresses.

Click Start , click Run , type wf. You could create a rule for the SQL Server program. However, because this example uses a fixed port, select Port , and then click Next.

Select Specified local ports. Type the port numbers separated by commas, and then click Next. In this example, you will configure the default port; therefore, enter On the Action page, review the options. In this example, you are not using the firewall to force secure connections. Therefore, click Allow the connection , and then click Next. Your environment might require secure connections.

If you select one of the secure connections options, you might have to configure a certificate and the Force Encryption option. The other network doesn't use a default gateway.

It is just used for backups. This is driving me crazy because all I want is a weekly system state backup and for some reason Netbackup will not work unless I have the 2nd nic activated.

Hi Norman,. Uncheck "Register this connection's address in DNS". Click OK double times. Wilson Jia. Office Office Exchange Server. Not an IT pro? Windows Server TechCenter. Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Directory Services. Sign in to vote. I want to keep this port from showing up in DNS. Is there way to do this? Thank you.

Rob Williams. Most Points The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics. Join our community to see this answer! Unlock 1 Answer and 6 Comments. Andrew Hancock - VMware vExpert. See if this solution works for you by signing up for a 7 day free trial. What do I get with a subscription? With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros.

We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need. Who are the certified experts? How quickly will I get my solution?