July 6, 2016 at 5:52 am
We installed a named instance called MyInstance_AG (different other instance than my previous question). When I filled out a form with our corporate office to get an IP address and DNS record for this instance, we found out that corporate won't allow requests that include an underscore character due to DNS issues. So I filled out the form as MyInstance-AG (which SQL won't allow as an instance name).
The thought is we can create an alias in SQL configuration manager with MyInstance-AG as the alias name pointing to MyServer\MyInstance_AG.
Does anyone see any problems with this setup?
July 6, 2016 at 7:27 am
Hi Brandie, to un-complicate things, why not just name the named instance "MyInstanceAG", then the named instance connection would be servername\MyInstanceAG. This way, you do not have to make any aliases or violate any DNS rules and you stay within your corporate guidelines.
July 6, 2016 at 7:32 am
RVarn (7/6/2016)
Hi Brandie, to un-complicate things, why not just name the named instance "MyInstanceAG", then the named instance connection would be servername\MyInstanceAG. This way, you do not have to make any aliases or violate any DNS rules and you stay within your corporate guidelines.
The named instance is already installed. So far as I know, there is no way to rename an instance without uninstalling and reinstalling it. Plus the way our corporate office works, if I change the paperwork, I have to close out the ticket and lose my place in line while I create a new ticket.
We are on a tight deadline with this, unfortunately.
July 6, 2016 at 8:06 am
Sorry, I completely overlooked the beginning statement that the instance was already installed. You could give an alias a try. One thing to remember with a named instance you will want to make the instance's port number a "static" one by going into the configuration manager and defining the port number. Then, when you set up the alias in configuration manager you will specify that port in the alias definition.
July 6, 2016 at 9:40 am
Please note that the configuration manager alias section is for that computer only it is not an alias for remote incoming connections as the GUI and naming might suggest.
All other machines that you want to use this "alias" for will also need the configuration management tool to setup the same alias.
July 6, 2016 at 11:54 am
Smendle (7/6/2016)
Please note that the configuration manager alias section is for that computer only it is not an alias for remote incoming connections as the GUI and naming might suggest.All other machines that you want to use this "alias" for will also need the configuration management tool to setup the same alias.
Actually it often works for remote incoming connections for us. When we don't have multiple instances on the same machine, that is.
July 6, 2016 at 11:55 am
Thanks all. Just wanted to make sure I wasn't too off base with all this.
July 6, 2016 at 12:06 pm
Completely off topic, but what is the reasoning for not allowing an underscore in the name for DNS?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply