SQL Server authentication connection string in SSIS

Hi,

The below connection string works fine for windows authentication.

Data Source=Test123;Initial Catalog=Globe;Provider=SQLNCLI10.1;Integrated Security=SSPI;

what changes i should make in the above connection if i have sql server authentication mode?

May 27th, 2015 6:54pm

http://sqlknowledgebank.blogspot.in/2013/06/ssis-sql-server-authentication-for-ole.html
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2015 8:41pm

Hello,

You can look up all connection string properties at: http://www.connectionstrings.com/

The properties "Integrated Security=SSPI" indicates to logon using Windows Authentication, so remove this and add "user id" + "password" to pass SQL Server logon credentials:

Data Source=Test123;Initial Catalog=Globe;Provider=SQLNCLI10.1;User ID=MySqlLogin;Password=MyC0mplexPa$$word

May 28th, 2015 3:29am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics