Connecting to Remote SQL Server

waros · Post by **waros** » Wed Mar 24, 2004 7:38 am

Hi
I'm trying to install vault 2.0.1 on a win2kserver with all uppgrades. I want vault to connect to another win2kserver running sql server 2000.

I get "SQL connection failed" after supplying the 'sa' login & pw.

I also get
"The .NET Data SQL Provider (System.DataSqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later"

Both the Vault server and Sql server have all updates from windows update. How do i check which version I have? The SQL server doesn't have .NET framework installed (which it shouldn't have to?).

Regards

Post by **jclausius** » Wed Mar 24, 2004 9:02 am

waros:

yes, the .net sql server client side components require mdac for connection to your sql server. i don't believe it is necessarily installed with the .net runtime. see http://support.microsoft.com/default.as ... -us;315467 for more info.

you will need to download / install mdac on your vault server - http://msdn.microsoft.com/data/download ... CDownloads.