---
title: Connecting to your OMS Database
description: OMS ERP is hosted on Microsoft SQL Server. The database supports connections via both Windows Authentication and SQL Server Authentication (username/password).
---

[Skip to content](https://support.mastersystem.com/oms-erp/installation-updates/connecting-to-your-oms-database#main-content)

English

Show submenu for translations

![pavo\_oms\_no\_shadow.png\]](https://support.mastersystem.com/hs-fs/hubfs/pavo_oms_no_shadow.png?height=45&name=pavo_oms_no_shadow.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Go to mastersystem.com](https://www.mastersystem.com/)

[Go to mastersystem.com](https://www.mastersystem.com/)

 Get Support with OMS/Pavo

- There are no suggestions because the search field is empty.

1. [OMS/Pavo Support](https://support.mastersystem.com/?hsLang=en)
2. [OMS ERP](https://support.mastersystem.com/oms-erp?hsLang=en)
3. [Installation & Updates](https://support.mastersystem.com/oms-erp?hsLang=en#installation-updates)

# Connecting to your OMS Database

## OMS ERP is hosted on Microsoft SQL Server. The database supports connections via both Windows Authentication and SQL Server Authentication (username/password).

OMS ERP retrieves its database connection settings from an INI file and supports either Windows Authentication or SQL Server Authentication (username/password).

By default, OMS ERP installations use Windows Authentication. Please consult your network administrator or IT department if you wish to use SQL Server Authentication.

### **Prerequisites**

Make sure you have the following:

- Access to the network where SQL Server is hosted as well as where OMS ERP is installed
- If using Windows Authentication: A valid Windows account that can connect to SQL Server
- If using SQL Server Authentication: SQL Server username/password with the appropriate permissions

### Configure INI files for Database Connection

OMS ERP uses two INI files for database connection and settings. Locate the following files:

- omssql.ini
- oms\_config.ini

Depending on your installation, the **omssql.ini** file is typically located in either of the following places:

- The same directory as your OMS ERP files (Version 202501 or later)
- C:\\Windows (for older installations)

**oms\_config.ini** is a file automatically generated by OMS ERP on versions 202501 and later. This file will be located in the same directory as your OMS ERP files.

**Example INI File Contents** 

**omssql.ini**

`[OMS SQL] omssqlserver=SQLSERVERNAME omsdatabase=master omsuser=omsuser,password ; Required for SQL Authentication only`

**oms\_config.ini**

`[OMS Config] omssystem=GMW use_sql_authorized=0`

#### To connect with Windows Authentication

1. Your Windows user must be joined on same workgroup as the SQL Server database.
2. The file **omssql.ini** does not need the **omsuser** key since it will be ignored.
3. Set the **use\_sql\_authorized** key in **oms\_config.ini** to 0 or not present in order for Windows Authentication to be used.
4. Restart OMS ERP

#### To connect with SQL Authentication

1. Set the username and password in the format of `username,password` under the **omsuser** key in **omssql.ini**.
2. In **oms\_config.ini,** set **use\_sql\_authorized** to 1 to use SQL Authentication
3. Restart OMS ERP

---

### If you are unable to connect

OMS ERP will launch immediately and prompt you with a login screen if it has a successful connection to the SQL Server database. If it does not, please verify the following:

- **Login failed:** Verify the credentials in the INI file and ensure your username and password have access to the SQL Server database, or that your Windows user is part of the same workgroup
- **Cannot reach the database**: Verify the server name is correct and reachable. SQL Server may require ports to be opened on the host computer's firewall (TCP 1433, 4022, 135, 1434, UDP 1434 inbound ports)
- **Microsoft 365 accounts are not directly supported:** SQL Authentication does not support a Microsoft account. To use Microsoft accounts, you will need to perform the following:  
    - Login to your SQL Server Management Studio (SSMS) as an admin account
    - Navigate to **Security \> Logins**
    - Right Click **Logins** and select **New Login**
    - Add your Microsoft account in the format `MicrosoftAccount\<username@youremail.com>`
- **Verify with SQL Server Management Studio (SSMS):** SSMS is an application from Microsoft to administer and manage SQL Server. If you are unable to connect to SQL Server with this application, please consult your network administrator. You can [download the latest version of SSMS here](https://learn.microsoft.com/en-us/ssms/download-sql-server-management-studio-ssms).

- [Onboarding](https://support.mastersystem.com/onboarding?hsLang=en#main-content)

    - [Data Conversion](https://support.mastersystem.com/onboarding?hsLang=en#data-conversion)
    - [OMS (On-Premise)](https://support.mastersystem.com/onboarding?hsLang=en#oms-on-premise)
    - [Pavo](https://support.mastersystem.com/onboarding?hsLang=en#pavo)
    - [Archived](https://support.mastersystem.com/onboarding?hsLang=en#archived)
- [OMS ERP](https://support.mastersystem.com/oms-erp?hsLang=en#main-content)

    - [System Administration](https://support.mastersystem.com/oms-erp?hsLang=en#system-administration)
    - [Installation & Updates](https://support.mastersystem.com/oms-erp?hsLang=en#installation-updates)
- [OMS Cloud](https://support.mastersystem.com/oms-cloud?hsLang=en#main-content)

    - [Onboarding](https://support.mastersystem.com/oms-cloud?hsLang=en#onboarding)
    - [General Usage](https://support.mastersystem.com/oms-cloud?hsLang=en#general-usage)
    - [Archived](https://support.mastersystem.com/oms-cloud?hsLang=en#archived)
- [OMS Cloud & Pavo Add-Ons](https://support.mastersystem.com/oms-cloud-pavo-add-ons-1?hsLang=en#main-content)

    - [Email Module](https://support.mastersystem.com/oms-cloud-pavo-add-ons-1?hsLang=en#email-module)
    - [Credit Card Module](https://support.mastersystem.com/oms-cloud-pavo-add-ons-1?hsLang=en#credit-card-module)
    - [Shipping](https://support.mastersystem.com/oms-cloud-pavo-add-ons-1?hsLang=en#shipping)
    - [PavoConnect](https://support.mastersystem.com/oms-cloud-pavo-add-ons-1?hsLang=en#pavoconnect)
- [Pavo Integrations](https://support.mastersystem.com/pavo-integrations?hsLang=en#main-content)

    - [Overview](https://support.mastersystem.com/pavo-integrations?hsLang=en#overview)
    - [Rithum (CommerceHub)](https://support.mastersystem.com/pavo-integrations?hsLang=en#rithum-commercehub)
    - [NuORDER](https://support.mastersystem.com/pavo-integrations?hsLang=en#nuorder)
    - [WooCommerce](https://support.mastersystem.com/pavo-integrations?hsLang=en#woocommerce)
    - [BigCommerce](https://support.mastersystem.com/pavo-integrations?hsLang=en#bigcommerce)
- [Pavo Admin](https://support.mastersystem.com/pavo-admin?hsLang=en#main-content)

    - [Payments](https://support.mastersystem.com/pavo-admin?hsLang=en#payments)
    - [Shipping](https://support.mastersystem.com/pavo-admin?hsLang=en#shipping)
    - [Clarion Server](https://support.mastersystem.com/pavo-admin?hsLang=en#clarion-server)
    - [Email](https://support.mastersystem.com/pavo-admin?hsLang=en#email)
- [Pavo Websites (B2B & Sales Rep)](https://support.mastersystem.com/pavo-websites-b2b-sales-rep?hsLang=en#main-content)

    - [Domain & URLs](https://support.mastersystem.com/pavo-websites-b2b-sales-rep?hsLang=en#domain-urls)
    - [Using your site](https://support.mastersystem.com/pavo-websites-b2b-sales-rep?hsLang=en#using-your-site)

[![Chill listening crop-3](https://support.mastersystem.com/hs-fs/hubfs/pavo_oms_no_shadow.png?width=85&height=24&name=pavo_oms_no_shadow.png "Chill listening crop-3")](https://support.mastersystem.com?hsLang=en)

OMS/Pavo Support

Copyright © 2026, Master System, Inc.