Invalid value for key "integrated security"

Question

I need help. I got it:

SqlConnection sc = new SqlConnection("Data Source=(LocalDB)\\v11.0; Integrated Security=SSPI" + "AttachDbFilename=E:\\user\\program\\Database1.mdf"); 

I tried to set Integrated Security to True or even False . None of them work. Help!

Answer 1

Obviously, after SSPI, you are missing a half-colony, so the argument reads as SSPIAttachDbFilename=E:\\user\\program\\Database1.mdf , which is not a valid value for Integrated Security.

That should work.

 var sc = new SqlConnection("Data Source=(LocalDB)\\v11.0; Integrated Security=SSPI;" + "AttachDbFilename=E:\\user\\program\\Database1.mdf")