Adding a SQL Server login to the embedded SQL Server

  1. Open SQL Server Management Studio (SSMS) and sign in to the Platform Database, using Windows Authentication, as the user that installed Web UI.

  2. Open the SQL Server properties and the change the Server authentication selection to SQL Server and Windows Authentication mode. Click OK.

    SQL Server properties.

  3. For the SQL Server, add a new Login name and Password. For Default database, select Itron.Platform.Database. Click OK.

    Location of the SQL Server options for SQL Server properties.

  4. Select User Mapping, and then select the Map checkbox for the user and database from the previous step. This maps the new user to the Itron.Platform.Database. Click OK.

    Location of the User Mapping option for SQL Server properties.

    Note: If needed, the user can also be granted additioinal role memberships on this screen.