Sunday, 12 February 2012

Configuring a Report Server for E-Mail Delivery

I've installed Report Services and need to setup the E-Mail Delivery.
There are documents like 'Configuring a Report Server for E-Mail Delivery'
that talk about entering values in the SMTPServer field in the
rswebapplication.config file, but there isn't enough specific information
about setting up e-mail delivery.
What needs to be done to setup e-mail delivery?
Thanks,
JimAre you just talking about a basic subscription? If so, during the
installation you were asked for an smtp server.
That should be all it takes. You might try to create a subscription and
see what happens.
You can also edit the config file and change the SMTP server, but I have
no experience with that.
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:Jim@.discussions.microsoft.com:
> I've installed Report Services and need to setup the E-Mail Delivery.
> There are documents like 'Configuring a Report Server for E-Mail Delivery'
> that talk about entering values in the SMTPServer field in the
> rswebapplication.config file, but there isn't enough specific information
> about setting up e-mail delivery.
> What needs to be done to setup e-mail delivery?
> Thanks,
> Jim|||It can be done during installation but otherwise just do the following:
If you have a smtp server somewhere then you can just use that and use the
mail client that comes with Reporting Services. That is what I do.
In rsreportserver.config look for:
<SMTPServer>123.45.6.78</SMTPServer>
and put in the address for your smtp server. I found I had to hardcode the
address rather than use the name.
Also put in this one as well:
<From>somebody@.somewhere.com</From>
These two are the minimum to put in. There are more items you can configure
but those two should get you going.
Of course, for this to work you smtp server needs to accept mail from
anonymous sources. If it doesn't then there is more you will have to do (in
my case I didn't so I can't help with that scenario).
Hopefully this gets you going in the right direction.
Note that you do not need any mail client installed on the server. RS just
sends your mail to an existing smtp server.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> I've installed Report Services and need to setup the E-Mail Delivery.
> There are documents like 'Configuring a Report Server for E-Mail Delivery'
> that talk about entering values in the SMTPServer field in the
> rswebapplication.config file, but there isn't enough specific information
> about setting up e-mail delivery.
> What needs to be done to setup e-mail delivery?
> Thanks,
> Jim|||Report Services were installed before the SMTP server, so I would like to
configure the email server without removing the Report Services.
Did try a subscription and it did not work.
"John Geddes" wrote:
> Are you just talking about a basic subscription? If so, during the
> installation you were asked for an smtp server.
> That should be all it takes. You might try to create a subscription and
> see what happens.
> You can also edit the config file and change the SMTP server, but I have
> no experience with that.
>
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:Jim@.discussions.microsoft.com:
> > I've installed Report Services and need to setup the E-Mail Delivery.
> >
> > There are documents like 'Configuring a Report Server for E-Mail Delivery'
> >
> > that talk about entering values in the SMTPServer field in the
> > rswebapplication.config file, but there isn't enough specific information
> >
> > about setting up e-mail delivery.
> >
> > What needs to be done to setup e-mail delivery?
> >
> > Thanks,
> > Jim
>
>|||What structure in the rsreportserver.config do the values belong in?
"Bruce L-C [MVP]" wrote:
> It can be done during installation but otherwise just do the following:
> If you have a smtp server somewhere then you can just use that and use the
> mail client that comes with Reporting Services. That is what I do.
> In rsreportserver.config look for:
> <SMTPServer>123.45.6.78</SMTPServer>
> and put in the address for your smtp server. I found I had to hardcode the
> address rather than use the name.
> Also put in this one as well:
> <From>somebody@.somewhere.com</From>
> These two are the minimum to put in. There are more items you can configure
> but those two should get you going.
> Of course, for this to work you smtp server needs to accept mail from
> anonymous sources. If it doesn't then there is more you will have to do (in
> my case I didn't so I can't help with that scenario).
> Hopefully this gets you going in the right direction.
> Note that you do not need any mail client installed on the server. RS just
> sends your mail to an existing smtp server.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> > I've installed Report Services and need to setup the E-Mail Delivery.
> >
> > There are documents like 'Configuring a Report Server for E-Mail Delivery'
> > that talk about entering values in the SMTPServer field in the
> > rswebapplication.config file, but there isn't enough specific information
> > about setting up e-mail delivery.
> >
> > What needs to be done to setup e-mail delivery?
> >
> > Thanks,
> > Jim
>
>|||The lines are already in there, you do not need to put them in, just search
for them and put your values in.
I.e. you will see this:
<SMTPServer></SMTPServer>
and you need to make it look like this
<SMTPServer>123.45.6.78</SMTPServer>
except, of course, put in the ip address. I had no luck putting the name in
for some reason so I put the IP address instead
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
> What structure in the rsreportserver.config do the values belong in?
> "Bruce L-C [MVP]" wrote:
> > It can be done during installation but otherwise just do the following:
> >
> > If you have a smtp server somewhere then you can just use that and use
the
> > mail client that comes with Reporting Services. That is what I do.
> >
> > In rsreportserver.config look for:
> > <SMTPServer>123.45.6.78</SMTPServer>
> > and put in the address for your smtp server. I found I had to hardcode
the
> > address rather than use the name.
> >
> > Also put in this one as well:
> > <From>somebody@.somewhere.com</From>
> >
> > These two are the minimum to put in. There are more items you can
configure
> > but those two should get you going.
> >
> > Of course, for this to work you smtp server needs to accept mail from
> > anonymous sources. If it doesn't then there is more you will have to do
(in
> > my case I didn't so I can't help with that scenario).
> >
> > Hopefully this gets you going in the right direction.
> >
> > Note that you do not need any mail client installed on the server. RS
just
> > sends your mail to an existing smtp server.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> >
> >
> > "Jim" <Jim@.discussions.microsoft.com> wrote in message
> > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> > > I've installed Report Services and need to setup the E-Mail Delivery.
> > >
> > > There are documents like 'Configuring a Report Server for E-Mail
Delivery'
> > > that talk about entering values in the SMTPServer field in the
> > > rswebapplication.config file, but there isn't enough specific
information
> > > about setting up e-mail delivery.
> > >
> > > What needs to be done to setup e-mail delivery?
> > >
> > > Thanks,
> > > Jim
> >
> >
> >|||The lines aren't in the file I have.
"Bruce L-C [MVP]" wrote:
> The lines are already in there, you do not need to put them in, just search
> for them and put your values in.
> I.e. you will see this:
> <SMTPServer></SMTPServer>
> and you need to make it look like this
> <SMTPServer>123.45.6.78</SMTPServer>
> except, of course, put in the ip address. I had no luck putting the name in
> for some reason so I put the IP address instead
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
> > What structure in the rsreportserver.config do the values belong in?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > It can be done during installation but otherwise just do the following:
> > >
> > > If you have a smtp server somewhere then you can just use that and use
> the
> > > mail client that comes with Reporting Services. That is what I do.
> > >
> > > In rsreportserver.config look for:
> > > <SMTPServer>123.45.6.78</SMTPServer>
> > > and put in the address for your smtp server. I found I had to hardcode
> the
> > > address rather than use the name.
> > >
> > > Also put in this one as well:
> > > <From>somebody@.somewhere.com</From>
> > >
> > > These two are the minimum to put in. There are more items you can
> configure
> > > but those two should get you going.
> > >
> > > Of course, for this to work you smtp server needs to accept mail from
> > > anonymous sources. If it doesn't then there is more you will have to do
> (in
> > > my case I didn't so I can't help with that scenario).
> > >
> > > Hopefully this gets you going in the right direction.
> > >
> > > Note that you do not need any mail client installed on the server. RS
> just
> > > sends your mail to an existing smtp server.
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > >
> > >
> > >
> > > "Jim" <Jim@.discussions.microsoft.com> wrote in message
> > > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> > > > I've installed Report Services and need to setup the E-Mail Delivery.
> > > >
> > > > There are documents like 'Configuring a Report Server for E-Mail
> Delivery'
> > > > that talk about entering values in the SMTPServer field in the
> > > > rswebapplication.config file, but there isn't enough specific
> information
> > > > about setting up e-mail delivery.
> > > >
> > > > What needs to be done to setup e-mail delivery?
> > > >
> > > > Thanks,
> > > > Jim
> > >
> > >
> > >
>
>|||Are you sure? Are you looking at rsreportserver.config , there is more than
one configuration file.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:D865ED28-C98C-471F-B900-CB5BAED34BD8@.microsoft.com...
> The lines aren't in the file I have.
> "Bruce L-C [MVP]" wrote:
>> The lines are already in there, you do not need to put them in, just
>> search
>> for them and put your values in.
>> I.e. you will see this:
>> <SMTPServer></SMTPServer>
>> and you need to make it look like this
>> <SMTPServer>123.45.6.78</SMTPServer>
>> except, of course, put in the ip address. I had no luck putting the name
>> in
>> for some reason so I put the IP address instead
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Jim" <Jim@.discussions.microsoft.com> wrote in message
>> news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
>> > What structure in the rsreportserver.config do the values belong in?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> > > It can be done during installation but otherwise just do the
>> > > following:
>> > >
>> > > If you have a smtp server somewhere then you can just use that and
>> > > use
>> the
>> > > mail client that comes with Reporting Services. That is what I do.
>> > >
>> > > In rsreportserver.config look for:
>> > > <SMTPServer>123.45.6.78</SMTPServer>
>> > > and put in the address for your smtp server. I found I had to
>> > > hardcode
>> the
>> > > address rather than use the name.
>> > >
>> > > Also put in this one as well:
>> > > <From>somebody@.somewhere.com</From>
>> > >
>> > > These two are the minimum to put in. There are more items you can
>> configure
>> > > but those two should get you going.
>> > >
>> > > Of course, for this to work you smtp server needs to accept mail from
>> > > anonymous sources. If it doesn't then there is more you will have to
>> > > do
>> (in
>> > > my case I didn't so I can't help with that scenario).
>> > >
>> > > Hopefully this gets you going in the right direction.
>> > >
>> > > Note that you do not need any mail client installed on the server. RS
>> just
>> > > sends your mail to an existing smtp server.
>> > >
>> > > --
>> > > Bruce Loehle-Conger
>> > > MVP SQL Server Reporting Services
>> > >
>> > >
>> > >
>> > >
>> > > "Jim" <Jim@.discussions.microsoft.com> wrote in message
>> > > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
>> > > > I've installed Report Services and need to setup the E-Mail
>> > > > Delivery.
>> > > >
>> > > > There are documents like 'Configuring a Report Server for E-Mail
>> Delivery'
>> > > > that talk about entering values in the SMTPServer field in the
>> > > > rswebapplication.config file, but there isn't enough specific
>> information
>> > > > about setting up e-mail delivery.
>> > > >
>> > > > What needs to be done to setup e-mail delivery?
>> > > >
>> > > > Thanks,
>> > > > Jim
>> > >
>> > >
>> > >
>>|||Bruce,
You were right. It was the wrong file.
Thanks,
Jim
"Bruce L-C [MVP]" wrote:
> Are you sure? Are you looking at rsreportserver.config , there is more than
> one configuration file.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:D865ED28-C98C-471F-B900-CB5BAED34BD8@.microsoft.com...
> > The lines aren't in the file I have.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> The lines are already in there, you do not need to put them in, just
> >> search
> >> for them and put your values in.
> >>
> >> I.e. you will see this:
> >> <SMTPServer></SMTPServer>
> >> and you need to make it look like this
> >> <SMTPServer>123.45.6.78</SMTPServer>
> >> except, of course, put in the ip address. I had no luck putting the name
> >> in
> >> for some reason so I put the IP address instead
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> >> news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
> >> > What structure in the rsreportserver.config do the values belong in?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> > > It can be done during installation but otherwise just do the
> >> > > following:
> >> > >
> >> > > If you have a smtp server somewhere then you can just use that and
> >> > > use
> >> the
> >> > > mail client that comes with Reporting Services. That is what I do.
> >> > >
> >> > > In rsreportserver.config look for:
> >> > > <SMTPServer>123.45.6.78</SMTPServer>
> >> > > and put in the address for your smtp server. I found I had to
> >> > > hardcode
> >> the
> >> > > address rather than use the name.
> >> > >
> >> > > Also put in this one as well:
> >> > > <From>somebody@.somewhere.com</From>
> >> > >
> >> > > These two are the minimum to put in. There are more items you can
> >> configure
> >> > > but those two should get you going.
> >> > >
> >> > > Of course, for this to work you smtp server needs to accept mail from
> >> > > anonymous sources. If it doesn't then there is more you will have to
> >> > > do
> >> (in
> >> > > my case I didn't so I can't help with that scenario).
> >> > >
> >> > > Hopefully this gets you going in the right direction.
> >> > >
> >> > > Note that you do not need any mail client installed on the server. RS
> >> just
> >> > > sends your mail to an existing smtp server.
> >> > >
> >> > > --
> >> > > Bruce Loehle-Conger
> >> > > MVP SQL Server Reporting Services
> >> > >
> >> > >
> >> > >
> >> > >
> >> > > "Jim" <Jim@.discussions.microsoft.com> wrote in message
> >> > > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> >> > > > I've installed Report Services and need to setup the E-Mail
> >> > > > Delivery.
> >> > > >
> >> > > > There are documents like 'Configuring a Report Server for E-Mail
> >> Delivery'
> >> > > > that talk about entering values in the SMTPServer field in the
> >> > > > rswebapplication.config file, but there isn't enough specific
> >> information
> >> > > > about setting up e-mail delivery.
> >> > > >
> >> > > > What needs to be done to setup e-mail delivery?
> >> > > >
> >> > > > Thanks,
> >> > > > Jim
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>
>
>

No comments:

Post a Comment