July 26, 2012 at 10:40 am
I'm trying to test using a DNS Alias to make consolidating instances a bit easier. I've had the DNS entry created (with a new IP address) and had it assigned to the server with the instance I'm testing. However when I open configuration manager I don't see an additional entry under the TCP/IP properties. I'm seeing IP1, IP2 and IPAll. I've tried rebooting the server & restarting the instance with no luck. The only suggestion I've seen on line is editing the registry which I would rather avoid. Does anyone have any suggestions?
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
July 26, 2012 at 12:08 pm
Back up the registry and edit away. In a test environment. That's all I can suggest.
I usually just stick with using instance names in the standard format. But if you have a lot of them, I can see wanting IPs/DNS entries that connect directly. Just haven't tried it before.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 26, 2012 at 12:40 pm
Specifically the plan is to try to find an easy way to move a bunch of instances to a single location.
So for example we have default instances on ServersA-D.
We can take a single server called SQLHost and create 4 named instances on it, point the IP addresses from the existing servers to SQLHost with DNS Alias' calling them by their original name. Then assign each of the 4 IPs to a different instance with port 1433. At that point move the databases from the original server to the new one and we are done. And it should be fairly transparent to the users.
I guess this weekend I will go with the registry change 🙂 Well after I check with my manager 😉
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
July 26, 2012 at 12:47 pm
I thought that you must always refer to the servername\instancename when using named instances. Therefore you cannot simply reference it by alias. It will know which server to go to, but then it will not find anything but the default instance. So, no matter what, you have to use servernameamedinstance. Am I correct in my thinking?
Jared
CE - Microsoft
July 26, 2012 at 1:54 pm
Actually I got the idea from a rather odd instance I have on a cluster. You can reference it as InstanceA/InstanceA, InstanceA, or ClusterName/InstanceA. And on the same cluster there is a 2nd instance that can be referenced as InstanceB/InstanceB or ClusterName/InstanceB but not InstanceB.
Took me awhile to figure it out. They had set up DNS entries for InstanceA and InstanceB on the cluster. Then in the Configuration Manager under TCP/IP settings for InstanceA the IP address for "InstanceA" has a port of 1433, and the IP address for ClusterName has a different port. Because InstanceA has a port of 1433 it can be addressed as if it was the default instance. Hence being able to call it as InstanceA.
InstanceB however did not have either port set to 1433 so no go there. The big test is going to be if I can have IP address 1 set to port 1433 on one instance and IP address 2 set to port 1433 on a different instance. I'll let you know how it goes.
Kenneth
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply