search

microsoft / Reporting-Services

Git repo for SQL Server Reporting Services and Power BI paginated report samples, and community projects
MIT License
420 stars 363 forks source link

Email subscription #233

Open MSAGH opened 3 years ago

MSAGH commented 3 years ago

Is it possible to set up email subscriptions when using custom authentication? If so, what configuration changes have to be made?

The following error is in the windows application logs when trying to deliver an email via email subscription:

Report Server Windows Service (MSSQLSERVER) cannot load the Forms extension.

eneerge commented 3 years ago

I have the same question. I can't seem to get the web service to authorize anything, either, when using custom security.

sudcha commented 3 years ago

For Form or custom authentication you need to refer to __viewstate based solution.

https://stackoverflow.com/questions/49876741/how-to-call-ssrs-rest-api-v1-0-with-custom-security-implemented-not-soap https://odetocode.com/Articles/162.aspx

eneerge commented 3 years ago

I just got this to work with my custom extension. I didn't use viewstate I don't think.. at least not intentionally. Posting my extension to my personal GitHub soon.

MSAGH commented 3 years ago

@eneerge you got the email subscription to work?

eneerge commented 3 years ago

The way I use subscriptions is by sending only a link so that there's no data in the email and the user is required to login to access. Subscriptions sent like this works for me.

However, I just tried testing a subscription where the data file is included and I am getting an error. "The Report Server PowerBI extension failed to read its configuration settings from the RSReportServer.config configuration file. The extension is not available to users."

I will have to look into this.