Create the Data Connector SQL Login and User

For the data connector, the ACM_Import and EFM buffer database will need a user created in Microsoft SQL Server to transform and send the AutoSol data to Measurement Advisor.

It is recommended that a Windows group is used for this (for example, the AVEVA Apps group) so that the Microsoft SQL Server can be configured to use Windows Authentication mode only.

1. Open Microsoft SQL Server Management Studio and connect to the database instance on the server that will be running the data connector service.

2. Use these commands to create the user and set the required permissions. Substitute your domain or hostname for MYDOMAIN. If your EFM buffer database is not named EFM, update the below command to better reflect your setup:

   use master

   CREATE LOGIN [MYDOMAIN\AVEVA Apps] FROM WINDOWS WITH DEFAULT_DATABASE=[EFM], DEFAULT_LANGUAGE=[us_english]

   use EFM

   CREATE USER [AVEVA Apps] FOR LOGIN [MYDOMAIN\AVEVA Apps] WITH DEFAULT_SCHEMA=[dbo]

   ALTER ROLE db_datareader ADD MEMBER [AVEVA Apps]

   ALTER ROLE db_datawriter ADD MEMBER [AVEVA Apps]

   GRANT EXECUTE TO [AVEVA Apps]

   use ACM_Import

   CREATE USER [AVEVA Apps] FOR LOGIN [MYDOMAIN\AVEVA Apps] WITH DEFAULT_SCHEMA=[dbo]

   ALTER ROLE db_datareader ADD MEMBER [AVEVA Apps]

   ALTER ROLE db_datawriter ADD MEMBER [AVEVA Apps]

   GRANT EXECUTE TO [AVEVA Apps]