Modern Survey Connection - Take Survey URL (On-Premises Deployments)

when an incident is closed, a 'take survey' end point url is generated, directing end users to submit their survey responses previously, this url lacked authentication as part of our security enhancements, we've introduced sql user authentication for accessing the 'take survey' endpoint the endpoint now requires the creation and linkage of a specific sql user to tenants to function correctly ensure that the required sql user is set up and associated with the relevant tenants for continued access to the 'take survey' url take survey end point https //{tenant url}/heatsurvey/takesurvey?action=take survey configuring an sql user for each tenant database create a separate sql user for each tenant database in your landscape, create a dedicated sql user with limited permissions using below sql query ensure to replace \<username>, \<password>, and \<db name> with the appropriate values \ ================================================ \ step 1 create login and database user \ ================================================ create login \<username> with password = '\<password>', check policy = off, default database = \<db name>; use \<db name>; go exec \[sys] \[sp adduser] '\<username>'; go \ ================================================ \ step 2 create the surveyrole database role \ ================================================ create role \[surveyrole]; go \ ================================================ \ step 3 add user to surveyrole \ ================================================ alter role \[surveyrole] add member \<username>; go \ ================================================ \ step 4 grant permissions to surveyrole \ ================================================ grant select on \[dbo] \[frs survey] to \[surveyrole]; grant select on \[dbo] \[frs surveyquestion] to \[surveyrole]; grant select on \[dbo] \[frs surveyquestioncategory] to \[surveyrole]; grant select on \[dbo] \[frs surveychoice] to \[surveyrole]; grant select, update, insert on \[dbo] \[frs surveysession] to \[surveyrole]; grant select, update, insert on \[dbo] \[frs surveyanswer] to \[surveyrole]; grant select, update on \[dbo] \[frs surveytokens] to \[surveyrole]; go for on premises deployments, the following sql statement is required only in version 2026 2 and later grant select, update on \[dbo] \[frs surveytokens] to \[surveyrole]; configure the sql user in the tenant log in to the config tenant navigate to the tenants workspace select the tenant where the sql user was created navigate to the survey connection child tab enter the sql user’s username and password created in step 1 docid\ rurokg0t6qq1az4zgt7p8 into the survey username and survey password fields save the configuration this document applies only to on premises deployments saas customers do not need to need to perform these steps javascript\ void(0); # related topics