My SSIS package works in Windows-10 with SSMS 2017 installed and connecting to Microsoft SQL Server 2014 (SP3-CU-GDR) (KB4535288) – 12.0.6372.1 (X64). Developed in Visual Studio 2017. My SSIS packages are deployed to the file system.
On Windows-16 serer I have SQL Server Integration Services 13.0 with SQL Server Management Studio 2016. I am connecting to same database Microsoft SQL Server 2014 (SP3-CU-GDR) (KB4535288) – 12.0.6372.1 (X64).
I am using same user ID from local as well as Win-16 server. User exists in SQL Server database. I can also connect to SQL Server DB from Windows-16 server SSMS 2016. So no such connectivity issue.
One thing I want to mention is TLS 1.2 protocol is enabled on Win-16 server.
I am getting below error messages:
Error in Microsoft.SqlServer.Dts.Runtime.Package/Connection manager "[Data-Base-Name]” : SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error Code: 0x80004005.
An OLE DB record is available. Source "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: Login timeout expired."
An OLE DB record is available. Source "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "A network-related or instance -specific error has occurred while establishing a connection to SQL server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connection. For more information see SQL Server Books online.".
An OLE DB record is available. Source "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].".
Error in Microsoft.SqlServer.Dts.Runtime.TaskHost/Execute SQL Task : Failed to acquire connection "[Data-Base-Name]”. Connection may not be configured correctly or you may not have the right permission on this connection.
Any expert advise or guidance on how to fix this issue?
