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?