Micro Focus Studio Enterprise Edition for Windows > Deployment > Configuration and Administration > Enterprise Server Configuration and Administration > Configuring the Server Instance Environment > Using XA-Compliant Resources > Configuring XA Resources for an Enterprise Server Instance > To Add an XA Resource > Resource Manager Definition for SQL Server Switch Module

Resource Manager Definition for SQL Server Switch Module

To define the SQL Server XA switch module in Enterprise Server, add an XA resource including the following values.

In the Module field, enter the full path to esmssql.dll
In the Open string field, type the following:
```
DSN=odbc_dsn[,USRPASS=userid.password][,CONNECTNAME=connectname]
   [,DTCSERVER=dtcsrvr]
```
where the parameters are:

odbc_dsn

The ODBC Data Source Name used to connect to the data source as defined within the Windows ODBC Data Source Administrator utility.¹

userid

The user ID required to connect to the data source. Not required when using trusted connections.¹

password

The password required to connect the user ID to the data source. Not required when using trusted connections. ¹

connectname

The name used by OpenESQL to identify the connection. Specify this only if you have multiple connections.²

dtcsrvr

The name of the machine hosting the Microsoft Distributed Transaction Coordinator (MSDTC) that creates the transaction objects. If not specified, the local machine is used.

¹ Alternatively, you can specify the DSN, user ID, and password by manually coding them into the esmssql.cbl source. This can be helpful if you want to ease security. To do this, search for CUSTOMIZE within esmssql.cbl to see where to apply the required changes.

² You must also code a reference to this connection name into the source for your deployed container-managed service as follows:

EXEC SQL SET CONNECTION connectname END-EXEC

Where connectname is the name specified in the Open string field on the Enterprise Server XA Resources tab.