HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.odbc » No Results with Encrypt and TrustServerCertificate
Topic: No Results with Encrypt and TrustServerCertificate
Hi All, can someone shed some light on my issue.
I have an SQL Server 2005 instance setup and have not specified a
Server Certificate. When i connect to it with the following
connection
string - all is good:
Data Source=<server>;Initial Catalog=<db>;User ID=sa;Password=<pass>
However, if I try to encrypt the connection, I dont get any results
returned. It can find the column names, but no results:
Data Source=<server>;Initial Catalog=<db>;User
ID=sa;Password=<pass>;Encrypt=yes;TrustServerCertificate=True
Anyone have an idea why?
-SJ
Replies below ↓