The Database is not available:Cannot open database "Inn" requested by the login
The login failed.
Login failed for user 'innovator_regular'.
solution
Open SSMS
Expand Security
Expand Logins
Right click on innovator_regular user
Select Properties
Click on User Mapping
check under Map for your data base
Check db_owner
Ok
or
run below
exec sp_change_users_login 'Update_One', 'innovator_regular', 'innovator_regular'
exec sp_addrolemember 'db_owner','innovator_regular'
The login failed.
Login failed for user 'innovator_regular'.
solution
Open SSMS
Expand Security
Expand Logins
Right click on innovator_regular user
Select Properties
Click on User Mapping
check under Map for your data base
Check db_owner
Ok
or
run below
exec sp_change_users_login 'Update_One', 'innovator_regular', 'innovator_regular'
exec sp_addrolemember 'db_owner','innovator_regular'
