Can we install MS SQL Server (on windows) using a Virtual hostname and not the physical. Links would be appreciated
The installer binds a lot of values into the registry.
The only way to use a virtual name is to use a cluster either FCI or AOAG which has a client access point which isn’t the actual guest OS name the instance is running on.
What you can do though is use CNAMES in DNS so you can route via a cname to the actual A / AAAA record.
16 People are following this question.