Hi, I am running WIn Ent 2008 R2 64 bit machine (VM) with SQL Server 2008 R2 installed.
I am trying to set up a 32 bit odbc using the SQL native client 10. but it fails
TheSQL Server name (as I view the connection) : 10-123-114
Computer name is also the same. Instance is blank.
Microsoft SQL Server Native Client Version 10.50.1600
Data Source Name: GPodbc32
Data Source Description: GP odbc 32 bit
Server: 10-123-114
Use Integrated Security: No
Database: (Default)
Language: (Default)
Data Encryption: Yes
Trust Server Certificate: No
Multiple Active Result Sets(MARS): No
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Regional Settings: No
Use ANSI Quoted Identifiers: No
Use ANSI Null, Paddings and Warnings: Yes
Test Data Source ....
Microsoft SQL Server Native Client Version 10.50.1600
Running connectivity tests...
Attempting connection
[Microsoft][SQL Server Native Client 10.0]SSL Provider: The certificate chain was issued by an authority that is not trusted.
[Microsoft][SQL Server Native Client 10.0]Client unable to establish connection
Disconnecting from server
TESTS FAILED!
Appreciate if anyone can point me in the right direction.