If the problem persists, identify if the SQL Server that the Apex One Server had gone some recent changes:

• SQL Server Authentication Mode (Whole SQL Server or per database)
• SQL Server Connection to the Apex Server, such as Namepipes or network restrictions that may be preventing communication between the servers.

Make sure of the below items for the service account connecting to the SQL database:

1. The account must belong to the local administrator group or Active Directory (AD) built-in administrator.
2. The account must configure the following User Rights Assignment policies on 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
3. The user account must also have the following database roles:
   • dbcreator
   • bulkadmin
   • db_owner

For Windows Authentication against MSSQL and domain users, the issue is usually one of the following:

• Domain Account / Service Account expired
• Account Password expired/revoked
• Account permission issue
• Password had been changed on the AD Controller side, but the Apex Server still uses the previous credentials to connect to SQL Server.

To resolve these issues, refer to the SQL Transfer Tool section here.

For issues that occur after installing the Apex One SP1 Update, Event Viewer Event ID 33555 and Event ID 26014 appeared on the Event Viewer:

• Event ID 33555 - The certificate [Cert Hash(sha1) "<Cert Hash number>"] is in the local computer store but the SQL Server service account does not have access to it.

• Event ID 26014 - Unable to load user-specified certificate [Cert Hash(sha1) "<Cert Hash number>"] The server will not accept a connection. You should verify that the certificate is correctly installed. See "Configuring Certificate for Use by SSL" in Books Online.

To resolve the issue, follow the steps below:

1. Locate User Specified Certificate in MMC:
   1. Select Start > Run, enter MMC, and then open Certificate Snap-in in the MMC console.
   2. On the Console menu, select Add/Remove Snap-in.
   3. Select Add > Certificates, and then select Add again.
   4. Select the computer account.
   5. Select Local computer, and then select Finish.
   6. In the Add Standalone Snap-in dialog box, select Close.
   7. In the Add/Remove Snap-in dialog box, select OK.
   8. Go to Personal > Certificates
   9. Right Click on Apex One Certificate > All Tasks > Manage Private Keys and then grant full permissions to the SQL Server service account.
2. Go to SQL Server Configuration Manager:
   1. In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration.
   2. Right-click Protocols for <instance Name>, and then select Properties.
   3. Go to the Flags tab, set Force Encryption to Yes
   4. Go to Certificate Tab, select Apex One Certificate
   5. Click on Apply
3. Restart SQL Services