Ok I'm trying to understand how a MSSQL Alias works but documentation is lacking to say the best.
Most blogs/videos/documents I can find state that all you need to do is go to
SQL Server Configuration Manager and add an
SQL Native Client Configuration \
SQL Native Client Configuration (32 Bit) which points to the same port as the instance you want to create an alias for. And that's it, done, nothing else required.
Now unless the SQL Server is in a domain, and allowed to register its own SPNs and only Kerberos is being used (and assuming that an alias gets its SPN automatically registered, which I can't find any documentation to either confirm or refute this statement)... I can't really see how this is enough!
I mean assuming that either the SQL box is not on the domain or that SPNs are not registered, if I create an alias called
SQL1 on port
1433 and, from a different computer, try to access
SQLTEST bearing in mind the lack of SPNs the first thing the client will do is try to resolve
SQLTEST to an IP address - yet there's no DNS record for
So how does this actually work? What are the true requirements to get aliases working?
And how does creating an alias differ from just creating an
CName records in DNS without actually creating an alias in SQL itself?