---
title: "Database | Check for MSSQL Snapshot on Startup"
id: "database-add-check-for-mssql-snapshot-on-startup"
project: "Knowledge Base"
url: "https://docs.sepasoft.com/articles/knowledge-base/database-add-check-for-mssql-snapshot-on-startup"
updated: 2026-07-23T18:08:20Z
---

# Database \| Check for MSSQL Snapshot on Startup

### Snapshot Check when using Microsoft SQL Server

This information applies to customers running Microsoft SQL Server. If a fresh Database connection is set up (that does not have MES Tables in it yet), an Exception appears in the logs if the configuration setting: **Read Uncommitted Snapshot** is set to OFF.

**See an example of this Exception** in [Database Configuration Best Practices](/articles/user-manual/database-connections/a/h4_190922633).

Modules require MSSQL database connections to use Read Committed Snapshot. Fresh databases will be forced to have the setting turned on, and prevent module spin up. Upgraded gateways will only log a warning, but allow module spin up.

| ![Warning](/resources/Storage/knowledge-base/Warning.png) | Use these instructions to fix this error:<br><br>**Caused by: com.sepasoft.production.common.db.exception.DBRCSException:**<br>**Failed to create MES tables for (database\_name) because MSSQL Read\_Committed\_Snapshot mode is OFF.**<br>**Fix this by setting the Read\_Committed\_Snapshot mode to ON in your MSSQL database configuration.** |
| --- | --- |

See below:

* [Fix this Error by Turning Snapshot Mode​ On](/articles/knowledge-base/database-add-check-for-mssql-snapshot-on-startup/a/h3_577910023)
* [Fix this Error by Skipping Snapshot Check](/articles/knowledge-base/database-add-check-for-mssql-snapshot-on-startup/a/h3__672029319)

| ![Note](/resources/Storage/knowledge-base/Note.png) | Version Specific: **MES 3.81.9 SP4 and later** |
| --- | --- |

When a new MSSQL Database is created, it is likely that the isolation level it is set to is **Read UnCommitted.**

You must use "**Read Committed Snapshot**" mode.

| ![Note](/resources/Storage/knowledge-base/Note.png) | Check the database configuration's Isolation Level with the following query:<br>
```
DBCC USEROPTIONS WITH NO_INFOMSGS
```
 |
| --- | --- |

* One of the returned options is the "isolation level."

https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-useroptions-transact-sql?view=sql-server-ver16

| ![Note](/resources/Storage/knowledge-base/Note.png) | Information about these:<br><br>https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-useroptions-transact-sql?view=sql-server-ver16 |
| --- | --- |

#### Fix this Error by Turning Snapshot Mode​ On

* Use this command to turn on snapshot mode:


```
ALTER DATABASE MyAnalysisDBName SET READ_COMMITTED_SNAPSHOT ON
```


![](/resources/Storage/knowledge-base/database-add-check-for-mssql-snapshot-on-startup/image%20%2837%29.png)

| ![Warning](/resources/Storage/knowledge-base/Warning.png) | **Warning:**Please make sure that no other active connections are open on this database, or else the query will not run. This includes open MSSQL Studio Manager tabs with open result sets on this database.<br>\*\*Upon restarting the modules, the MES modules should successfully spin up. |
| --- | --- |

* **If upgrading and already running MSSQL**, a warning appears, but the modules continue running.

![](/resources/Storage/knowledge-base/database-add-check-for-mssql-snapshot-on-startup/database-add-check-for-mssql-snapshot-on-startup-2024-03-25-1.png)

#### Fix this Error by Skipping Snapshot Check
Sometimes, users do not have rights to change options on their database.

In this scenario, there is a Java Virtual Machine Argument (JVM Arg) that can be interpreted by the **ignition.conf** file located in Ignition's installation directory.

In the configuration file under Wrapper Java Properties &gt; Java Additional Parameters, there are a series of arguments in the format of "wrapper.java.additional.#" where the number is just a running count of the list of active arguments.

To skip the Snapshot check entirely, bypassing the need to have database access rights, add the line:

```python
wrapper.java.additional.8=-Dcom.sepasoft.validateDatabaseRCSMode=False
```


| ![Note](/resources/Storage/knowledge-base/Note.png) | **I** **f you encounter database performance issues, we will require that you turn Snapshot On** |
| --- | --- |