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: 923
sql-server
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
