question

Shawn avatar image
Shawn asked

SSRS Subscription not loading in Browser

I have SSRS set up with IIS and SQL on separate servers and can no longer add new subscriptions from the web interface.

ssrssubscriptions
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Fatherjack avatar image
Fatherjack answered

When you say "no longer", what has changed since it did work?

3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Shawn avatar image Shawn commented ·
they worked when IIS and SQL were on the same machine.
0 Likes 0 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
OK, I would make make a guess that its permissions based, possibly that SSRS is using a server account for its subscription execution that doesnt have the required db access - possibly in reportserver database or database where the report is getting its data. Or, maybe the data source being used has the wrong credentials.
0 Likes 0 ·
Shawn avatar image Shawn commented ·
the SSRS setup has NT Authority\NetworkService as both the Web Service Identity, the Windows Service Identity and the Application Pool, the same user is in the DB with the role of both RSExecRole and DB_owner. I am currently using windows authentication but think it's when I edit a report the modified user is NT Authority\NetworkService not my user that logged into the site. anonymous access it turned off.. I must be missing permissions somewhere but sure don't know where that is
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.