connection-stringlocaldbsql-authentication

LocalDB connection with Integrated security=False

I was looking everywhere and still have not found clear answer to this simple question:

Is it possible to use SQL authentication with LocalDB, i.e. is it possible to use connection string containing 

Integrated Security=False

?

Solution

  • Yes, last I tried it was possible. Just follow the steps from this MDSN article.

    Keep in mind that it will still be user instance, running under the account that started it, and will be shut down shall the account log out. Also no remote access.