ottobock
asked on
SQL 2005 Error - SELECT Permission Denied - Best Guess
Hello Experts,
One of our applications is throwing this SQL related error:
Error Message: ADO Version 2.8 - COM Error: ErrorCode:-2147217911,Word ErrorCode: 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.
One of our applications is throwing this SQL related error:
Error Message: ADO Version 2.8 - COM Error: ErrorCode:-2147217911,Word
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.