question

rer avatar image
rer asked

Virtual Hostname for SQL 2019 server

Can we install MS SQL Server (on windows) using a Virtual hostname and not the physical. Links would be appreciated

virtualization
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
anthony.green avatar image
anthony.green answered

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.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.