Is it possible to Reverse Engineer a database which is located on a server that can only be accessed via VPN?
When entering the connection details in the Connecting tab of the Reverse Engineering Wizard, the connection to the database fails.
RESOLUTION1:
Configure the Remote SQL Server to allow SQL Server Authentication and create a login/password on the remote SQL Server.
Then use this login/password to connect to the database in Toad Data Modeler.
RESOLUTION2:
Have your Network Admin on the remote set up a 'Trust' relationship between the Domains, where their DC will 'trust' the credentials ('hall pass') from your network.
For further information on how to connect to a SQL Server database over a VPN connection, please refer to:
http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/ef063bed-5daa-41a8-9323-7c2be8ef2bf3
