SyntaxFix
Write A Post
Hire A Developer
Questions
I solved this by referring properties of login user under the security, logins. then go to User Mapping and select the database then check db_datareader and db_dataweriter options.