Question Locked

Connection Failed SQL server error 768

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,

We have an unusual setup at where we have an MSACCESS application(access 97) front end on a NT4 server that links to an SQL 2005 database running on a HP Proliant Server 2003 server. This works well mostly but when we have to import a large file into the SQL server it times out after about 15 minutes with the following error:

Connection failed:
SQLState: '01000'
SQL Server Error: 768
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(SECDoClientHandshake()).
Connetion failed:
SQLState: '08001'
SQL Server Error: 18
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] SSL Security error

Now we have a domain trust setup between the NT4 application server domain and the Server 2003 domain. This is to Authenticate NT users and seems to work fine.

I guess there is a timeout setting that probably needs to be increased but cannot find any information of what it might be.

If anyone could advise me I would be very grateful.

Thanks,

Roland

1 reply

This discussion is closed to new replies.