Trouble connecting to SQL Server 2005 - TechRepublic
Question
September 27, 2009 at 07:34 PM
alvinyapsoonyeng

Trouble connecting to SQL Server 2005

by alvinyapsoonyeng . Updated 16 years, 9 months ago

I get the following error when trying to create a DSN to connect to SQLSVR2005 from Windows XP client to W2K3 Server.

Connection failed:
SQLState: ‘01000’
[Microsoft][ODBC SQL Server Driver][TCP\IP Sockets]ConnectionOpen (SECCreateCredentials()).
Connection failed:
SQLState ‘08001’
SQL Server Error: 18
[Microsoft][ODBC SQL Server Driver][TCP\IP Sockets] SSL Security error

Appreciate any advice to resolve this.

This discussion is locked

All Comments