none
.Net Providers\SqlClient Data Provider Connection String RRS feed

  • Question

  • Hi,

    For SQL Server 2012, what is a proper connection string for the provider of the type ".Net Providers\SqlClient Data Provider ?"

    I have to use SQL Server Authentication (Username/Password)

    Thank you

    • Moved by Bob Beauchemin Thursday, September 5, 2013 1:03 AM Moved to a more relevent forum
    Wednesday, September 4, 2013 9:20 PM

All replies

  • Thursday, September 5, 2013 12:14 AM
  • Data Source=123.45.67.890;User ID=ID;Password=PW;Initial Catalog=DB;Persist Security Info=True;

    Does this seem like an OK CS?

    I checked the values for used properties, but in SSIS when I set this conn str to a variable and use the variable for Connection property of the connection adapter, it fails.

    Error: The Execute method on the task returned error code 0x80131500 (The connection "Data Source=###.##.##.###;User ID=*****;Password=*****;Initial Catalog=******;Persist Security Info=True;" is not found. 
    This error is thrown by Connections collection when the specific connection element is not found.
    ). The Execute method must succeed, and indicate the result using an "out" parameter.


    • Edited by B3nt3n Thursday, September 5, 2013 3:31 PM
    Thursday, September 5, 2013 3:25 PM