The cause:

This error happens because the user you created doesn’t have enough privileges to access the tables in your database.

Solution:

Provide enough privileges for the user so as to get what you expect.

Some determined permissions on table in that database such as SELECT, INSERT, UPDATE and DELETE should be granted for the user.

You can refer about how to grant SELECT permisson to the table below:

If you want to grant SELECT permission to a table, you can follow this syntax:

USE YourDB;

GRANT SELECT ON dbo.functionName TO UserName;

If you want to grant SELECT permission to all tables in the database, let’s do the following:

USE YourDB;

GRANT SELECT TO UserName;