September 1, 2016 at 7:50 am
Need some assistance my fellow SSRS friends.
My company has an existing report server. All is working just fine when accessing and running the reports. However, when the server was set up, it was never configured for email subscriptions. I look in the Email option of the Report Server Config Manager and whoever made this server did fill out the required fields. However, subscriptions do not function.
I did a lot of searching last night and pretty much the results I found was to install the SMTP feature. I did this, but still nothing.
So I looked at an existing report server which is pretty identical as the problem server. However, the good server doesnt have SMTP set up and email subscriptions works just fine. I compared the good server settings to the bad server settings and they're pretty much the same.
Then this morning I logged into both server this morning to give see what's different. What I saw is that the good server has Active Directory set up and the bad server doesnt.
I guess my question is, does the report server require to have Active Directory installed? If not, what else can I look for to get this going? Thanks.
Let me know if more information is needed to assist.
September 1, 2016 at 10:59 am
DarthBurrito (9/1/2016)
Need some assistance my fellow SSRS friends.My company has an existing report server. All is working just fine when accessing and running the reports. However, when the server was set up, it was never configured for email subscriptions. I look in the Email option of the Report Server Config Manager and whoever made this server did fill out the required fields. However, subscriptions do not function.
I did a lot of searching last night and pretty much the results I found was to install the SMTP feature. I did this, but still nothing.
So I looked at an existing report server which is pretty identical as the problem server. However, the good server doesnt have SMTP set up and email subscriptions works just fine. I compared the good server settings to the bad server settings and they're pretty much the same.
Then this morning I logged into both server this morning to give see what's different. What I saw is that the good server has Active Directory set up and the bad server doesnt.
I guess my question is, does the report server require to have Active Directory installed? If not, what else can I look for to get this going? Thanks.
Let me know if more information is needed to assist.
When you say that subscriptions do not function what specifically do you mean? What are the errors or what exactly does not function. Are components running - the Report server, SQL Agent and the SMTP server or however you have this piece set?
Did you check the SSRS log and see what is happening when a subscription triggers? Or if they are triggering? Do you see the jobs for the subscriptions?
When you compared the two servers, did you look at the RSreportserver.config file? That has the email settings and any additional settings for email configuration. It should all be contained within the <RSEmailDPConfiguration> section.
You wouldn't typically install Active Directory on every server so I'm not sure what you are seeing there or what kind of network you have setup. Is the server is a member of a domain? Are these servers in the same domain or do you have a forest of some sort?
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply