title: Connecting to SQL Server with a username and password
body: <p>I am writing a C# application to be deployed on another machine. The deploy machine is a clean Windows 7 install.</p>
  
  <p>On my development machine (A Windows 7 32 bit Virtual Machine) I have installed SQL Server 2008 R2 and Visual Studio Express 2010. I would like to create a new database and have it require authentication from an application to connect. All the tutorials that I find mention breeze over the connection string part, I cannot find this explained anywhere. In fact, I cannot even figure out how to add a new user and password to SQL Server in SQL Server Management Studio.</p>
  
  <p>How do I add a new user and password to SQL Management Studio 2008 R2 such that I can easily install another SQL Server instance on another machine and move the database to it?</p>
  
  <p>Thanks.</p>