title: Adding user for a SQL Server 2008 database - no password field?
body: <p>I have an ASP.NET app that needs to connect to a SQL Server 2008 database. When I try add the user (specified in a connection string within the app) using Management Studio it doesn't ask for a password for that user - why is this?</p>
  
  <p>(so all i keep getting when i run the app is "Login failed for user 'user'.")</p>