question

apple avatar image
apple asked

sql server authentication

Hi! My package uses windows authntication what are the changes i need to make to the config file so that it uses sql server authentication .in the config file I have datasource =name; userid=name;password =name;initialcatalog= databasename;provider= ;Auto translate= false; Thanks
ssis
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
You just need to add one command to the connection string: Trusted_Connection=False.
4 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

apple avatar image apple commented ·
Thank you I tried with trusted_connection=False but it gave me an error any other solution
0 Likes 0 ·
apple avatar image apple commented ·
Test connection failed because of an error in initializing provider. Invalid value specified for connection string attribute 'trusted_connection' This is the message it displayed Thanks
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Then it might be trusted = false or trusted connection = false. It really depends on what data connection you're trying to make, ODBC, ADO, etc.
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
See http://www.connectionstrings.com/sql-server-2008 and other pages there for more information.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.