SQL Server accounts

The database server hosts several databases for Power Monitoring Expert (PME). The following tables lists the SQL Server logins and permissions created for PME:

For installations with SQL Server Authentication:

Login	Authentication	Server Role	Database	Membership
AMUser	SQL	Public	ApplicationModules	AMApplicationRole
ION	SQL	Public	ApplicationModules	db_owner
			ION_Data	db_owner
			ION_Network	db_owner
			ION_SystemLog	db_owner
ionedsd	SQL	Public	ION_Data	ION_DSD_Reader
ionedsd	SQL	Public	ION_Network	NOM_DSD_Reader
IONMaintenance*	Windows	Public	ApplicationModules	db_backupoperator, db_ddladmin, Maintenance
			ION_Data	db_backupoperator, db_ddladmin, Maintenance
			ION_Network	db_backupoperator, db_ddladmin, Maintenance
			ION_SystemLog	db_backupoperator, db_ddladmin, Maintenance

* This account is only created on standalone servers where the SQL Server software and PME are installed on the same computer.

For installations with Windows Integrated Authentication:

Login	Authentication	Server Role	Database	Membership
Account used for Windows Integrated Authentication	Windows	Public	ApplicationModules	db_owner
			ION_Data	db_owner
			ION_Network	db_owner
			ION_SystemLog	db_owner
IONMaintenance *	Windows	Public	ApplicationModules	db_backupoperator, db_ddladmin, Maintenance
			ION_Data	db_backupoperator, db_ddladmin, Maintenance
			ION_Networks	db_backupoperator, db_ddladmin, Maintenance
			ION_SystemLog	db_backupoperator, db_ddladmin, Maintenance

* This account is only created on standalone servers where the SQL Server software and PME are installed on the same computer.

NOTE: When PME is installed with Windows Integrated Authentication, the Windows account that is used to access the database is also used to run the PME services and the IIS Application Pools.

Other

PME must have access to the master and tempdb System Databases.

The PME Database Manager tool requires that the Windows account that is used to run it has sysadmin permissions on the PME SQL Server instance. The Database Manager is an optional tool, used for managing the PME databases.