Issue
Liquid Office Web Desktop not coming up after installing LiquidOffice Server. When trying to access http://server:99/jsp/login.asp the following error is displayed.
Note: Verify that the URL port entry is 99. If port 99 is in use during the install another port number may be used. To check the port number used during the install go to \backup\liquid-office-server\install.properties file.
an error occured processing this request the operation can not be completed
\logs\LiquidOffice.stdOut displays the following error:
java.lang.Exception: JDBCAppender::connect(), java.sql.SQLException: The TCP/IP connection to the host xxx.xxx.xxx.xxxMSSQLSERVER, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.
or a message indicating the following:
Login failed for user 'sa'.
Solution
This error message usually happens when the database is installed without instance name. By default, Liquid Office automatically adds MSSQLSERVER as an instance name. Run the loserver_config_app tool to make appropriate database change.
Prerequisites:
· You must have the ALL following Database Connection Information
§ Database Hostname or IP Address
§ Database Port (default port is 1433 for SQL)
§ DocuShare Database Name
§ SQL Username and Password for the DocuShare Database
1. Stop DocuShare
2. Make sure the dsliquidoffice.exe process is no longer running
3. Go to command prompt
4. Change directory to \LiquidOffice\xmlserver\configurator
Where is the installation directory for DocuShare. The default installation path for DocuShare is C:\Xerox\Docushare. Depending on your installation environment this path may vary.
5. Run loserver_config_app.bat. The LiquidOffice Server Configuration window will display.
6. Verify the Host entry is correct (The Host is your DocuShare Server) and click Next.
7. Select the appropriate Web Server Port for your installation by selecting the checkbox to Enable HTTP or Enable HTTPS.
Note: Verify that the port listed are correct for your server installation. The default HTTP port is 99 and the default HTTPS port is 443.
8. Click Next.
9. Uncheck/Disable the Automatically start server at system start time option and click Next.
Note: DocuShare will start the Liquid Office Server automatically during its Startup Sequence.
10. Uncheck/disable the Enable LDAP option and click Next.
Note: Currently the DocuShare eForms Connector does not support LDAP.
11. In the Database Connection Setup , select Microsoft SQL Server from the drop down menu for DBMS Type.
12. Host should be xxx.xxx.xxx.xxx instead of xxx.xxx.xxx.xxxMSSQLSERVER
Where xxx.xxx.xxx.xxx is replaced with the IP Address of your Database Server.
13. The Use Port field display 1433.
14. Enter the appropriate Database Name, Username and Password for the DocuShare Database.
Note: During installation the default Database Name is Docushare. Depending on your installation environment this may vary.
15. Click the Test Connection button to make sure the information you provided is ok Connection OK! message should be displayed.
Note: If a Connection Failed! Message is displayed then the information that you provided in the configurator for the database is not correct. Verify all the database information you provided with your Database Administrator.
16. After the Connection test is OK, click Next.
17. Uncheck/disable the Enable Archive Database option.
Note: Currently the DocuShare eForms Connector does not support Archive Database.
18. Click Finish. The Configuration Complete message will be displayed. Click OK.
19. Start DocuShare.
20. You should now be able to access the Liquid Office Web Desktop by using http://localhost:. For example, http://localhost:99
Solution Updated: August 31st, 2011
Soution ID: 761