Link to home
Start Free TrialLog in
Avatar of Marcusw
Marcusw

asked on

SQL Connection Errors

i have a vb6 program that connects to a sql 2000 database.

this program runs with no problems on my network.

however i have just setup a vpn.  when i run this program at my remote site, the first few times i recieved this error

-2147467259 (80004005)
data provider or order service returned an E_Fail status

but now i get the following error upon loading and cannot go any further


connection failed
sqlstate 'HY000'
error 0

a dialog box appears first asking for my login credentials for SQL 2000 which can either be trusted or just a straight user and password.

i have tried both but get the same error

what does this mean
Avatar of jkaios
jkaios
Flag of Marshall Islands image

This obviously relates to your VPN security.  Check to make sure that remote VPN connections are allowed to authenticate with the target SQL Server.
Avatar of Marcusw
Marcusw

ASKER

where would i check that setting
ASKER CERTIFIED SOLUTION
Avatar of jkaios
jkaios
Flag of Marshall Islands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial