It's been a long time since I set up a 2012 server. We have an emergency where we have to set up a new one but can't upgrade for a few months, so we're doing another 2012 and I'm having issues with the SSMS connection string.
Most of our servers we can connect remotely to using just the named instance. Think MickeyTest. We have a CName DNS record pointing to the server and we can use SSMS to connect to MickeyTest instead of using MyServer\MickeyTest. I've set up the CName for this new instance but have to use the MyServer\MickeyTest_2 instead of MickeyTest2. I tried setting up aliases in SQL Configuaration Manager, but if I use a port other than 1433, I have to connect using MickeyTest_2,Port# instead of MickeyTest_2. If I use 1433, I can connect with just MickeyTest_2.
I tried configuring the alias using the Cliconfig.exe but that didn't work either.
What am I missing here that could allow me to either use dynamic port numbers or a non-default port number to connect via SSMS with just the named instance?
No other instances exist on this new server.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.