Command - 1 (Running on 'Master')
*CREATE LOGIN [login_Name] WITH PASSWORD=N'XXXXXX'*
Command - 2 (Running on 'Database_name')
*ALTER USER [User_name] WITH LOGIN= [login_name]
EXEC sp_addrolemember N'db_owner', N'Database_Name'*
When I try logging to 'Database_Name' or try to make a connection to this database with the newly created Login_name and Password, I am getting the following error sometimes:
The server principal "XXX" is not able to access the database "XXX" under the current security context. Cannot open database "XXX" requested by the login. The login failed. Login failed for user 'XXX'.
I made sure that the altered user is not orphan user by matching it's SID with the Login's SID.
ISSUE: After resetting the password and user, the above error shows up sporadically. Sometimes I can make a connection in just a second after running the above commands. The other times it may take up to 15 minutes before I can connect to the database.