Forum Discussion
Santaforss
Oct 12, 2022Copper Contributor
Accessing SQL server on remote desktop on virtual machine via local desktop
Hi all, I am currently trying to access a Microsoft SQL server that is on a remote desktop. Accessing the database from within the remote desktop is ofcourse no problem. But, pinging to the ...
olafhelper
Oct 13, 2022Bronze Contributor
The virtual machine from which I can access the remote desktop has a different ip-address than the SQL server.
Santaforss , sure it has a different IP-address, two different machines can't have the same IP address.
Is it in a different subnet? Then may a routing is missing.
At all, that has nothing to do with SQL Server, but with network. So ask your IT dept to assist you and setup the reuqired routing.
Olaf
- SantaforssOct 13, 2022Copper ContributorThanks olafhelper , that already provides some clarity.
All I know is that the virtual machine from which the remote computer is accessible is a citrix workspace/pink elephant environment.
The end goal is to connect powerBI to the remoteSQL server, which does not work at the moment. But as I understand, this should be possible, right?- olafhelperOct 14, 2022Bronze Contributor
this should be possible, right?Santaforss , öhm, yes, if the network and the rest of infrastructre is setup the right way, the you should be able to connect.
But again, that's nothing SQL Server related, but to network.
Olaf