Using SQL Server 2014 Express, the initial install was set to use Windows Authentication. I'd like to change that to SQL Server Authentication with a user name and password.
Is that possible, and if so how do I do that from within the Management Studio IDE?
Also, I'm accessing the DB through a C# application. How would the connect string change once there's a user name / password set? Currently I have these values:
LocalDatabaseName = computername + "\\SQLEXPRESS"; // where computername is System.Windows.Forms.SystemInformation.ComputerName, and
string connstring = "Data Source=" + LocalDatabaseName + ";Initial Catalog = master;Integrated Security=True";