How to get the beta sp 2

I am working through the issue of email not working through subscription,
which seems to be an issue for many after scouring this forum and the net
over the past few days. I have a 2003 Server running with RS, SP1 installed
but I keep getting the error that the server saying ... "Failure sending
mail: The Report Server has encountered a configuration error; more details
in the log files" and the lof files show nothing other than the error that
has been mentioned here several times ...
ReportingServicesService!library!1678!01/07/2005-07:33:07:: i INFO: Call to
RenderFirst( '/Sutter Connect/SC EDI/EDI Utilization Vendor Report' )
ReportingServicesService!library!1678!01/07/2005-07:33:07:: 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 read through many KB articles, including 842423 and I can get it to
send just the link as mentioned in that article. I have tried the fixes and
installed the SP1 to no avail. I have reinstalled RS three times, using
different accounts (Local Admin, two different service domain accounts) and
nothing fixes the problem. I have the same issue on a test machine running
2000 Server. So I cannot get this feature to work.
Can anyone help? Does anyone know how to get the beta SP2? I am willing to
try anything. Thanks in advance.
~Sharihttp://support.microsoft.com/kb/842440 contains information about how you
can request access to SQL Server 2000 Reporting Services Beta 2.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Shari" <Shari@.discussions.microsoft.com> wrote in message
news:C319A846-B349-4E06-9C67-F00843B53717@.microsoft.com...
>I am working through the issue of email not working through subscription,
> which seems to be an issue for many after scouring this forum and the net
> over the past few days. I have a 2003 Server running with RS, SP1
> installed
> but I keep getting the error that the server saying ... "Failure sending
> mail: The Report Server has encountered a configuration error; more
> details
> in the log files" and the lof files show nothing other than the error that
> has been mentioned here several times ...
> ReportingServicesService!library!1678!01/07/2005-07:33:07:: i INFO: Call
> to
> RenderFirst( '/Sutter Connect/SC EDI/EDI Utilization Vendor Report' )
> ReportingServicesService!library!1678!01/07/2005-07:33:07:: 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 read through many KB articles, including 842423 and I can get it to
> send just the link as mentioned in that article. I have tried the fixes
> and
> installed the SP1 to no avail. I have reinstalled RS three times, using
> different accounts (Local Admin, two different service domain accounts)
> and
> nothing fixes the problem. I have the same issue on a test machine running
> 2000 Server. So I cannot get this feature to work.
> Can anyone help? Does anyone know how to get the beta SP2? I am willing to
> try anything. Thanks in advance.
> ~Shari|||Thank you Stephen for your very quick response. I submitted a request to that
link esterday and am waiting. Is it just a waiting game? Is there any other
method of getting this SP asap?
Thanks,
Shari
"Stephen Dybing [MSFT]" wrote:
> http://support.microsoft.com/kb/842440 contains information about how you
> can request access to SQL Server 2000 Reporting Services Beta 2.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Please reply to the newsgroups only, thanks.
> "Shari" <Shari@.discussions.microsoft.com> wrote in message
> news:C319A846-B349-4E06-9C67-F00843B53717@.microsoft.com...
> >I am working through the issue of email not working through subscription,
> > which seems to be an issue for many after scouring this forum and the net
> > over the past few days. I have a 2003 Server running with RS, SP1
> > installed
> > but I keep getting the error that the server saying ... "Failure sending
> > mail: The Report Server has encountered a configuration error; more
> > details
> > in the log files" and the lof files show nothing other than the error that
> > has been mentioned here several times ...
> >
> > ReportingServicesService!library!1678!01/07/2005-07:33:07:: i INFO: Call
> > to
> > RenderFirst( '/Sutter Connect/SC EDI/EDI Utilization Vendor Report' )
> > ReportingServicesService!library!1678!01/07/2005-07:33:07:: 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 read through many KB articles, including 842423 and I can get it to
> > send just the link as mentioned in that article. I have tried the fixes
> > and
> > installed the SP1 to no avail. I have reinstalled RS three times, using
> > different accounts (Local Admin, two different service domain accounts)
> > and
> > nothing fixes the problem. I have the same issue on a test machine running
> > 2000 Server. So I cannot get this feature to work.
> >
> > Can anyone help? Does anyone know how to get the beta SP2? I am willing to
> > try anything. Thanks in advance.
> >
> > ~Shari
>
>|||I do not know what the process is behind that link, and it might very well
be manual, so you should just give it a couple more days. Sorry, there isn't
any other way of getting it that I'm aware of.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Shari" <Shari@.discussions.microsoft.com> wrote in message
news:FB15ED4B-14B9-4886-944C-EB368F658B25@.microsoft.com...
> Thank you Stephen for your very quick response. I submitted a request to
> that
> link esterday and am waiting. Is it just a waiting game? Is there any
> other
> method of getting this SP asap?
> Thanks,
> Shari
>
> "Stephen Dybing [MSFT]" wrote:
>> http://support.microsoft.com/kb/842440 contains information about how you
>> can request access to SQL Server 2000 Reporting Services Beta 2.
>> --
>> Sincerely,
>> Stephen Dybing
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Please reply to the newsgroups only, thanks.
>> "Shari" <Shari@.discussions.microsoft.com> wrote in message
>> news:C319A846-B349-4E06-9C67-F00843B53717@.microsoft.com...
>> >I am working through the issue of email not working through
>> >subscription,
>> > which seems to be an issue for many after scouring this forum and the
>> > net
>> > over the past few days. I have a 2003 Server running with RS, SP1
>> > installed
>> > but I keep getting the error that the server saying ... "Failure
>> > sending
>> > mail: The Report Server has encountered a configuration error; more
>> > details
>> > in the log files" and the lof files show nothing other than the error
>> > that
>> > has been mentioned here several times ...
>> >
>> > ReportingServicesService!library!1678!01/07/2005-07:33:07:: i INFO:
>> > Call
>> > to
>> > RenderFirst( '/Sutter Connect/SC EDI/EDI Utilization Vendor Report' )
>> > ReportingServicesService!library!1678!01/07/2005-07:33:07:: 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 read through many KB articles, including 842423 and I can get it
>> > to
>> > send just the link as mentioned in that article. I have tried the fixes
>> > and
>> > installed the SP1 to no avail. I have reinstalled RS three times, using
>> > different accounts (Local Admin, two different service domain accounts)
>> > and
>> > nothing fixes the problem. I have the same issue on a test machine
>> > running
>> > 2000 Server. So I cannot get this feature to work.
>> >
>> > Can anyone help? Does anyone know how to get the beta SP2? I am willing
>> > to
>> > try anything. Thanks in advance.
>> >
>> > ~Shari
>>|||Did you get sp2 and did it solve the problem? (I'm having same trouble with RS SP1 on 2003 Server.)
--
Message posted via http://www.sqlmonster.com|||I worked this incident with Microsoft tried windows 2003 sp1 to no avail and then found an answer. They should be posting the new information in their kb and they are considering changes to the software to prevent this behavior.
To sum it up, the account that the report services is running as is having trouble checking some authorization attributes of the user that created the subscription. In my case my user account is in a different domain than the user account the sql reporting services is running as and my domain did not trust the domain of the sql reporting service account. So when the job tried to run that service account was not allowed to check an attribute in my domain for the account of the user that created the subscription. When the check fails it prevents the job from running and does not produce a very friendly error message. In my case I was able to create the 2 way trust relationship and it worked immediately.
MS's reason for doing this initially was so if an employee sets up a subscription to email himself corporate data and he quits or gets fired, they wanted to make sure his subscription stopped working once his account is disabled. I gave feedback that if an admin sets up production subscriptions and then leaves the company, you don't want your production systems to stop operating. They are reviewing the strategy and are considering not failing the job but rather just log warnings in the event log.
--
Message posted via http://www.sqlmonster.com|||More info: It seems the same process did not work for a Windows 2000
server, it seems the magic solution in our case was:
This worked:
Server 2003 SP1 (RC1)
Reporting Services SP1
RS Service domain trusted by subscription creator domain
This did not:
Server 2000 SP4
Reporting Services SP1
RS Service domain trusted by subscription creator domain
--
Message posted via http://www.sqlmonster.com