When trying to open a repository, I am receiving "Error executing SQL command. General database error. [9008]"
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.
To follow up, our issue has been resolved. After reviewing a number of logs and permissions, we found that when we upgraded to Laserfiche 12, five of our eight repositories had their login credentials changed from 'laserfiche.service' to 'localhost'. We changed the logins back to 'laserfiche.service' and all repositories were accessible.