Create the Request Connector SQL Login and User

For the request connector, the AutoSolCM database will need a user created in the Microsoft SQL Server to write the gas quality download data to the AutoSol database.

It is recommended that a Windows group is used for this (for example. the AVEVA Apps group) so that this 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 request connector service.

2. Use these commands to create the user and set the required permissions. Substitute your domain or hostname for MYDOMAIN.

   use master

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

   use AutoSolCM

   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 on asi_spResolveGcMeters to [AVEVA Apps]

   grant execute on asi_spGCInsertRequest to [AVEVA Apps]

   grant exec on asi_spGCGetRequestStatus to [AVEVA Apps]