troubleshooting Question

Attach to SQL server via VPN

Avatar of frdbadf
frdbadf asked on
Microsoft SQL ServerVPNMicrosoft Server OS
11 Comments3 Solutions687 ViewsLast Modified:
We have T1 connection using CBeyond.  We use their VPN tool to connect remotely using a VPN connection created in XP network connections.  The server we are connecting to using Terminal Services/Remote Desktop  is not a domain controller but a member of a domain.  We can connect to that server but only if the user is local to the server ie, username, not domain\username.  So far so good since we have been able to use shared resources.

The problem is that we have an applicaton that requries XP SP2.  We tried to install the application at the remote locations by connecting to the VPN thus acquiring an IP address on the remote LAN and access to shared resources however the application needs to use SQL server which is on another server located on the remote LAN.  The SQL server is not installed on the server we are using as the Terminal Services server but on another DC on the same LAN.

Can SQL server be seen as a shared resource or are we doing something wrong in our approach?

thanks,
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 11 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros