SQL Server user provider |

|
The SQL Server user provider replaces the existing FeedbackServer user management system by our own SQL Server based user and groups tables. Thanks to this provider we can directly re-use existing SQL server tables which contains information about users and groups to which we will grant access to the administration section of FeedbackServer.
Once configured the provider will use the users and groups from our custom SQL Server tables.
In order to configure the SQL Server provider you will need to remove the original web.config and rename the web.SQL.config.
Once you have renamed your web.SQL.config to web.config you will need to setup following elements using a texteditor like notepad to edit your web.config file.
- sqlUserProviderConnectionString is the connection that FeedbackServer will use to connect to your SQL Server database containing the user and group tables.
- sqlUserProviderFeedbackServerAdminUserName is the user within our custom user table that will always have administrative privileges within FeedbackServer.
- sqlUserProviderPasswordEncryptionType if our user table has its password encrypted we can choose the method to validate the passwords given by the users to authenticate within FeedbackServer against our user table password column. Following password encryption validation method are supported :
- None
- Sha5
- MD5
SQL queries to our SQL user and groups tables can be specified using following attributes. Note that @username, @Password, @UserId text is replaced dynamically by FeedbackServer at runtime with the corresponding runtime value.
- sqlUserProviderAuthenticationQuery is the query used by FeedbackServer to authenticate a user from the administration section login screen.
- sqlUserProviderUsersQuery is the query to get all users from our custom SQL user table. Feedback Server will always take the first column in the select as the ID and the second one as the username.
- sqlUserProviderGroupsQuery is the query to get all groups from our custom SQL group table. Feedback Server will always take the first column in the select as the group ID and the second one as the group name. Leave blank if no custom group table is available.
- sqlUserProviderUserGroupsQuery is the query to get all groups for the given user id.
- sqlUserProviderUserNameQuery is the query to get the username based on the user id.
Once you have configured the new user provider, you may access FeedbackServer using any user and password available within the custom SQL Server user table.