Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Connection error Force Encryption Set to Yes

Author  Topic  pvedi Starting Member 6 Posts Posted - 2007-11-15 : 16:55:26 Here is the weird problem I am facing connecting to SQL Server 2005 using Force Encryption Set to Yes for SQL Server Protocols: I have an application using PowerBuilder 10.5, SQL Server 2005 as backend and OLE DB (SQLOLEDB) as the driver for connection. I donot have any SSL Certificate on the Server currently. When I try to connect to SQL Server from runtime environment or executable environment with PBD instead of DLL I am able to connect without any problem. Using the same Connection String and DB I created the executable with machine code, ie. this time the executable had DLLs instead of PBDs I am not able to connect to SQL Server. I am getting the following error: SQLSTATE = 08001 Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]SQL Server requires Encryption On. My connection String is as follows: PROVIDER='SQLOLEDB',DATASOURCE='<SErverName>',ReCheckRows=1,bintxtblob=1,PROVIDERSTRING='DataBase=DBName' Basically all information connecting to the DB is same except one executable is using DLL(Connection Failure) and other is PBD(Successful connection). I am suspecting if SQL Server is doing authentication only when I am connecting through DLL?? Any help will be appreciated.