Configure SQL Server for Web and Mobile Server

This section will demonstrate how to configure Microsoft SQL Server with Windows Authentication for Web and Mobile Server. This involves assigning desired roles to Users or User Group in SQL Server.

In the first step, we are assuming that you must create New Login for Users Group and Users. However, it is very likely that this step is already performed if you have other databases running on the SQL server you are working with. In that case, you can skip this 1st section by using existing SQL ‘Logins’ of ‘Users Group’ and ‘Users’ and directly go to the next section i.e Configure SQL Server for Innowera Web and Mobile Server for Single User.

To understand Users Group and Users setting we will use ‘InnoUsersGrp’ and ‘InnoUser’ as an example. You will be using different values for users group and users as per your requirement.