report server no longer sends emails

We had to change the administrator password recently. So I took the
opportunity and created a sql user (yes.. it is domain admin) and moved the
sql and reporting services to run under this user instead of administrator.
Since this time, my report server doesn't send out the reports via email. I
am not sure where to look to even determine what exactly the problem is.
Thanks.
StaceyI think i found the problem.. just no solution. When I look at the history
of the job that executed the report. It says that it Executed as user: NT
AUTHORITY\NETWORK SERVICE. instead of executing as the user that I want.
Any idea how to change this?
"Stacey" <StaceyL@.community.nospam> wrote in message
news:OoEkrGeJGHA.208@.tk2msftngp13.phx.gbl...
> We had to change the administrator password recently. So I took the
> opportunity and created a sql user (yes.. it is domain admin) and moved
> the sql and reporting services to run under this user instead of
> administrator. Since this time, my report server doesn't send out the
> reports via email. I am not sure where to look to even determine what
> exactly the problem is. Thanks.
>
> Stacey
>|||If a domain admin sets up the subscription does it work?|||Hi Stace,
Welcome to use MSDN Managed Newsgroup!
What is the current startup account of Reporting Services? From the error
message, it seems that the startup account of Reporting Services is still
Network Services.
To change the startup account of RS, you can open the Services Control
Panel, find the ReportServer windows services and change its logon account.
You mentioned that you have created a new windows account for RS. After
that, have you configured the RS? Please let me know your configuration
steps.
If anything is unclear, please feel free to let me know.
Thanks & Regards,
Justin Shen
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--
| From: "Stacey" <StaceyL@.community.nospam>
| References: <OoEkrGeJGHA.208@.tk2msftngp13.phx.gbl>
| Subject: Re: report server no longer sends emails
| Date: Mon, 30 Jan 2006 16:35:04 -0500
| Lines: 20
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Response
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <uDiQjReJGHA.1388@.TK2MSFTNGP11.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 208.49.251.54
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67827
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I think i found the problem.. just no solution. When I look at the
history
| of the job that executed the report. It says that it Executed as user: NT
| AUTHORITY\NETWORK SERVICE. instead of executing as the user that I want.
| Any idea how to change this?
| "Stacey" <StaceyL@.community.nospam> wrote in message
| news:OoEkrGeJGHA.208@.tk2msftngp13.phx.gbl...
| > We had to change the administrator password recently. So I took the
| > opportunity and created a sql user (yes.. it is domain admin) and moved
| > the sql and reporting services to run under this user instead of
| > administrator. Since this time, my report server doesn't send out the
| > reports via email. I am not sure where to look to even determine what
| > exactly the problem is. Thanks.
| >
| >
| >
| > Stacey
| >
| >
|
|
||||I found the solution. There was a new user created in Active Directory that
report services and sql were running under. The report would not email.
And the jobs did not execute as that user. When I added that user explicitly
to SQL Logins, then everything started working fine. I did not think that
was necessary - but I guess it is.
"Justin Shen[MSFT]" <v-yishen@.online.microsoft.com> wrote in message
news:62vwFbiJGHA.3680@.TK2MSFTNGXA02.phx.gbl...
> Hi Stace,
> Welcome to use MSDN Managed Newsgroup!
> What is the current startup account of Reporting Services? From the error
> message, it seems that the startup account of Reporting Services is still
> Network Services.
> To change the startup account of RS, you can open the Services Control
> Panel, find the ReportServer windows services and change its logon
> account.
> You mentioned that you have created a new windows account for RS. After
> that, have you configured the RS? Please let me know your configuration
> steps.
> If anything is unclear, please feel free to let me know.
> Thanks & Regards,
> Justin Shen
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> --
> | From: "Stacey" <StaceyL@.community.nospam>
> | References: <OoEkrGeJGHA.208@.tk2msftngp13.phx.gbl>
> | Subject: Re: report server no longer sends emails
> | Date: Mon, 30 Jan 2006 16:35:04 -0500
> | Lines: 20
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-RFC2646: Format=Flowed; Response
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | Message-ID: <uDiQjReJGHA.1388@.TK2MSFTNGP11.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 208.49.251.54
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:67827
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I think i found the problem.. just no solution. When I look at the
> history
> | of the job that executed the report. It says that it Executed as user:
> NT
> | AUTHORITY\NETWORK SERVICE. instead of executing as the user that I want.
> | Any idea how to change this?
> | "Stacey" <StaceyL@.community.nospam> wrote in message
> | news:OoEkrGeJGHA.208@.tk2msftngp13.phx.gbl...
> | > We had to change the administrator password recently. So I took the
> | > opportunity and created a sql user (yes.. it is domain admin) and
> moved
> | > the sql and reporting services to run under this user instead of
> | > administrator. Since this time, my report server doesn't send out the
> | > reports via email. I am not sure where to look to even determine what
> | > exactly the problem is. Thanks.
> | >
> | >
> | >
> | > Stacey
> | >
> | >
> |
> |
> |
>|||Hi Stacey,
I am glad that you found the solution. It is my pleasure to work with you.
Hope you get a good experience with Reporting Services. :)
Regards,
Justin Shen
Microsoft Online Partner Support
--
| From: "Stacey" <StaceyL@.community.nospam>
| References: <OoEkrGeJGHA.208@.tk2msftngp13.phx.gbl>
<uDiQjReJGHA.1388@.TK2MSFTNGP11.phx.gbl>
<62vwFbiJGHA.3680@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: report server no longer sends emails
| Date: Tue, 31 Jan 2006 09:55:28 -0500
| Lines: 103
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <#gy9TXnJGHA.3936@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 208.49.251.54
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67862
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I found the solution. There was a new user created in Active Directory
that
| report services and sql were running under. The report would not email.
| And the jobs did not execute as that user. When I added that user
explicitly
| to SQL Logins, then everything started working fine. I did not think
that
| was necessary - but I guess it is.
|
|
| "Justin Shen[MSFT]" <v-yishen@.online.microsoft.com> wrote in message
| news:62vwFbiJGHA.3680@.TK2MSFTNGXA02.phx.gbl...
| > Hi Stace,
| >
| > Welcome to use MSDN Managed Newsgroup!
| >
| > What is the current startup account of Reporting Services? From the
error
| > message, it seems that the startup account of Reporting Services is
still
| > Network Services.
| > To change the startup account of RS, you can open the Services Control
| > Panel, find the ReportServer windows services and change its logon
| > account.
| >
| > You mentioned that you have created a new windows account for RS. After
| > that, have you configured the RS? Please let me know your configuration
| > steps.
| >
| > If anything is unclear, please feel free to let me know.
| >
| > Thanks & Regards,
| > Justin Shen
| >
| > Microsoft Online Partner Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| > When responding to posts, please "Reply to Group" via your newsreader so
| > that others may learn and benefit from your issue.
| >
| > =====================================================| > Business-Critical Phone Support (BCPS) provides you with technical phone
| > support at no charge during critical LAN outages or "business down"
| > situations. This benefit is available 24 hours a day, 7 days a week to
all
| > Microsoft technology partners in the United States and Canada.
| >
| > This and other support options are available here:
| >
| > BCPS:
| >
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
| >
| > Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/
| >
| > If you are outside the United States, please visit our International
| > Support page:
| > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
| > =====================================================| >
| > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| >
| > --
| > | From: "Stacey" <StaceyL@.community.nospam>
| > | References: <OoEkrGeJGHA.208@.tk2msftngp13.phx.gbl>
| > | Subject: Re: report server no longer sends emails
| > | Date: Mon, 30 Jan 2006 16:35:04 -0500
| > | Lines: 20
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | X-RFC2646: Format=Flowed; Response
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | Message-ID: <uDiQjReJGHA.1388@.TK2MSFTNGP11.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: 208.49.251.54
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl
| > microsoft.public.sqlserver.reportingsvcs:67827
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | I think i found the problem.. just no solution. When I look at the
| > history
| > | of the job that executed the report. It says that it Executed as
user:
| > NT
| > | AUTHORITY\NETWORK SERVICE. instead of executing as the user that I
want.
| > | Any idea how to change this?
| > | "Stacey" <StaceyL@.community.nospam> wrote in message
| > | news:OoEkrGeJGHA.208@.tk2msftngp13.phx.gbl...
| > | > We had to change the administrator password recently. So I took the
| > | > opportunity and created a sql user (yes.. it is domain admin) and
| > moved
| > | > the sql and reporting services to run under this user instead of
| > | > administrator. Since this time, my report server doesn't send out
the
| > | > reports via email. I am not sure where to look to even determine
what
| > | > exactly the problem is. Thanks.
| > | >
| > | >
| > | >
| > | > Stacey
| > | >
| > | >
| > |
| > |
| > |
| >
|
|
|