Wildfire database installation/connection errors

After installing the wildfire server, configure the server and install the Administrator console.

Admin Console

After completing the above steps, Wildfire will be configured and you can use the Web-Based Admin console to administer the server. the URL shoshould be the same as you used to setup the server unless you changed the port during the setup.

Because SQL Server is used, during the third step of installation, my connection string should be:

Connection

JDBC: jtds: sqlserver: // 127.0.0.1/Wildfire; appname = jive

Although the Wildfire database has been created in SQL server2005, the required table has been created through the provided. SQL file, and port 1433 is also enabled. However, the following error occurs:

Error

A connection to the database cocould not be made. view the error message by opening the "\ logs \ error. log" log file, then go back to fix the problem.

Because SQL Server sets the Server Authentication Mode in server properties/security to Windows Authentication mode by default, I leave it blank in the username/password field, and this error occurs. Today, I changed the Server Authentication Mode to "SQL Server and Windows Authentication Mode", and set a login name (User) test for the Wildfire database, then, set the username/password in the Wildfire database connection settings to the corresponding value. The error disappears.

But there are still some problems. Another error occurred when setting the next step:

Error

Wildfire database schema does not appear to be installed. Follow the Installation Guide to fix this error.

The error message "Wildfire Database (statement set schema)" does not show any signs of installation. The key here is that does not appear to is not installed on the surface. So I checked the logon attribute of the login name test and found that when I mapped this to the Wildfire database, I did not assign a role to the database role member identity. The default value is public, so a select -- db_owner is added. Go back to the wildfire web control panel and click Next. Successful!