Invalid value for key 'integrated security' [closed]

Question

I need a help. I got this:

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 works. Help!

Answer 1

Clearly, you are missing a semi-colon after SSPI, so the argument is being read as SSPIAttachDbFilename=E:\\user\\program\\Database1.mdf which is not a valid value for Integrated Security.

This should work.

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