Can't setup SQL AgentMail

Dear all:
I've setup Outlook 2003 for my MAPI client, and setup service that not run
the local machine. And my SQL Mail can work. However, the profile in SQL
AgentMail still can't setup. How should I setup the SQL Agent Mail?Sorry that forgot post my environment:
Win2003 + AD
SQL 2000 + sp3a
Exchange 2003
Outlook 2003
Thank you very much for your reply!
"David" <david@.ms59.ideanote.org.NOSPAM> glsD
:uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...

quote:

---

> Dear all:
> I've setup Outlook 2003 for my MAPI client, and setup service that not run
> the local machine. And my SQL Mail can work. However, the profile in SQL
> AgentMail still can't setup. How should I setup the SQL Agent Mail?
>

---

|||1.And make sure that SQL service account have permission to access the
Outlook profile's user account.
Try to use the Outlook user login to your SQL server, then create the
Outlook profile.
Then check again that SQL agentmail profile can setup or not.
2.Verify the MAPI32.dll version, you can see this to check your version.
http://support.microsoft.com/defaul...kb;en-us;263556
Microsoft MVP
Alvin Chen for Windows Server
MCP,MCSE,MCSA,MCSA+Messenger,RHCE,CCNA,T
CSE.
"David" <david@.ms59.ideanote.org.NOSPAM> glsD
:ORmhc4B5DHA.1936@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Sorry that forgot post my environment:
> Win2003 + AD
> SQL 2000 + sp3a
> Exchange 2003
> Outlook 2003
> Thank you very much for your reply!
> "David" <david@.ms59.ideanote.org.NOSPAM> glsD
> :uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
run[QUOTE]
>

---

Can't setup SQL AgentMail

Dear all:
I've setup Outlook 2003 for my MAPI client, and setup service that not run
the local machine. And my SQL Mail can work. However, the profile in SQL
AgentMail still can't setup. How should I setup the SQL Agent Mail?Sorry that forgot post my environment:
Win2003 + AD
SQL 2000 + sp3a
Exchange 2003
Outlook 2003
Thank you very much for your reply!
"David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
:uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> Dear all:
> I've setup Outlook 2003 for my MAPI client, and setup service that not run
> the local machine. And my SQL Mail can work. However, the profile in SQL
> AgentMail still can't setup. How should I setup the SQL Agent Mail?
>|||1.And make sure that SQL service account have permission to access the
Outlook profile's user account.
Try to use the Outlook user login to your SQL server, then create the
Outlook profile.
Then check again that SQL agentmail profile can setup or not.
2.Verify the MAPI32.dll version, you can see this to check your version.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
Microsoft MVP
Alvin Chen for Windows Server
MCP,MCSE,MCSA,MCSA+Messenger,RHCE,CCNA,TCSE.
"David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
:ORmhc4B5DHA.1936@.TK2MSFTNGP12.phx.gbl...
> Sorry that forgot post my environment:
> Win2003 + AD
> SQL 2000 + sp3a
> Exchange 2003
> Outlook 2003
> Thank you very much for your reply!
> "David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
> :uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> > Dear all:
> >
> > I've setup Outlook 2003 for my MAPI client, and setup service that not
run
> > the local machine. And my SQL Mail can work. However, the profile in SQL
> > AgentMail still can't setup. How should I setup the SQL Agent Mail?
> >
> >
>

Can't send out mail if Outlook not open ?

Dear experts,
In my server, I have created a scheduled task that use SENDMAIL to send some
reports to my boss email ... but I find that if the mail cannot send out if
the OUTLOOK in the server was closed ... everytime I need to open the OUTLOOK
and press SEND/RECEIVE to send those mail out. (It will be a big trouble if
we have a few days holiday) ...
So can anyone know why the SENDMAIL function cannot operate when the OUTLOOK
is closed ? if so, can someone tell me how to solve this problem (except
ALWAYS OPEN THE OUTLOOK), thanks very much for all of your concern & helping
!!!
Some versions of Outlook require keeping Outlook open for
SQL Mail to work correctly. You may also want to refer to
the following articles:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
One way around this is to not use Outlook, MAPI for mail and
just use smtp. You can download an extended stored procedure
to send mail using SMTP. You can find the download and more
information at:
http://www.sqldev.net/xp/xpsmtp.htm
-Sue
On Sun, 3 Oct 2004 19:31:09 -0700, "Devil Garfield"
<DevilGarfield@.discussions.microsoft.com> wrote:

>Dear experts,
>In my server, I have created a scheduled task that use SENDMAIL to send some
>reports to my boss email ... but I find that if the mail cannot send out if
>the OUTLOOK in the server was closed ... everytime I need to open the OUTLOOK
>and press SEND/RECEIVE to send those mail out. (It will be a big trouble if
>we have a few days holiday) ...
>So can anyone know why the SENDMAIL function cannot operate when the OUTLOOK
>is closed ? if so, can someone tell me how to solve this problem (except
>ALWAYS OPEN THE OUTLOOK), thanks very much for all of your concern & helping
>!!!

Can't send out mail if Outlook not open ?

Dear experts,
In my server, I have created a scheduled task that use SENDMAIL to send some
reports to my boss email ... but I find that if the mail cannot send out if
the OUTLOOK in the server was closed ... everytime I need to open the OUTLOOK
and press SEND/RECEIVE to send those mail out. (It will be a big trouble if
we have a few days holiday) ...
So can anyone know why the SENDMAIL function cannot operate when the OUTLOOK
is closed ' if so, can someone tell me how to solve this problem (except
ALWAYS OPEN THE OUTLOOK), thanks very much for all of your concern & helping
!!!Some versions of Outlook require keeping Outlook open for
SQL Mail to work correctly. You may also want to refer to
the following articles:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
One way around this is to not use Outlook, MAPI for mail and
just use smtp. You can download an extended stored procedure
to send mail using SMTP. You can find the download and more
information at:
http://www.sqldev.net/xp/xpsmtp.htm
-Sue
On Sun, 3 Oct 2004 19:31:09 -0700, "Devil Garfield"
<DevilGarfield@.discussions.microsoft.com> wrote:
>Dear experts,
>In my server, I have created a scheduled task that use SENDMAIL to send some
>reports to my boss email ... but I find that if the mail cannot send out if
>the OUTLOOK in the server was closed ... everytime I need to open the OUTLOOK
>and press SEND/RECEIVE to send those mail out. (It will be a big trouble if
>we have a few days holiday) ...
>So can anyone know why the SENDMAIL function cannot operate when the OUTLOOK
>is closed ' if so, can someone tell me how to solve this problem (except
>ALWAYS OPEN THE OUTLOOK), thanks very much for all of your concern & helping
>!!!

Can't send operator email in SQL Sever 2005

I have set up Database Mail
I have sent a test message successfully
I have set up a Operator
When I create a test job to send a test message to the operator the
TSQL is
EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris Auer',@.body=N'wewqe'
When I run that query I get
Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 94
No global profile is configured. Specify a profile name in the
@.profile_name parameter.
In the job log I have this
Executing the query "EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris
Auer',@.body=N'wewqe'
" failed with the following error: "No global profile is configured.
Specify a profile name in the @.profile_name parameter.". Possible
failure reasons: Problems with the query, "ResultSet" property not set
correctly, parameters not set correctly, or connection not established
correctly.
What is a global profile?
I have already made the registry change to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\SQLServerAgent
I made DatabaseMailProfile my default profile name in Database Mail and
I made UseDatabaseMail = 1
Any ideas, thanks. This is driving me up a wall.'
Chris AuerLooks like you only need to specify a profile name or define a default
profile.
Right-click Database Mail, select Configure Database Mail and select Manage
profile security. Here you have the choice to configure your profiles as
public, private and/or default.
If you do not have a default profile configured you will need to specify the
@.profile_name parameter. This is the same name under 'Profile name' on the
Database Mail Configuration Wizard.
Also, take a look at 'Database Mail [SQL Server], security on BOL.
Ben Nevarez, MCDBA, OCP
"Chris Auer" <chris.auer@.gmail.com> wrote in message
news:1132958108.969902.311470@.g44g2000cwa.googlegroups.com...
>I have set up Database Mail
> I have sent a test message successfully
> I have set up a Operator
> When I create a test job to send a test message to the operator the
> TSQL is
> EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris Auer',@.body=N'wewqe'
> When I run that query I get
> Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 94
> No global profile is configured. Specify a profile name in the
> @.profile_name parameter.
> In the job log I have this
> Executing the query "EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris
> Auer',@.body=N'wewqe'
> " failed with the following error: "No global profile is configured.
> Specify a profile name in the @.profile_name parameter.". Possible
> failure reasons: Problems with the query, "ResultSet" property not set
> correctly, parameters not set correctly, or connection not established
> correctly.
>
> What is a global profile?
> I have already made the registry change to
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\MSSQL.1\SQLServerAgent
> I made DatabaseMailProfile my default profile name in Database Mail and
> I made UseDatabaseMail = 1
> Any ideas, thanks. This is driving me up a wall.'
> Chris Auer
>|||I also have the exact same problem, and is driving me nuts too. I have
created a default, private profile for the agent to use, however it still
fails.
I get the same error message. I can send database mail, but the agent fails.
I've tried public default profiles and they fail too. The agent account is
setup in msdb in the DatabaseMailUser role.
The interseting thing is that the 'Test' button is dimmed on the SQL Agent,
Alert System, Mail Session page even though the correct profile is selected!
Please, any help will be greatly appreciated.
Jim
"Ben Nevarez" wrote:
> Looks like you only need to specify a profile name or define a default
> profile.
> Right-click Database Mail, select Configure Database Mail and select Manage
> profile security. Here you have the choice to configure your profiles as
> public, private and/or default.
> If you do not have a default profile configured you will need to specify the
> @.profile_name parameter. This is the same name under 'Profile name' on the
> Database Mail Configuration Wizard.
> Also, take a look at 'Database Mail [SQL Server], security on BOL.
> Ben Nevarez, MCDBA, OCP
>
> "Chris Auer" <chris.auer@.gmail.com> wrote in message
> news:1132958108.969902.311470@.g44g2000cwa.googlegroups.com...
> >I have set up Database Mail
> > I have sent a test message successfully
> > I have set up a Operator
> >
> > When I create a test job to send a test message to the operator the
> > TSQL is
> >
> > EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris Auer',@.body=N'wewqe'
> >
> > When I run that query I get
> >
> > Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 94
> > No global profile is configured. Specify a profile name in the
> > @.profile_name parameter.
> >
> > In the job log I have this
> >
> > Executing the query "EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris
> > Auer',@.body=N'wewqe'
> > " failed with the following error: "No global profile is configured.
> > Specify a profile name in the @.profile_name parameter.". Possible
> > failure reasons: Problems with the query, "ResultSet" property not set
> > correctly, parameters not set correctly, or connection not established
> > correctly.
> >
> >
> > What is a global profile?
> >
> > I have already made the registry change to
> > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> > Server\MSSQL.1\SQLServerAgent
> > I made DatabaseMailProfile my default profile name in Database Mail and
> > I made UseDatabaseMail = 1
> >
> > Any ideas, thanks. This is driving me up a wall.'
> >
> > Chris Auer
> >
>
>sql

Can't Send mail using MultiServer Admin

Hi,

I have a Master server which I want to use to handle jobs for our Production Servers. the master server has Outlook installed but the Target servers do not. I need to find a way to get the job to send a mail confirming whether the job has succeeded or failed but without having a mail client installed on any of the target servers. Currently the actual backups do run but the send mail section fails with the following error.

xp_sendmail: Procedure expects parameter @.user, which was not supplied. [SQLSTATE 42000] (Error 17985). The step failed.

I can't see any parameter @.User on BOL, it may be that using sendmail is not the best way foward here

Any ideas anyone?

Hi, I had this problem when I migrated my server to new hardware. I had not yet set up the Outlook account which SQL Server uses to send the mail on the new hardware. You have to login to your box with the same account that you use for the SQL Server startup service and create an outlook profile on that account before you can send the mail using xp_sendmail. Hope this helps!|||

Hi Jason,

Thanks for the response, we don't want to install an Outlook client on the target servers which was cauing the problem, I managed to resolve the issue by using smtp instead

Regards

Lisa

|||

how do you set up the smtp on your target server? I'd like to do the same but have not any idea, I am a newbie in both SQL and network. Thanks.

|||Try using http://www.sqldev.net/xp/sp_smtp_sendmail.htm

Can't Send mail using MultiServer Admin

Hi,

I have a Master server which I want to use to handle jobs for our Production Servers. the master server has Outlook installed but the Target servers do not. I need to find a way to get the job to send a mail confirming whether the job has succeeded or failed but without having a mail client installed on any of the target servers. Currently the actual backups do run but the send mail section fails with the following error.

xp_sendmail: Procedure expects parameter @.user, which was not supplied. [SQLSTATE 42000] (Error 17985). The step failed.

I can't see any parameter @.User on BOL, it may be that using sendmail is not the best way foward here

Any ideas anyone?

Hi, I had this problem when I migrated my server to new hardware. I had not yet set up the Outlook account which SQL Server uses to send the mail on the new hardware. You have to login to your box with the same account that you use for the SQL Server startup service and create an outlook profile on that account before you can send the mail using xp_sendmail. Hope this helps!|||

Hi Jason,

Thanks for the response, we don't want to install an Outlook client on the target servers which was cauing the problem, I managed to resolve the issue by using smtp instead

Regards

Lisa

|||

how do you set up the smtp on your target server? I'd like to do the same but have not any idea, I am a newbie in both SQL and network. Thanks.

|||Try using http://www.sqldev.net/xp/sp_smtp_sendmail.htm

Can't Send mail using MultiServer Admin

Hi,

I have a Master server which I want to use to handle jobs for our Production Servers. the master server has Outlook installed but the Target servers do not. I need to find a way to get the job to send a mail confirming whether the job has succeeded or failed but without having a mail client installed on any of the target servers. Currently the actual backups do run but the send mail section fails with the following error.

xp_sendmail: Procedure expects parameter @.user, which was not supplied. [SQLSTATE 42000] (Error 17985). The step failed.

I can't see any parameter @.User on BOL, it may be that using sendmail is not the best way foward here

Any ideas anyone?

Hi, I had this problem when I migrated my server to new hardware. I had not yet set up the Outlook account which SQL Server uses to send the mail on the new hardware. You have to login to your box with the same account that you use for the SQL Server startup service and create an outlook profile on that account before you can send the mail using xp_sendmail. Hope this helps!|||

Hi Jason,

Thanks for the response, we don't want to install an Outlook client on the target servers which was cauing the problem, I managed to resolve the issue by using smtp instead

Regards

Lisa

|||

how do you set up the smtp on your target server? I'd like to do the same but have not any idea, I am a newbie in both SQL and network. Thanks.

|||Try using http://www.sqldev.net/xp/sp_smtp_sendmail.htm

Can't send Attachement (Report Delivering)

Good morning
Iâ'm trying to enable the scheduled report delivering. It is working fine
without attachment (except the mail is in the SMTP-queue, but this is another
issueâ?¦ï' ). But Iâ'm not able to send a mail including a rendered report.
Here is my environment:
- Windows 2003 Advanced Server
- Reporting Services Service Pack 1
- SQL Server Service Pack 3a
- NT 4 Domain (very old, I knowâ?¦)
- SQL Reporting Service running using a Domain Account (having local
Admin on Server)
- SQL Service & Agent running the same Domain Account
- Reporting Server is configured to relay the Mails to an other SMTP
Host within our network
Any ideas?
Thanks in advanceâ?¦
DominicStill not working...help...
I can't find any error messages. Only one looks a bit confusing:
ReportingServicesService!library!8d4!8/12/2004-14:17:02:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
The rest of the log is below...
w3wp!webserver!b8c!8/12/2004-14:17:13:: i INFO: Reporting Web Server started
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing ConnectionType to
'0' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing IsEventService to
'True' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing PollingInterval
to '10' second(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing MemoryLimit to
'60' percent as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing MaxQueueThreads
to '0' thread(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing MaxScheduleWait
to '5' second(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing InstanceName to
'MSSQLSERVER' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration
file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!resourceutilities!b8c!8/12/2004-14:17:13:: i INFO: Running on 2
physical processors, 4 logical processors
w3wp!resourceutilities!b8c!8/12/2004-14:17:13:: i INFO: Reporting Services
starting SKU: Developer
w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Database Cleanup (Web
Service) timer enabled: Cycle: 600 seconds
w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Running Requests Scavenger
timer enabled: Cycle: 60 seconds
w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Running Requests DB timer
enabled: Cycle: 60 seconds
w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Memory stats update timer
enabled: Cycle: 60 seconds
w3wp!library!fa8!08/12/2004-14:17:17:: i INFO: Call to GetSystemPermissions
w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Exporting public key
w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Performing sku validation
w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Importing existing encryption
key
w3wp!library!b8c!08/12/2004-14:17:21:: i INFO: Call to GetSystemPermissions
w3wp!library!b8c!8/12/2004-14:27:13:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
"Dominic" wrote:
> Good morning
> Iâ'm trying to enable the scheduled report delivering. It is working fine
> without attachment (except the mail is in the SMTP-queue, but this is another
> issueâ?¦ï' ). But Iâ'm not able to send a mail including a rendered report.
> Here is my environment:
> - Windows 2003 Advanced Server
> - Reporting Services Service Pack 1
> - SQL Server Service Pack 3a
> - NT 4 Domain (very old, I knowâ?¦)
> - SQL Reporting Service running using a Domain Account (having local
> Admin on Server)
> - SQL Service & Agent running the same Domain Account
> - Reporting Server is configured to relay the Mails to an other SMTP
> Host within our network
> Any ideas?
> Thanks in advanceâ?¦
> Dominic|||Can you look in the reportserverservice<date>.log file instead. This is the
log file that should contain the error information. Is the status of the
subscription showing any error?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dominic" <Dominic@.discussions.microsoft.com> wrote in message
news:B9C818D3-8753-4E51-9702-BD1654BCA959@.microsoft.com...
> Still not working...help...
> I can't find any error messages. Only one looks a bit confusing:
> ReportingServicesService!library!8d4!8/12/2004-14:17:02:: i INFO:
> Initializing WebServiceUseFileShareStorage to default value of 'False'
> because it was not specified in Configuration file.
> The rest of the log is below...
> w3wp!webserver!b8c!8/12/2004-14:17:13:: i INFO: Reporting Web Server
started
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing ConnectionType
to
> '0' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> IsSchedulingService to 'True' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> IsNotificationService to 'True' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing IsEventService
to
> 'True' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing PollingInterval
> to '10' second(s) as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing MemoryLimit to
> '60' percent as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing RecycleTime to
> '720' minute(s) as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> MaximumMemoryLimit to '80' percent as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration
file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing MaxQueueThreads
> to '0' thread(s) as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing MaxScheduleWait
> to '5' second(s) as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> DatabaseQueryTimeout to '120' second(s) as specified in Configuration
file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing InstanceName to
> 'MSSQLSERVER' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> ProcessRecycleOptions to '0' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration
> file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> RunningRequestsDbCycle to '60' second(s) as specified in Configuration
file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> RunningRequestsAge to '30' second(s) as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> SecureConnectionLevel to '0' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
DisplayErrorLink
> to 'True' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> WebServiceUseFileShareStorage to default value of 'False' because it was
not
> specified in Configuration file.
> w3wp!resourceutilities!b8c!8/12/2004-14:17:13:: i INFO: Running on 2
> physical processors, 4 logical processors
> w3wp!resourceutilities!b8c!8/12/2004-14:17:13:: i INFO: Reporting Services
> starting SKU: Developer
> w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Database Cleanup (Web
> Service) timer enabled: Cycle: 600 seconds
> w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Running Requests
Scavenger
> timer enabled: Cycle: 60 seconds
> w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Running Requests DB
timer
> enabled: Cycle: 60 seconds
> w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Memory stats update
timer
> enabled: Cycle: 60 seconds
> w3wp!library!fa8!08/12/2004-14:17:17:: i INFO: Call to
GetSystemPermissions
> w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Initializing crypto as user:
> NT AUTHORITY\NETWORK SERVICE
> w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Exporting public key
> w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Performing sku validation
> w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Importing existing
encryption
> key
> w3wp!library!b8c!08/12/2004-14:17:21:: i INFO: Call to
GetSystemPermissions
> w3wp!library!b8c!8/12/2004-14:27:13:: i INFO: Cleaned 0 batch records, 0
> policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running
jobs
> "Dominic" wrote:
> > Good morning
> >
> > I'm trying to enable the scheduled report delivering. It is working fine
> > without attachment (except the mail is in the SMTP-queue, but this is
another
> > issue.? ). But I'm not able to send a mail including a rendered report.
> >
> > Here is my environment:
> > - Windows 2003 Advanced Server
> > - Reporting Services Service Pack 1
> > - SQL Server Service Pack 3a
> > - NT 4 Domain (very old, I know.)
> > - SQL Reporting Service running using a Domain Account (having local
> > Admin on Server)
> > - SQL Service & Agent running the same Domain Account
> > - Reporting Server is configured to relay the Mails to an other SMTP
> > Host within our network
> >
> > Any ideas?
> >
> > Thanks in advance.
> > Dominic|||Hi Daniel
Ok...hmm...in the service log are AUTZ errors...but my ReportingServer
Service is running with a Domain-Account having local admin rights on the
box...
here is the full log:
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>W. Europe Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__08_13_2004_10_55_11.log</Path>
<SystemName>DYLAN</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
ReportingServicesService!resourceutilities!f3c!8/13/2004-10:55:11:: i INFO:
Running on 2 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!f3c!8/13/2004-10:55:11:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 54288 seconds
ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO: Memory
stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!cf0!8/13/2004-10:55:11:: i INFO:
Initializing crypto as user: LEU.HANDEL.1\emisadmin
ReportingServicesService!crypto!cf0!8/13/2004-10:55:11:: i INFO: Exporting
public key
ReportingServicesService!crypto!cf0!8/13/2004-10:55:14:: i INFO: Performing
sku validation
ReportingServicesService!crypto!cf0!8/13/2004-10:55:14:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!cf0!08/13/2004-10:55:14:: EventPolling
polling service started
ReportingServicesService!dbpolling!cf0!08/13/2004-10:55:14::
NotificationPolling polling service started
ReportingServicesService!dbpolling!cf0!08/13/2004-10:55:14:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!d68!8/13/2004-10:55:14:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!4e4!8/13/2004-10:55:14::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!47c!8/13/2004-10:55:14:: Polling started
ReportingServicesService!dbpolling!47c!8/13/2004-10:56:04:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f3c!8/13/2004-10:56:04:: EventPolling
processing item 226e46a7-15d7-47c9-bad4-311a2094ff2b
ReportingServicesService!library!f3c!8/13/2004-10:56:04:: Schedule
48d32fa7-3755-47d4-8fa6-cbe1ab861556 executed at 8/13/2004 10:56:04 AM.
ReportingServicesService!schedule!f3c!8/13/2004-10:56:04:: Creating Time
based subscription notification for subscription:
5e89b59a-13bd-404e-9551-f1fae831ecc0
ReportingServicesService!library!f3c!8/13/2004-10:56:04:: Schedule
48d32fa7-3755-47d4-8fa6-cbe1ab861556 execution completed at 8/13/2004
10:56:04 AM.
ReportingServicesService!dbpolling!f3c!8/13/2004-10:56:04:: EventPolling
finished processing item 226e46a7-15d7-47c9-bad4-311a2094ff2b
ReportingServicesService!dbpolling!47c!8/13/2004-10:56:04::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f3c!8/13/2004-10:56:04::
NotificationPolling processing item 81728282-f0dd-4318-bc40-f2314d3b4d11
ReportingServicesService!library!f3c!08/13/2004-10:56:04:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!f3c!08/13/2004-10:56:04:: i INFO: Call to
RenderFirst( '/Reports/Meta Reports/CountryTable' )
ReportingServicesService!library!f3c!08/13/2004-10:56:04:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!f3c!08/13/2004-10:56:04:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!f3c!08/13/2004-10:56:04:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
The Report Server has encountered a configuration error; more details in the
log files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!f3c!08/13/2004-10:56:04:: Notification
81728282-f0dd-4318-bc40-f2314d3b4d11 completed. Success: False, Status:
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files, DeliveryExtension: Report Server Email,
Report: CountryTable, Attempt 0
ReportingServicesService!dbpolling!f3c!08/13/2004-10:56:04::
NotificationPolling finished processing item
81728282-f0dd-4318-bc40-f2314d3b4d11
Thanks a lot !
Cheers Dominic
"Daniel Reib [MSFT]" wrote:
> Can you look in the reportserverservice<date>.log file instead. This is the
> log file that should contain the error information. Is the status of the
> subscription showing any error?
> --
> -Daniel|||Not sure that this will help, but the error you are getting is:
'The specified domain either does not exist or could not be contacted'
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dominic" <Dominic@.discussions.microsoft.com> wrote in message
news:D2EC6713-D44D-4154-BD63-1B046272AD44@.microsoft.com...
> Hi Daniel
> Ok...hmm...in the service log are AUTZ errors...but my ReportingServer
> Service is running with a Domain-Account having local admin rights on the
> box...
> here is the full log:
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>W. Europe Daylight Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__08_13_2004_10_55_11.log</Path>
> <SystemName>DYLAN</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing ConnectionType to '0' as specified in Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing IsSchedulingService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing IsNotificationService to 'True' as specified in
Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing PollingInterval to '10' second(s) as specified in
Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing MemoryLimit to '60' percent as specified in Configuration
file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing RecycleTime to '720' minute(s) as specified in Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing MaximumMemoryLimit to '80' percent as specified in
Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing MaxQueueThreads to '0' thread(s) as specified in
Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing MaxScheduleWait to '5' second(s) as specified in
Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing ProcessRecycleOptions to '0' as specified in Configuration
file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing RunningRequestsScavengerCycle to '60' second(s) as specified
in
> Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing RunningRequestsAge to '30' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing SecureConnectionLevel to '0' as specified in Configuration
file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing DisplayErrorLink to 'True' as specified in Configuration
file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing WebServiceUseFileShareStorage to default value of 'False'
> because it was not specified in Configuration file.
> ReportingServicesService!resourceutilities!f3c!8/13/2004-10:55:11:: i
INFO:
> Running on 2 physical processors, 4 logical processors
> ReportingServicesService!resourceutilities!f3c!8/13/2004-10:55:11:: i
INFO:
> Reporting Services starting SKU: Developer
> ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
> Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
> Running Requests Scavenger timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
> Running Requests DB timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 54288 seconds
> ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
Memory
> stats update timer enabled: Cycle: 60 seconds
> ReportingServicesService!crypto!cf0!8/13/2004-10:55:11:: i INFO:
> Initializing crypto as user: LEU.HANDEL.1\emisadmin
> ReportingServicesService!crypto!cf0!8/13/2004-10:55:11:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!cf0!8/13/2004-10:55:14:: i INFO:
Performing
> sku validation
> ReportingServicesService!crypto!cf0!8/13/2004-10:55:14:: i INFO: Importing
> existing encryption key
> ReportingServicesService!dbpolling!cf0!08/13/2004-10:55:14:: EventPolling
> polling service started
> ReportingServicesService!dbpolling!cf0!08/13/2004-10:55:14::
> NotificationPolling polling service started
> ReportingServicesService!dbpolling!cf0!08/13/2004-10:55:14::
SchedulePolling
> polling service started
> ReportingServicesService!dbpolling!d68!8/13/2004-10:55:14:: EventPolling
> heartbeat thread started.
> ReportingServicesService!dbpolling!4e4!8/13/2004-10:55:14::
> NotificationPolling heartbeat thread started.
> ReportingServicesService!dbpolling!47c!8/13/2004-10:55:14:: Polling
started
> ReportingServicesService!dbpolling!47c!8/13/2004-10:56:04:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!f3c!8/13/2004-10:56:04:: EventPolling
> processing item 226e46a7-15d7-47c9-bad4-311a2094ff2b
> ReportingServicesService!library!f3c!8/13/2004-10:56:04:: Schedule
> 48d32fa7-3755-47d4-8fa6-cbe1ab861556 executed at 8/13/2004 10:56:04 AM.
> ReportingServicesService!schedule!f3c!8/13/2004-10:56:04:: Creating Time
> based subscription notification for subscription:
> 5e89b59a-13bd-404e-9551-f1fae831ecc0
> ReportingServicesService!library!f3c!8/13/2004-10:56:04:: Schedule
> 48d32fa7-3755-47d4-8fa6-cbe1ab861556 execution completed at 8/13/2004
> 10:56:04 AM.
> ReportingServicesService!dbpolling!f3c!8/13/2004-10:56:04:: EventPolling
> finished processing item 226e46a7-15d7-47c9-bad4-311a2094ff2b
> ReportingServicesService!dbpolling!47c!8/13/2004-10:56:04::
> NotificationPolling processing 1 more items. 1 Total items in internal
queue.
> ReportingServicesService!dbpolling!f3c!8/13/2004-10:56:04::
> NotificationPolling processing item 81728282-f0dd-4318-bc40-f2314d3b4d11
> ReportingServicesService!library!f3c!08/13/2004-10:56:04:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!f3c!08/13/2004-10:56:04:: i INFO: Call to
> RenderFirst( '/Reports/Meta Reports/CountryTable' )
> ReportingServicesService!library!f3c!08/13/2004-10:56:04:: e ERROR:
Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> ReportingServicesService!library!f3c!08/13/2004-10:56:04:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
system
> properties.
> ReportingServicesService!emailextension!f3c!08/13/2004-10:56:04:: Error
> sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> The Report Server has encountered a configuration error; more details in
the
> log files -->
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> at
>
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntP
tr userSid)
> at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> userName)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(Strin
g
> userName, IntPtr userToken)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(S
tring
> userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
>
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionF
romCatalog(CatalogItemContext
> reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32&
> executionOption, String& savedParametersXml, ReportSnapshot&
> compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> historyDate)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean forRendering, NameValueCollection
values,
> DatasourceCredentialsCollection credentials)
> at
>
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(Catalog
ItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
>
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
> at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> at
>
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> -- End of inner exception stack trace --
> at
>
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> at
>
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RS
Service
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMes
sageBody(IMessage message, Notification notification, SubscriptionData data)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessag
e(Notification notification)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
> ReportingServicesService!notification!f3c!08/13/2004-10:56:04::
Notification
> 81728282-f0dd-4318-bc40-f2314d3b4d11 completed. Success: False, Status:
> Failure sending mail: The Report Server has encountered a configuration
> error; more details in the log files, DeliveryExtension: Report Server
Email,
> Report: CountryTable, Attempt 0
> ReportingServicesService!dbpolling!f3c!08/13/2004-10:56:04::
> NotificationPolling finished processing item
> 81728282-f0dd-4318-bc40-f2314d3b4d11
> Thanks a lot !
> Cheers Dominic
> "Daniel Reib [MSFT]" wrote:
> > Can you look in the reportserverservice<date>.log file instead. This is
the
> > log file that should contain the error information. Is the status of
the
> > subscription showing any error?
> >
> > --
> > -Daniel|||Did you ever get this resolved? I'm have the same type
issue.
Thanks, Ed
>--Original Message--
>Not sure that this will help, but the error you are
getting is:
>'The specified domain either does not exist or could not
be contacted'
>
>--
>-Daniel
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>"Dominic" <Dominic@.discussions.microsoft.com> wrote in
message
>news:D2EC6713-D44D-4154-BD63-1B046272AD44@.microsoft.com...
>> Hi Daniel
>> Ok...hmm...in the service log are AUTZ errors...but my
ReportingServer
>> Service is running with a Domain-Account having local
admin rights on the
>> box...
>> here is the full log:
>> <Header>
>> <Product>Microsoft SQL Server Reporting Services
Version
>> 8.00.878.00</Product>
>> <Locale>en-US</Locale>
>> <TimeZone>W. Europe Daylight Time</TimeZone>
>> <Path>C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__08_13_2004_10_55_11.
log</Path>
>> <SystemName>DYLAN</SystemName>
>> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
>> <OSVersion>5.2.3790.0</OSVersion>
>> </Header>
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing ConnectionType to '0' as specified in
Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing IsSchedulingService to 'True' as
specified in Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing IsNotificationService to 'True' as
specified in
>Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing IsEventService to 'True' as specified in
Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing PollingInterval to '10' second(s) as
specified in
>Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing MemoryLimit to '60' percent as specified
in Configuration
>file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing RecycleTime to '720' minute(s) as
specified in Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing MaximumMemoryLimit to '80' percent as
specified in
>Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing MaxAppDomainUnloadTime to '30' minute(s)
as specified in
>> Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing MaxQueueThreads to '0' thread(s) as
specified in
>Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing MaxActiveReqForOneUser to '20' requests(s)
as specified in
>> Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing MaxScheduleWait to '5' second(s) as
specified in
>Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing DatabaseQueryTimeout to '120' second(s) as
specified in
>> Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing InstanceName to 'MSSQLSERVER' as
specified in Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing ProcessRecycleOptions to '0' as specified
in Configuration
>file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing RunningRequestsScavengerCycle to '60'
second(s) as specified
>in
>> Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing RunningRequestsDbCycle to '60' second(s)
as specified in
>> Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing RunningRequestsAge to '30' second(s) as
specified in
>> Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing CleanupCycleMinutes to '10' minute(s) as
specified in
>> Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing SecureConnectionLevel to '0' as specified
in Configuration
>file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing DisplayErrorLink to 'True' as specified
in Configuration
>file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing WebServiceUseFileShareStorage to default
value of 'False'
>> because it was not specified in Configuration file.
>> ReportingServicesService!resourceutilities!f3c!
8/13/2004-10:55:11:: i
>INFO:
>> Running on 2 physical processors, 4 logical processors
>> ReportingServicesService!resourceutilities!f3c!
8/13/2004-10:55:11:: i
>INFO:
>> Reporting Services starting SKU: Developer
>> ReportingServicesService!runningjobs!f3c!8/13/2004-
10:55:11:: i INFO:
>> Database Cleanup (NT Service) timer enabled: Cycle: 600
seconds
>> ReportingServicesService!runningjobs!f3c!8/13/2004-
10:55:11:: i INFO:
>> Running Requests Scavenger timer enabled: Cycle: 60
seconds
>> ReportingServicesService!runningjobs!f3c!8/13/2004-
10:55:11:: i INFO:
>> Running Requests DB timer enabled: Cycle: 60 seconds
>> ReportingServicesService!runningjobs!f3c!8/13/2004-
10:55:11:: i INFO:
>> Execution Log Entry Expiration timer enabled: Cycle:
54288 seconds
>> ReportingServicesService!runningjobs!f3c!8/13/2004-
10:55:11:: i INFO:
>Memory
>> stats update timer enabled: Cycle: 60 seconds
>> ReportingServicesService!crypto!cf0!8/13/2004-
10:55:11:: i INFO:
>> Initializing crypto as user: LEU.HANDEL.1\emisadmin
>> ReportingServicesService!crypto!cf0!8/13/2004-
10:55:11:: i INFO: Exporting
>> public key
>> ReportingServicesService!crypto!cf0!8/13/2004-
10:55:14:: i INFO:
>Performing
>> sku validation
>> ReportingServicesService!crypto!cf0!8/13/2004-
10:55:14:: i INFO: Importing
>> existing encryption key
>> ReportingServicesService!dbpolling!cf0!08/13/2004-
10:55:14:: EventPolling
>> polling service started
>> ReportingServicesService!dbpolling!cf0!08/13/2004-
10:55:14::
>> NotificationPolling polling service started
>> ReportingServicesService!dbpolling!cf0!08/13/2004-
10:55:14::
>SchedulePolling
>> polling service started
>> ReportingServicesService!dbpolling!d68!8/13/2004-
10:55:14:: EventPolling
>> heartbeat thread started.
>> ReportingServicesService!dbpolling!4e4!8/13/2004-
10:55:14::
>> NotificationPolling heartbeat thread started.
>> ReportingServicesService!dbpolling!47c!8/13/2004-
10:55:14:: Polling
>started
>> ReportingServicesService!dbpolling!47c!8/13/2004-
10:56:04:: EventPolling
>> processing 1 more items. 1 Total items in internal
queue.
>> ReportingServicesService!dbpolling!f3c!8/13/2004-
10:56:04:: EventPolling
>> processing item 226e46a7-15d7-47c9-bad4-311a2094ff2b
>> ReportingServicesService!library!f3c!8/13/2004-
10:56:04:: Schedule
>> 48d32fa7-3755-47d4-8fa6-cbe1ab861556 executed at
8/13/2004 10:56:04 AM.
>> ReportingServicesService!schedule!f3c!8/13/2004-
10:56:04:: Creating Time
>> based subscription notification for subscription:
>> 5e89b59a-13bd-404e-9551-f1fae831ecc0
>> ReportingServicesService!library!f3c!8/13/2004-
10:56:04:: Schedule
>> 48d32fa7-3755-47d4-8fa6-cbe1ab861556 execution
completed at 8/13/2004
>> 10:56:04 AM.
>> ReportingServicesService!dbpolling!f3c!8/13/2004-
10:56:04:: EventPolling
>> finished processing item 226e46a7-15d7-47c9-bad4-
311a2094ff2b
>> ReportingServicesService!dbpolling!47c!8/13/2004-
10:56:04::
>> NotificationPolling processing 1 more items. 1 Total
items in internal
>queue.
>> ReportingServicesService!dbpolling!f3c!8/13/2004-
10:56:04::
>> NotificationPolling processing item 81728282-f0dd-4318-
bc40-f2314d3b4d11
>> ReportingServicesService!library!f3c!08/13/2004-
10:56:04:: i INFO:
>> Initializing EnableIntegratedSecurity to 'True' as
specified in Server
>> system properties.
>> ReportingServicesService!library!f3c!08/13/2004-
10:56:04:: i INFO: Call to
>> RenderFirst( '/Reports/Meta Reports/CountryTable' )
>> ReportingServicesService!library!f3c!08/13/2004-
10:56:04:: e ERROR:
>Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.ServerCo
nfigurationErrorEx
>ception:
>> The Report Server has encountered a configuration
error; more details in
>the
>> log files, AuthzInitializeContextFromSid: Win32 error:
1355;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.ServerCo
nfigurationErrorEx
>ception:
>> The Report Server has encountered a configuration
error; more details in
>the
>> log files
>> ReportingServicesService!library!f3c!08/13/2004-
10:56:04:: i INFO:
>> Initializing EnableExecutionLogging to 'True' as
specified in Server
>system
>> properties.
>> ReportingServicesService!emailextension!f3c!08/13/2004-
10:56:04:: Error
>> sending email.
>Microsoft.ReportingServices.Diagnostics.Utilities.RSExcept
ion:
>> The Report Server has encountered a configuration
error; more details in
>the
>> log files -->
>Microsoft.ReportingServices.Diagnostics.Utilities.ServerCo
nfigurationErrorEx
>ception:
>> The Report Server has encountered a configuration
error; more details in
>the
>> log files
>> at
>Microsoft.ReportingServices.Authorization.Native.GetAuthzC
ontextForUser(IntP
>tr userSid)
>> at
Microsoft.ReportingServices.Authorization.Native.IsAdmin
(String
>> userName)
>> at
>Microsoft.ReportingServices.Authorization.WindowsAuthoriza
tion.IsAdmin(Strin
>g
>> userName, IntPtr userToken)
>> at
>Microsoft.ReportingServices.Authorization.WindowsAuthoriza
tion.CheckAccess(S
>tring
>> userName, IntPtr userToken, Byte[] secDesc,
ReportOperation
>requiredOperation)
>> at
Microsoft.ReportingServices.Library.Security.CheckAccess
(ItemType
>> catItemType, Byte[] secDesc, ReportOperation rptOper)
>> at
>Microsoft.ReportingServices.Library.RSService._GetReportPa
rameterDefinitionF
>romCatalog(CatalogItemContext
>> reportContext, String historyID, Boolean forRendering,
Guid& reportID,
>Int32&
>> executionOption, String& savedParametersXml,
ReportSnapshot&
>> compiledDefinition, ReportSnapshot& snapshotData, Guid&
linkID, DateTime&
>> historyDate)
>> at
Microsoft.ReportingServices.Library.RSService._GetReportPar
ameters(String
>> report, String historyID, Boolean forRendering,
NameValueCollection
>values,
>> DatasourceCredentialsCollection credentials)
>> at
>Microsoft.ReportingServices.Library.RSService.RenderAsLive
OrSnapshot(Catalog
>ItemContext
>> reportContext, ClientRequest session, Warning[]&
warnings,
>> ParameterInfoCollection& effectiveParameters)
>> at
>Microsoft.ReportingServices.Library.RSService.RenderFirst
(CatalogItemContext
>> reportContext, ClientRequest session, Warning[]&
warnings,
>> ParameterInfoCollection& effectiveParameters, String[]&
>secondaryStreamNames)
>> at
>Microsoft.ReportingServices.Library.RenderFirstCancelableS
tep.Execute()
>> at
>Microsoft.ReportingServices.Diagnostics.CancelablePhaseBas
e.ExecuteWrapper()
>> -- End of inner exception stack trace --
>> at
>Microsoft.ReportingServices.Diagnostics.CancelablePhaseBas
e.ExecuteWrapper()
>> at
>Microsoft.ReportingServices.Library.RenderFirstCancelableS
tep.RenderFirst(RS
>Service
>> rs, CatalogItemContext reportContext, ClientRequest
session, JobTypeEnum
>> type, Warning[]& warnings, ParameterInfoCollection&
effectiveParameters,
>> String[]& secondaryStreamNames)
>> at
Microsoft.ReportingServices.Library.ReportImpl.Render
(String
>> renderFormat, String deviceInfo)
>> at
>Microsoft.ReportingServices.EmailDeliveryProvider.EmailPro
vider.ConstructMes
>sageBody(IMessage message, Notification notification,
SubscriptionData data)
>> at
>Microsoft.ReportingServices.EmailDeliveryProvider.EmailPro
vider.CreateMessag
>e(Notification notification)
>> at
>Microsoft.ReportingServices.EmailDeliveryProvider.EmailPro
vider.Deliver(Noti
>fication notification)
>> ReportingServicesService!notification!f3c!08/13/2004-
10:56:04::
>Notification
>> 81728282-f0dd-4318-bc40-f2314d3b4d11 completed.
Success: False, Status:
>> Failure sending mail: The Report Server has encountered
a configuration
>> error; more details in the log files,
DeliveryExtension: Report Server
>Email,
>> Report: CountryTable, Attempt 0
>> ReportingServicesService!dbpolling!f3c!08/13/2004-
10:56:04::
>> NotificationPolling finished processing item
>> 81728282-f0dd-4318-bc40-f2314d3b4d11
>> Thanks a lot !
>> Cheers Dominic
>> "Daniel Reib [MSFT]" wrote:
>> > Can you look in the reportserverservice<date>.log
file instead. This is
>the
>> > log file that should contain the error information.
Is the status of
>the
>> > subscription showing any error?
>> >
>> > --
>> > -Daniel
>
>.
>sql