500 - Internal server error for SQL Server error

Question

I have a new VPS account, whereas before I've always been running my sites on a shared server.

I have "Enable Robust Exception Information" checked, and "Enable Request Debugging Output" checked.

I'm getting a 500 - Internal server error, which isn't very helpful.

And I can see in the application.log the following error:

Error Executing Database Query.[Macromedia][SQLServer JDBC Driver][SQLServer]The column name 'AttachmentDesc' is specified more than once in the SET clause.

So I see the error, but it would be better if the page displayed the error rather than me having to find it in the application.log.

Q: Is there another setting that I'm missing to help display errors on the page itself?

Answer 1

Looks like IIS is hiding the errors from you. Under 'Error Pages' in IIS, select the 500 error and click 'Edit feature settings' and select 'Detailed errors' - you should now see the full error info (provided debugging is on n CF).