![sql server connection string integrated security sql server connection string integrated security](https://i.stack.imgur.com/hZrfk.png)
I upgraded SSIS 2014 to 2017 by mainly change the connection string from Provider=SQLNCLI11 to Provider=SQLNCLI11.1.
![sql server connection string integrated security sql server connection string integrated security](https://i.stack.imgur.com/BF17y.png)
#SQL SERVER CONNECTION STRING INTEGRATED SECURITY UPGRADE#
DataTypeCompatibility=8 We upgrade our server from SQL server 2014 to 2017. To enable the usage of SQL Server Native Client, ADO applications will need to implement the following keywords in their connection strings: Provider=SQLNCLI11. oConn.Properties(Prompt) = adPromptAlways oConn.Open Provider=SQLNCLI11 Server=myServerAddress DataBase=myDataBase Then use the connection string to connect to the database. First you need to set the connection object's Prompt property to adPromptAlways. Important The SQL Server Native Client OLE DB (SQLNCLI) remains deprecated and it is not recommended to use it for new development work This one is a bit tricky.
![sql server connection string integrated security sql server connection string integrated security](https://askmanisha.files.wordpress.com/2013/07/sqlconn.jpg)
Provider = SQLNCLI11 Server = myServerAddress Database = myDataBase Trusted_Connection = yes Connection strings are lists of keyword and associated values each keyword identifies a particular connection attribute. This SQL Server Native Client 11.0 OLE DB Provider connection string can be used for connections to SQL Server 2012, SQL Server 2008 and SQL Server 2005. oConn.Properties(Prompt) = adPromptAlways oConn.Open Provider=SQLNCLI11 Server=myServerAddress DataBase=myDataBase Connection string.