Groups | Blog | Home
all groups > sql server reporting services > july 2004 >

sql server reporting services : Service Account and Subcriptions



Jason Nissen
7/3/2004 10:17:14 AM
I am having problems with both email/file share subscriptions. The Report
Manager displays the following error:

Failure writing file Sales Order Detail : The Report Server has
encountered a configuration error; more details in the log files


The log file contains the following entries:

ReportingServicesService!library!628!07/03/2004-09:59:09:: 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: 5;
possible reason - service account doesn't have rights to check domain user
SIDs.;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files

It appears to be encountering a problem when trying to call
AuthzInitializeContextFromSid method.

Has anyone else encountered similar problems or have any ideas on what the
issue may be?

Thanks.

Jason

Brian Welcker [MSFT]
7/3/2004 12:59:08 PM
What identity are you running the ReportServer service under?

--
Brian Welcker
Group Program Manager
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Brian Welcker [MSFT]
7/3/2004 2:06:15 PM
It is using AuthZ to check whether the user still has access to the report
before sending it. To do this, AD / DC is needed to resolve group
membership. For some reason, this seems to be failing.

--
Brian Welcker
Group Program Manager
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Jason Nissen
7/3/2004 3:53:28 PM
I am running under a Windows domain account.

I have been doing some additional research and found this KB article.

http://support.microsoft.com/default.aspx?scid=kb;en-us;331951

Could it be the fact that Reporting Services is on a Windows 2003 server but
the domain controller(s) are Windows 2000?

I added this account to the WAA group, however, it does not appear to have
resolved the issue.

What exactly is Reporting Services querying for within Active Directory when
executing subscriptions?

Jason


[quoted text, click to view]

TonyB
8/6/2004 2:51:02 PM
So how do you fix it??????

[quoted text, click to view]
MichaelH
10/13/2004 2:37:02 PM
I'm having a similar problem. Here's the not so brief run-down:

I have SQL Reporting Services running on a Windows 2000 box with SP3. I've
had it running on this machine for the last 2 months. As of last week my
subscriptions that write reports to a file share started failing. Originally
the error was AuthzInitializeContextFromSid: Win32 error: 110; The error was
received while running the ReportServer service under the local system
account. After reviewing a couple articles I tried switching the Log On
account from the local system account to a domain account.

The good news is I stopped receiving that error, but I ended up with another
problem. The subscriptions would not use the credentials supplied. So the
subscriptions could not write to the specified file share because the
service's Log On account didn't have rights.

So... It seems to me that all of the sudden my SQL reporting services has
stopped using the credentials supplied in the subscription. I don't believe
its a server configuration error, because I just built a new 2000 box with RS
installed and its coming up with the same error. It seems that some setting
on the domain has changed to prevent the use of the credentials.

Our domain is running in mixed mode, and I am unable to track down any
significant changes in the domain's security policies.

So any help would be much appreciated!

[quoted text, click to view]
George Martin
12/12/2004 3:15:01 PM
I have something similar with ReportServer on Win 2003 box but domain is a
Win 2000 mixed mode.
Error is:

ReportingServicesService!library!1334!12/13/2004-11:40:11:: 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

I have tried email & file share, neither work.
Have set ReportServer service to domain administrator and rsconfig with same
settings.

What log files is it refering to, have tried various to see if they have any
other info - there is nothing in Windows log files.

Any help appreciated.


[quoted text, click to view]
Mark
2/22/2005 9:11:03 AM
Any luck with resolving this problem? I also got the error with 110, and I've
been trying to change the service account, and using rsconfig - although it
doesn't seem to be taking the change (when I look at the execution log table
in Reportserver database, it appears that the system is still using NT
AUTHORITY/System account, not the new domain account I thought I changed it
to).

NOTE: unlike some people in this thread, I have NEVER been able to get
subscriptions to work on this installation.
(win2K sp3, rs with sp1 installed)

Mark

[quoted text, click to view]
AddThis Social Bookmark Button