SQL 2005 Error - SELECT Permission Denied - Best Guess
Posted on 2011-10-14
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.