Configure SQL Server for User

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

Note: If in IIS, Authentication mode is set to Windows Authentication for Innowera Control Panel then Windows domain user needs to create login for SQL Server.

Create Login for User in SQL Server

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

To create login for a user in Microsoft 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 the Enter the object name to select box and select Object Types. The Object Types dialog appears.

   

4. Select Users from the list of object types and select OK.
5. On Select User or Group dialog, select Check Names to verify the user name entered.
6. Select OK to close the dialog. The user name appears on the Login-New page in the Login name list.
7. 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

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

You need to create database user group for SQL Server so that appropriate Windows Domain user 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 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. For example, enter JSmith and select Login name check box.
5. Select the 3 dots icon. The Select Login dialog appears.
6. Select Browse. The Browse for Objects page appears.

   

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

   

9. On Database role membership section, select db_datareader and db_datawriter to provide read or write permissions.
10. 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 in SQL Server

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

To provide access to Innowera Control Panel user,

1. Go to Microsoft SQL Server Management Studio > INW_iCtrlPanel > Programmability > CheckProcessScheduleTime.
2. Right-click CheckProcessScheduleTime and select Properties. The Stored Procedure properties - CheckProcessScheduleTime page appears.
3. Select Permissions and select Add. 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. For example, JSmith and select Ok. The selected user appears in the Enter the objects name to select section.
   
6. Select OK to exit the dialog. The permission is applied to the user.
7. On the Stored Procedure properties - CheckProcessScheduleTime page, select the Innowera Control Panel user to which you want to provide permission, and then select the Grant check box for the Permission. For example, if you select JSmith and provide Grant permission for Execute.

   

8. Select Ok. The permission is applied to the user.