I was working through the upgrade to v9.2 from v8.1.2 in a sandbox this weekend. I was unable to complete the processes due to the following errors; and more importantly when I reactivated the production server I had the same errors.
Trying to login to the repository from Admin Console ERROR:
Error executing sql command. (9008)
The Event Log on the server showed
Event Type: Warning
Event Source: LFS
Event Category: None
Event ID: 10050
Date: 1/31/2015
Time: 10:08:11 AM
User: N/A
Computer: CEDAR
Description:
Database statement execution error encountered.
Session ID: ; Dialog ID: ; Repository: 'CofTrail'; CLI routine: SysRepMount; Message: [Microsoft][SQL Native Client][SQL Server]Invalid object name 'dboptions'.; SQL Statement: 'select optionvalue from dboptions where optionname = ? '; SQL variable: ''; SQL State: 42S02.
Event Type: Error
Event Source: LFS
Event Category: None
Event ID: 10027
Date: 2/1/2015
Time: 2:08:06 PM
User: N/A
Computer: CEDAR
Description:
Mounting repository 'CofTrail' failed. Please ensure that the Laserfiche server has the ability to log in to the database backing the repository, and that the repository directory is accessible.
Apparently an issue with connecting to the SQL Server. I searched everything I could online but I cannot get it beyond these errors. I have no problem creating connections to the server and database using odbc.
Any thoughts?