Setting up SQL server multiple Names but within the same Database
Yes you can use a CNAME record in DNS
there are a few gotchas though so worth reading through the article
https://www.mssqltips.com/sqlservertip/2663/using-friendly-names-for-sql-servers-via-dns/
if you only need to &quot;rename &quot; the server from a single client there are other alternatives