So I have a SQL Server set up on a remote server machine. And I am trying to connect to this remote SQL Server via the local pc. I can connect with no problem using ServerDnsName, or ServerDnsName,1433\SQLEXPRESS.
But, what i would like is to connect with the same name for a Server name as on a remote server. This I want because I am using PowerBi on-premises gateway on a remote server. And I think it wants to use in PowerBI Desktop the same name for server login as on the remote server for login in SSMS.
These are the different names for a server that works either on local pc, or on the remote server, but none works on both:
- ServerDnsName,1433\SQLEXPRESS works on local, not on remote
- ServerDnsName works on local, not on remote
- ComputerName\SQLEXPRESS works on remote server, not on local
- ServerIp works on remote server, not on local
- ServerIp,1433\SQLEXPRESS works on remote server, not on local
How can I connect with the same name for a Server Name, in a Sql Server Managment Studio, on both local machine and remote Sql Server?
Thanks