CODEWITHSUNDEEP
sql-serverelmah
Andrew Kilburn
Andrew Kilburn

Reputation: 2251

The EXECUTE permission was denied on the object 'ELMAH_GetErrorsXml', database 'XXX', schema 'dbo'

I'm trying to implement server logging for my SQL server and I can get to the error page using localhost. However, when moving to the server and attempting to access it on there I just receive the above exception.

I have added the role 'Public' to have the SELECT permission on the table but it still doesn't change anything. I even tried adding my UserID and Password to the connection string and I signed in to give it another go but I received the same error, can anybody help me?

The exception says I need to add execute permission to the role, however when I tried this, no execute permission existed.

Upvotes: 1

Views: 1365

Answers (1)

Andrew Kilburn
Andrew Kilburn

Reputation: 2251

I had to add 'Public' to have execute permissions of the GetErrorXML stored procedure.

Upvotes: 2

Related Questions