SQL Server Login account has been granted "Execute" privileges on my ConnectWise database to enable execution of built-in ConnectWise-written stored procedures: *
The Executive Briefing Service executes some ConnectWise-written stored procedures that are included with your ConnectWise database to accurately retrieve ConnectWise database directly through SQL. To do that, you need to provide "execute" privileges for the read-only account you set up in the prior step. To provide "execute" privileges from within SQL Server Management Studio: 1) Right click your ConnectWise database 2) From the "Select a page" list on the upper-left, select "Permissions" 3) In the "Users and Roles" section, select the name of the read-only account you have created for New Haven. 4) In the "Permissions" section at the bottom of the page, scroll the list to "Execute", and click the "Execute" checkbox. (If you have problems or question, please e-mail "SetUp@NewHavenTech.com" and we'll send you the instructions.) I have granted "execute" privileges on my ConnectWise database to the read-only account I have created for New Haven: