When trying to open a repository, I am receiving "Error executing SQL command. General database error. [9008]"
Question
Question
What is the correct Authentication Service version for Laserfiche 12?
Answer
9008 can mean any number of server side database errors. The best first step is to look for a corresponding item in the event viewer for lfs on the server machine and see if there's more information provided there.
To expand on that, when Laserfiche Repository Server receives an error from the ODBC Driver for SQL Server, it logs the real error message from the driver to its event log and returns that generic "General database error. [9008]" to the client.
The event log you need to check is:
Applications and Services Logs > Laserfiche > ContentRepository > Service > Admin
Read the full error message(s) from the ODBC Driver for SQL Server carefully. They can have a lot of text but often have a line or two within them that says what the issue is in plain language.