To resolve this:
- Check for any changes in the database settings.
- Check configuration files to know the information of Apex One & Apex One Endpoint Sensor database.
- Check ofcserver.ini, and get the Apex One database information:
[DBServer]
Server = xxx.xxx.xxx.xxx
Database = OSCE
SQLAuthMode = 5020 (5020 means SQL authentication) - Check the Apex One Endpoint Sensor configuration file, Event40\Config.xml:
<SQLServer>
<source>xxx.xxx.xxx.xxx</source>
<database>OSCE-iES</database>
<username>XXX</username>
- Check ofcserver.ini, and get the Apex One database information:
- Utilize SQL Management Studio to make sure the database setting is consistent with the data above.
- Run SqlTxfr tool to update the database information to Apex One.
When using the Windows Account to log on to the server, Apex One applies the username of the currently logged on user.
The user account must belong to the local administrator group or Active Directory(AD) built-in administrator. The following User Rights Assignment policies must be configured as well using the Windows Local Security Policy or Group Policy Management console:
- Log on as a service
- Log on as a batch job
- Log on locally
The user account must also have the following database roles:
- dbcreator (only required if you are creating a new database instance using the Setup program)
- bulkadmin
- db_owner