Connection Data Source name

Question

Hi,

I'm a little stumped here. I have a server I inherited that allows connections from an alias. The windows server is hosted on an AWS EC2 instance.

AWS EC2 Server host name = sql123
I can also connect using = cubes.com (as in connecting to ssas/sql engine or connecting using client tools-excel- using the connection string Data Source)
cubes.com allows the connection string to remain the same for users if the data source is moved to another server.

I thought it was an alias in the DNS but I can't see this set up. Is there anywhere else I should be looking?

Any help would be appreciated.

Thanks

Answer 1

An alias can be defined in "hosts" files, located in folder
C:\Windows\System32\drivers\etc\
it's a simple text file with host name + IP address. => Host Names and IP Addresses

For SQL database engine you can define a "SQL Alias" on the client machine
Create or Delete a Server Alias for Use by a Client

Answer 2

Hi Cidr-4920,
Welcome to Microsoft Q&A.
Could you please share us the connection string you are using?
I think you may use the Fully Qualified Domain Name (FQDN) to connect to SQL Server.
For default instance, the format is computer_name.domain_name .
You can go to Control Panel –>System and Security –> System-> Computer name, domain and workgroup settings to check if the domain name is cubes.com.

You also can check it from the Domain Controller-> DNS manager->Forward Lookup Zones->domain name-> right-click the host name->Properties.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.