December 6, 2017 at 8:18 am
Hi Team,
Throwing bellow error while creating connection string in SSIS Package to connect SQL server. I am using PROVIDER= "Native oledb\microsoft ole db provider for sql server" in connection manager(SSIS package)
If I use native client then it is connecting. Recently Enabled TLS1.2. Aafter that we are not able to connect SQL server from SSIS package with OLEDB providers.
Please suggest what are the configuration to enable, to connect the SQL.
SQL Server details:
Microsoft SQL Server 2012 (SP4) (KB4018073) - 11.0.7001.0 (X64)
Aug 15 2017 10:23:29
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor
Windows Server 2012 R2 Standard
Note:TLS1.2 enabled
TITLE: Connection Manager
------------------------------
Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error.
------------------------------
BUTTONS:
OK
------------------------------
Thanks,
Ramana
December 6, 2017 at 9:02 am
PRAMANA.DBA - Wednesday, December 6, 2017 8:18 AMHi Team,
Throwing bellow error while creating connection string in SSIS Package to connect SQL server. I am using PROVIDER= "Native oledb\microsoft ole db provider for sql server" in connection manager(SSIS package)
If I use native client then it is connecting. Recently Enabled TLS1.2. Aafter that we are not able to connect SQL server from SSIS package with OLEDB providers.
Please suggest what are the configuration to enable, to connect the SQL.SQL Server details:
Microsoft SQL Server 2012 (SP4) (KB4018073) - 11.0.7001.0 (X64)
Aug 15 2017 10:23:29
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor
Windows Server 2012 R2 Standard
Note:TLS1.2 enabled
TITLE: Connection Manager
------------------------------
Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error.
------------------------------
BUTTONS:
OK
------------------------------Thanks,
Ramana
Have you enabled/enforced ssl on the sql server instance?
😎
December 6, 2017 at 9:32 am
Eirikur Eiriksson - Wednesday, December 6, 2017 9:02 AMPRAMANA.DBA - Wednesday, December 6, 2017 8:18 AMHi Team,
Throwing bellow error while creating connection string in SSIS Package to connect SQL server. I am using PROVIDER= "Native oledb\microsoft ole db provider for sql server" in connection manager(SSIS package)
If I use native client then it is connecting. Recently Enabled TLS1.2. Aafter that we are not able to connect SQL server from SSIS package with OLEDB providers.
Please suggest what are the configuration to enable, to connect the SQL.SQL Server details:
Microsoft SQL Server 2012 (SP4) (KB4018073) - 11.0.7001.0 (X64)
Aug 15 2017 10:23:29
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor
Windows Server 2012 R2 Standard
Note:TLS1.2 enabled
TITLE: Connection Manager
------------------------------
Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error.
------------------------------
BUTTONS:
OK
------------------------------Thanks,
RamanaHave you enabled/enforced ssl on the sql server instance?
😎
thank you Eiriksson for the reply.
Yes , Enabled TLS1.2
December 6, 2017 at 12:20 pm
PRAMANA.DBA - Wednesday, December 6, 2017 9:32 AMthank you Eiriksson for the reply.
Yes , Enabled TLS1.2
Check your settings in connection manager, on the advanced settings. Especially check what you have set for Encrypt and TrustServerCertificate. Some of what you do depends on how the certificate was set up. The settings for the connection are explained in this document:
SqlConnection.ConnectionString Property
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply