Adding Login does not work. Error: "Cannot open database \ requested by the login. The login failed.\r\nLogin failed for user"

Posted by Jacob Pressures on Stack Overflow See other posts from Stack Overflow or by Jacob Pressures
Published on 2013-11-03T15:42:41Z Indexed on 2013/11/03 15:53 UTC
Read the original article Hit count: 888

Filed under:

I'm receiving this error message:

Cannot open database \"Northwind\" requested by the login. The login failed.\r\nLogin failed for user 'Mike\Mike Simpson'

When i try to add the user, which is me. Then sql server says

Msg 15063, Level 16, State 1, Line 1 The login already has an account under a different user name.

HEre is my connection string:

"Data Source=Localhost;Initial Catalog=Northwind;Integrated Security=True"

I'm using SSMS not SQL Server express I don't know what else I should do. This application used to work before i zipped it up.

Thanks!

© Stack Overflow or respective owner

Related posts about sql-server