March 15, 2018 at 8:36 am
Hello,
need your genius minds on this, I am tested, but, i read online and not sure if it has been confirmed.
If I have a SQL server 2008 R2, SP3, windows 2008, no firewall on, instance name is SQL2008\SQL1
and i want to point to the new SQL server 2016, which is just the server name, SQL2016 (no instance name).
wondering if this can be done with just DNS CNAME that points SQL2008 to SQL2016? my Systems guy tells me he cant add the \SQL1, so do i need to also go into SQL Configuration manager on the SQL2016 server and create an Alias that says SQL2016\SQL1 to SQL2016?
i am testing it now... so far, my Management studio is only working if i type SQL2016 🙁 any input/advice will help.
March 15, 2018 at 10:11 am
ok, so i sorta answered my question, I had our system teams make a CNAME, and i made an SQL alias on the configuration, anything locally on the server that runs or even management studio, it will work, HOWEVER... anything outside of the server, like clients trying to connect to the SQL server, it will not work, so... my last question would be.. anyone have a work around for clients to connect to the SQL2016 using the Alias SQL2008\SQL1?
March 19, 2018 at 10:53 am
Siten0308 - Thursday, March 15, 2018 10:11 AMmy last question would be.. anyone have a work around for clients to connect to the SQL2016 using the Alias SQL2008\SQL1?
An alias is a client side piece so the alias needs to reside on the clients connecting to the instance.
Sue
March 21, 2018 at 3:17 pm
no alias is needed - use a fixed port number for each instance
e.g. SQL2008\SQL1 uses fixed port 1433 and SQL2016 uses fixed port 2433
Just add the port number to the server NetBIOS name
e.g. SERVERNAME,1433 for SQL2008\SQL1 and SERVERNAME,2433 for SQL2016
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply