SQL

Stored procedure can only be executed at the ad hoc level

This article applies if you are receiving the following error when upgrading your EIOBoard database: “Stored procedure ‘sys.sp_dbcmptlevel’ can only...

Manually Upgrade the Database

When making any changes to the database, you will want to make a backup so that you do not have...

Create Database Failed Error

The error “CREATE DATABASE failed.” is an error that takes place when installing the EIOBoard server. Even though the error...

Configure SQL Server to send notification upon failure

Sometimes SQL server service tends to stop or fail due to many factors, such as Operating system issues, HardDisk issues,...

Assigning an Administrator Privilege to a User From the Server

You must have full access to the server or SQL database to do this task.  You need to open up...

Resolve issue with Log file filling up the drive

Sometimes a SQL server database has its recovery mode set to Full mode, and without taking a backup, the log...

SQL Collation Conflict When Installing EIOBoard

When installing EIOBoard, it’s possible that you may run into a SQL error similar to this one: “Cannot resolve collation...

On-Prem only – Remove or Modify the Comment (Nightly Status Update) that shows up when users are automatically signed out at midnight

This article applies only to customers who have an on premise aka customer hosted installation of EIOBoard. Some of our...

Exporting and Importing Users From One Database to Another

In some instances, data from one EIOBoard database may need to be merged into another new or existing EIOBoard database....

SQL Server Not Found. Does Version 10.1.X Support Remote SQL Connections?

Yes. It is a supported connection. This edge case article makes a few assumptions about your understanding of the current...

Execute with results failed for database

The error “Execute with results failed for database _______ is caused when the SQL credentials are for a user with...

Changing Minimum Password and Username Length Requirements

Recently EIOBoard has had a security update that increased the default minimum length of usernames and passwords to 8. They...

Azure Data Studio: Execution failed due to an unexpected error: Position is outside of file line range (Parameter ‘line’)””

The manual upgrade script will fail when running the EIOBoard manual upgrade script from Azure Data Studio. Azure Data Studio...

How to back up the Savance EIOboard Database

If you’re migrating your server you’ll need to create the backup file to move to the new server. It is...

What database backend does EIOBoard run on?

EIOBoard MSQL EIOBoard uses a Microsoft SQL Server backend (MSSQL). This provides increased security and scalability over products that use...

My EIOBoard will not connect or establish connection to the database?

EIOBoard tries to make a connection to the database to make sure you are running the latest version. If your...

How to Remove Future Statuses from EIOBoard

If you have added Future Statuses to EIOBoard (such as through Outlook Sync. or Exchange Sync.), EIOBoard is not currently...

How do I restore an EIOBoard backup database?

To restore an EIOBoard backup database, the first thing you want to do is to locate your database backup file...

How to Find my Backup Location

Open EIOBoard Server Administrator on your EIOBoard Server.   Go to the SQL Tasks tab.   Double click on the...