Can a MS SQL Server be named different than host computer?
I have been searching for MS best practices but cannot seem to find if you are able to change the name of the SQL Server to be different than the host computer or if it's recommended not to do it.
If you installed default instance then your sql server name will be hostname XYSVC105
.
If you installed named instance e.g. sql01 then your sql server name will be XYSVC105\sql01
.
Below are few ways that you can use to have your application connect to the name you wish e.g. OPSRES
.
I would like to change the SQL Server name to something like "OPSRES".
You can create an alias and have your client applications use that in connection string.
Also, since you are using sql server 2014 - if you are using AlwaysOn Availablity group then you can just use listener (its a virtual network name (VNN) or Virutal IP (VIP)) and have your application use listener instead of host names.
You can even ask your DNS Admin to create Hostname Alias for a SQL Server Instance