RS service won't start

I have RS 2005 on a Win 2003 SP1 x64 with SQL2005 & SQL 2000 installed. RS
was installed and running fine with several reports until one of my DC died.
I have a 2nd DC which I then had to install DHCP service, but other than that
everything else seems to running. Now the RS service wont start and I get the
following errors:
Event Type: Error
Event Source: Report Server Windows Service (SQL2005)
Event Category: Startup/Shutdown
Event ID: 121
Date: 6/2/2006
Time: 2:53:25 PM
User: N/A
Computer: ATHENA
Description:
The Remote Procedure Call (RPC) service failed to start.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Event Type: Error
Event Source: SQL Server Report Service
Event Category: None
Event ID: 0
Date: 6/2/2006
Time: 2:53:25 PM
User: N/A
Computer: ATHENA
Description:
Service cannot be started.
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
The user or group name 'LocalSystem' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean
firstTime)
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[]
args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object
state)
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
ANy ideas?
I assume the service for some reason is looking for the missing dc, but
where can I change the configuration?I have Windows 2000 server. I installed my IIS 5.0 and then installed MS SQL
Server 2005. I am using the Reporting Services Feature.I am able to create
projects and make reports but am not able to deploy them on the Report
Server.It seems like the Report Server is not configured.In the Reporting
Services Configuration window it gives a not configured legend on the Web
Server and Web Service Identity. The error that i get is :
Service cannot be started.
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
The user or group name 'WSR2K099\ASPNET' is not recognized.
I am new to SQL server 2005 reporting services plz help.
Thanks
saurabh
"Joe S." wrote:
> I have RS 2005 on a Win 2003 SP1 x64 with SQL2005 & SQL 2000 installed. RS
> was installed and running fine with several reports until one of my DC died.
> I have a 2nd DC which I then had to install DHCP service, but other than that
> everything else seems to running. Now the RS service wont start and I get the
> following errors:
> Event Type: Error
> Event Source: Report Server Windows Service (SQL2005)
> Event Category: Startup/Shutdown
> Event ID: 121
> Date: 6/2/2006
> Time: 2:53:25 PM
> User: N/A
> Computer: ATHENA
> Description:
> The Remote Procedure Call (RPC) service failed to start.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
>
> Event Type: Error
> Event Source: SQL Server Report Service
> Event Category: None
> Event ID: 0
> Date: 6/2/2006
> Time: 2:53:25 PM
> User: N/A
> Computer: ATHENA
> Description:
> Service cannot be started.
> Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
> The user or group name 'LocalSystem' is not recognized.
> at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
> at
> Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
> at
> Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean
> firstTime)
> at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[]
> args)
> at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object
> state)
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> ANy ideas?
> I assume the service for some reason is looking for the missing dc, but
> where can I change the configuration?
>|||I solved my problem. Some how with the departure of the DC my RS config file
went back to the wrong account as outlined in this MS article with regards to
the system account. Hopefully this will solve ur problem also.
http://support.microsoft.com/kb/907267/en-us
"Saurabh" wrote:
> I have Windows 2000 server. I installed my IIS 5.0 and then installed MS SQL
> Server 2005. I am using the Reporting Services Feature.I am able to create
> projects and make reports but am not able to deploy them on the Report
> Server.It seems like the Report Server is not configured.In the Reporting
> Services Configuration window it gives a not configured legend on the Web
> Server and Web Service Identity. The error that i get is :
> Service cannot be started.
> Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
> The user or group name 'WSR2K099\ASPNET' is not recognized.
> I am new to SQL server 2005 reporting services plz help.
> Thanks
> saurabh
> "Joe S." wrote:
> > I have RS 2005 on a Win 2003 SP1 x64 with SQL2005 & SQL 2000 installed. RS
> > was installed and running fine with several reports until one of my DC died.
> > I have a 2nd DC which I then had to install DHCP service, but other than that
> > everything else seems to running. Now the RS service wont start and I get the
> > following errors:
> >
> > Event Type: Error
> > Event Source: Report Server Windows Service (SQL2005)
> > Event Category: Startup/Shutdown
> > Event ID: 121
> > Date: 6/2/2006
> > Time: 2:53:25 PM
> > User: N/A
> > Computer: ATHENA
> > Description:
> > The Remote Procedure Call (RPC) service failed to start.
> >
> > For more information, see Help and Support Center at
> > http://go.microsoft.com/fwlink/events.asp.
> >
> >
> >
> >
> >
> > Event Type: Error
> > Event Source: SQL Server Report Service
> > Event Category: None
> > Event ID: 0
> > Date: 6/2/2006
> > Time: 2:53:25 PM
> > User: N/A
> > Computer: ATHENA
> > Description:
> > Service cannot be started.
> > Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
> > The user or group name 'LocalSystem' is not recognized.
> > at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
> > at
> > Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
> > at
> > Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean
> > firstTime)
> > at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[]
> > args)
> > at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object
> > state)
> >
> > For more information, see Help and Support Center at
> > http://go.microsoft.com/fwlink/events.asp.
> >
> >
> > ANy ideas?
> >
> > I assume the service for some reason is looking for the missing dc, but
> > where can I change the configuration?
> >

RS 2005 Subscription Disabled

Hello,
I'm using SQL 2005 SP2 build 3215 x64 Enterprise (4x dualcore 8Gram)
Everything is working OK (SQL,SSIS,AS,RS) except creating data driven
subscriptions.
I have an report with an custom data source (to AS) wich is working OK.
The credentials are stored in DB, SQL Agent is working a.so.
The web services is running under NT\SYSTEM, I am connected with a
domain user which is local admin.
Report Manager web interface:
I can create "normal" subscriptions and they are working OK.
I can't create data driven subscription (there is no option to create
it). (yes, it is enterprise version, see appendix :) )
Management Studio (started on the server via Remote desktop, logged in
as a domain user in the local admin group):
Both "New Subscription" and "New Data Driven Subscription" are grayed
out (disabled).
I can see the subscription created via Report Manager but I can't access
its properties , I can only delete it.
Question:
How can I create a data driven subscription from Management Studio?
How can I get the Items (create subscription) enabled in the context menu?
What I'm doing wrong ? :)
Cheers,
Radu
APPENDIX:
select @.@.version:
Microsoft SQL Server 2005 - 9.00.3215.00 (X64) Dec 8 2007 17:58:16
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition
(64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
All the components SQL, AS, RS are running on the same server.I want to add that we have made some time ago an upgrade from Standard
Edition to Enterprise Edition
Maybe something get wrong with upgrading the RS?
Radu