This problem surfaces when the affected user has deny privileges. This error will be seen when the user which you have created does not have the sufficient privileges to access specific database objects (tables, stored procedures, functions) in the database.
GRANT the user specific permissions such as SELECT, INSERT, UPDATE and DELETE on tables in that database. An example of this SQL command is shown below.
USE [your database name]
SET ANSI_PADDING OFF
GRANT INSERT, UPDATE, SELECT, DELETE ON [dbo].[database object name] TO [sql user name]
-- ex: GRANT INSERT, UPDATE, SELECT, DELETE ON [dbo].[ClientRoles] TO BBPortalWebRole
Disclaimer: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist with implementing the resolution from these websites.