user is in DISABLED mode.
Some times we could see that USERS of the database would be in DISABLED mode after restoring the database from the .BAK file though their corresponding logins are in place with appropriate permissions.
If you face an issue like this run the below command to bring the users into ENABLED state.
USE DatabaseNameHere GO GRANT CONNECT TO [DomainName\Name]
Comments