8

SQL Server reliance on Domain Controller

view full story
linux-howto

http://serverfault.com – Just have had an interesting situation with a remote database server which I did not think happened. The setup is server A is a domain controller in the main network, and server B is on a remote network connected back via VPN. Server B has SQL Server 2008 on it. There is an application running on server B that for the purposes of this discussion, just inserts/queries the database every minute. Today the VPN dropped out for a tad over 30 minutes due to some network problems between the 2. Database queries are done using trusted_connection=sspi; credentials, and worked for maybe the first 2 (HowTos)