SQL 2005 Error - SELECT Permission Denied - Best Guess

Posted on 2011-10-14
Last Modified: 2012-05-12
Hello Experts,
One of our applications is throwing this SQL related error:

Error Message: ADO Version 2.8 - COM Error: ErrorCode:-2147217911,WordErrorCode:3081, IDispatch error #3081, The SELECT permission was denied on the object 'health_check', database 'DB', schema 'dbo'., Microsoft SQL Native Client, (null)

The application connects to a remote SQL Server. On the SQL Server, I have found the table "dbo.heath_check" under "DB," but I'm not sure what to check or run after this. Any ideas?

I understand that I'm not providing much information regarding the software/processes involved. I'm just seeking ideas at the moment.
Question by:ottobock
    LVL 39

    Assisted Solution

    Well the error clearly speaks for itself.  The SQL Server login you are using does not have permission to select from that table.  I suggest you have your DBA verify the proper permissions are in place.
    LVL 11

    Assisted Solution


    Check what user it connects to the DB?
    Check whether that user has permissions or not?
    LVL 28

    Accepted Solution


    Whatever account you are using to connect to the DB needs the SELECT permission on 'health_check' table.

    So, right-click on your db, click on Properties, click on Permissions.

    Scroll till you see SELECT box. Tick that box and it should fix your issue.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now