Configure SQL Server for User Group

This section explains how to create, configure, and provide permissions to Windows domain user group who can access SQL Server where Innowera Control Panel database is installed.

Note: In IIS, if the authentication mode is set as Windows Authentication for Innowera Control Panel, then the user groups in SQL Server must be provided the permission to access Innowera Control Panel.

Create Login for User Group in SQL Server

This section explains how to create login for a user group in SQL Server.

Note: Perform the following steps if your Windows domain user group does not have a SQL Server login.

To create login for a user group in SQL Server,

1. Go to Microsoft SQL Server Management Studio > Security > Logins. Right-click Logins and select New Login. The Login-New page appears.
2. Select Search. The Select user or Group dialog appears.
3. Enter user name in Enter the object name to select (example: InnoUserGrp) and select Object Types. The Object Types dialog appears.
4. Select Groups from the list and select OK.
5. Select the user name on Select User or Group page and select Check Names. The information of the selected user name appears on the Login-New page.
6. Select the default database as INW_iCtrlPanel and select OK. The newly added login appears under Logins on Object Explorer Details page.

Create, Configure Innowera Control Panel Database User Group

This section explains how to create and configure a Innowera Control Panel database user group in SQL Server.

You need to create database user group for SQL Server, so that appropriate Windows Domain user groups can have access to the Innowera Control Panel database.

Note: Perform the following steps when you install Innowera Control Panel database for the first time or when you want to add or remove additional users at a later stage.

To configure Innowera Control Panel user group in Microsoft SQL Server,

1. Go to Microsoft SQL Server Management Studio.
2. Select Databases to view the list of databases.
3. Select INW_iCtrlPanel, right-click Users and select New User. The Database User - New page appears.
4. Enter username in User name (example: InnoUserGrp), select Login name check box, and select the 3 dots icon. The Select Login dialog box appears.
5. Select Browse. The Browse for Objects page appears.

   

6. Select [LITWAREINC\InnoUserGrp] and select OK. The selected object appears in Enter the object names to select.
7. Select OK, on the Select login dialog, select OK. The created user group appears on Database User - New page.

   

8. On Database role membership section, select db_datareader and db_datawriter to provide read or write permissions.
9. Select OK to exit the Database User - New page. On Microsoft SQL Server Management Studio > INW_iCtrlPanel database > Users, the newly added user appears.

Provide Permission to Innowera Control Panel User Group in SQL Server

This topic explains how to provide database permissions to Innowera Control Panel user group in SQL Server.

To provide access to Innowera Control Panel user group,

1. Go to Microsoft SQL Server Management Studio > INW_iCtrlPanel > Programmability > Stored Procedures > CheckProcessScheduleTime.
2. Right-click CheckProcessScheduleTime and select Properties. The Stored Procedure properties - CheckProcessScheduleTime page appears.
3. Select Search. The Select Users or Roles dialog appears.
4. On Enter the objects name to select, select Browse. The Browse for objects dialog appears.

   

5. Select a user group. For example, InnoUserGrp and select OK. The selected user group appears in the Enter the objects name to select section.
6. Select OK to exit the dialog.
7. On the Stored Procedure properties - CheckProcessScheduleTime page, select the Innowera Control Panel user group to which you want to provide permission, and then select the Grant check box for the Permission. For example, if you select InnowUserGrp and provide Grant permission for Execute.

   

8. Select OK. The permission is applied to the user group.