SqlConnection not setting password when getting the ConnectionString

Question

I am trying to save my connection string to a configuration file but the password is not being submitted.

Here is the code I am using:

    using (var con = new SqlConnection(string.Format("Data Source={0};Initial Catalog={3};User ID={1};Password={2};",
           textBox_SqlServer.Text, textBox_Username.Text, textBox_Password.Text, comboBox_DatabaseName.Text)))
    {
      // test connection before continuing
      con.Open();
      configs.ApplicationConfiguration.SetConnectionString(con.ConnectionString);
    }

All is fine until con.ConnectionString and it does not include the password. What do I need to do to So, naturally, when I go to retrieve it, the password is not there.

How do I get the password to set also?

code is fine , just break point and debug and see if Text has value at that point, mostly this happen due to Postback , — Tarun
– Tarun, Commented Apr 7, 2014 at 16:05
When I hit con.ConnectionString the password isn't even in the string anymore... I guess it is stripping it out. — ErocM
– ErocM, Commented Apr 7, 2014 at 16:10

Jonathan Henson · Accepted Answer · 2014-04-07 16:01:29Z

5

The ConnectionString is similar to an OLE DB connection string, but is not identical. Unlike OLE DB or ADO, the connection string that is returned is the same as the user-set ConnectionString, minus security information if the Persist Security Info value is set to false (default). The .NET Framework Data Provider for SQL Server does not persist or return the password in a connection string unless you set Persist Security Info to true.

From the MSDN documentation. http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(v=vs.110).aspx

answered Apr 7, 2014 at 16:01

Jonathan Henson

8,2463 gold badges31 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ErocM Over a year ago

Perfect! I added Persist Security Info=True; and it gives me what I need. TYVM!

Collectives™ on Stack Overflow

SqlConnection not setting password when getting the ConnectionString

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related