December 10, 2008 at 10:12 am
Hello all. I have a SQL 2005 Server running two separate instances. It has one NIC bound to two separate addresses.
What I would like to do is have the default instance configured to use an assigned IP and port 1433, and the named instance to use the second IP, also port 1433.
I have been playing with the configuration in SQL Server Configuration Manager, to much frustration and a few choice swear words.
Does anyone have any specific experience with this? It is not as straightforward as the Manager would lead you to believe.
December 10, 2008 at 10:19 am
Just to make sure we're on the same page...
SSCM -> SQL Server 2005 Network Config -> Rightclick TCP/IP - properties-> Click IP Addresses Tab ?
You then change it and then restart the sql service?
Do you get error messages?
What does your log say? It should have messages saying what IP and ports it is listening on.
You would then need to configure DNS to route clients to the correct IP, right?
December 10, 2008 at 10:39 am
My two IPs are, let's say, 10.0.11.111 and 10.0.11.132. I have been running the default instance for years on IP1 (10.0.11.111). I have just installed the named instance, bound IP2 (10.0.11.132) to the same NIC, and am hoping to use this IP for the named instance.
I have a DNS name set up for the named instance, pointing to IP2. If I ping the DNS name I get a response from the server.
The problems are these:
If I open up Management Studio and connect to IP1 OR IP2 by IP address, and do not specify a port, it connects me to the default instance.
If I set the ports for the named instance to, say, 1218, and I connect to it by entering "10.0.11.132,1218" it will connect me to that instance.
If I try to set the ports on the named instance to 1433, the SQL Server service will not even start.
December 10, 2008 at 10:45 am
In the Config for the named instance, I changed the Enabled setting for 10.0.11.132 to "No". Then I was able to get the named instance to start with its ports set to 1433. However, connectiong to 10.0.11.132 still sends me to the default instance.
December 10, 2008 at 11:46 am
Wouldn't you want to set 111 to no for the named and 132 to no for the default?
December 10, 2008 at 1:09 pm
Yeah, one would think.
I now have about 95% of this worked out (in addition to a bad headache). I'll try to boil it all down to a step-by step and post when all is working.
December 10, 2008 at 2:27 pm
Have you tried the following---
open SQL Server Configuration Manager --> SQL Server 2005 Network Configuration -->Protocols for (whichever instance) --> right click on TCP/IP and go to Properties.
In the protocol tab change "Listen All" to "No".
Go to the IP Addresses tab and change IP1 to Enabled: Yes, change the IP Address to the one that you want to listen on, ensure that the "TCP Dynamic Ports" is blank and put 1433 as a value in "TCP Port".
Rinse and repeat on the other instance.
Restart both instances.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply