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).

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.