#### SQL User Mapping

In SQL Server Management Studio expand Security > Logins, select the Users (for example, ION) and then right-click ION and select Properties.

The Login Properties-ION window opens. Select User Mapping and in the Users mapped to this login section, select the appropriate Databases, User, and Default Schema based on the following:

Logins | Database | User | Default Schema | Role Membership
--- | --- | --- | --- | ---
EPSS_DataCollector | ApplicationModule | EPSS_DataCollector | dbo | AMApplicationRole, public
ION_Data | EPSS_DataCollector | dbo | Db_datacreader, EPSS, DataCollectorAccess, public
ION_Network | EPSS_DataCollector | dbo | Db_datareader, public
AMUser | ApplicationModules | AMUser | Dbo | AMApplicationRole, public
ION | ION_Data | dbo | dbo | Db_owner, public
ION_Network | dbo | dbo | Db_owner, public
ION_SystemLog | dbo | dbo | Db_owner, public
ionedsd | ION_Data | ionedsd | dbo | ION_DSD_Reader, public
ION_Network | ionedsd | dbo | NOM_DSD_Reader, public
Report | ION_Data | Report | dbo | db_datareader, ION_Reader, public

PME Segment Edition Note: For the EPSS Data Collector user, the mappings are available only for Data Center edition and Healthcare edition (not for PME installations). The screen below shows user mapping in SQL Server Management Studio.

Note: If a “user exists” message is observed during the user mapping process, contact Schneider Tech Support. They will probably have to delete the user from Security > Login > User(s).

You can also use the following query to see if there are issues with the “user exists” message:

`ALTER AUTHORIZATION ON DATABASE::ION_Data TO ION;`