Friday, March 30, 2012
Report wizard format templates
Thanks,
Warren ThornthwaiteStyle definitions be found in %Program Files%\Microsoft SQL
Server\80\Tools\Report Designer\Business Intelligence
Wizards\Reports\Styles\<Language> folders.
You can add your own style and it should be picked by report wizard.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"_WT_" <WT@.discussions.microsoft.com> wrote in message
news:13C29E40-8EB8-437D-8374-3F5B94C2C1F9@.microsoft.com...
> Are the style templates offered by the Report Wizard accessible somewhere?
> Can I add my own standard templates (beyond the bold, casual, corporate,
> etc.)?
> Thanks,
> Warren Thornthwaitesql
Friday, March 9, 2012
Report Service failed to start
New install of the June SQL 05 Standard CTP bits, the Report Service fails to start with the following errors.
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)
The service (and SQL server) is configured to use Local System as the account.
In RsReportServer.config change your WebServiceAccount to be the actual account the web service runs as, for instance ASPNET or Network Service. If you empty it, we will use a default for the OS.Thanks
Tudor|||Dear Tudor,
I have similar problem. I've just installed the final version of sql 2005 (reporting services as well, side by side with the original sql 2000 + reporting services pair) and the Reporting Services (the old one) service doesn't start after the boot process. My error message is the following:
Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: Event source Schedule and Delivery Processor does not exist.
at Microsoft.ReportingServices.Diagnostics.Utilities.RSEventLog.Init()
at Microsoft.ReportingServices.Diagnostics.Globals.Init(RSConfigurationManager configManager, RunningApplication app)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
In my browser I got the following message instead of my report folders:
Unable to communicate with report server. Please verify that the report server is operational.
Please help me!
Thanks in advance,
marcell|||
Tudor,
Many thanks. Your pointer solved my problem also.
Regards,
Arun Philip
|||anyone please help.... Im unable to start report server...Im not sure if this is similar with the problem posted by Dillon.....Thanks
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!4/26/2007-09:40:01:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
This node doesnt exist in case you are woking on SQL 2000 Reporting services.
Hope This helps.
Report Service failed to start
New install of the June SQL 05 Standard CTP bits, the Report Service fails to start with the following errors.
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)
The service (and SQL server) is configured to use Local System as the account.
In RsReportServer.config change your WebServiceAccount to be the actual account the web service runs as, for instance ASPNET or Network Service. If you empty it, we will use a default for the OS.Thanks
Tudor|||Dear Tudor,
I have similar problem. I've just installed the final version of sql 2005 (reporting services as well, side by side with the original sql 2000 + reporting services pair) and the Reporting Services (the old one) service doesn't start after the boot process. My error message is the following:
Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: Event source Schedule and Delivery Processor does not exist.
at Microsoft.ReportingServices.Diagnostics.Utilities.RSEventLog.Init()
at Microsoft.ReportingServices.Diagnostics.Globals.Init(RSConfigurationManager configManager, RunningApplication app)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
In my browser I got the following message instead of my report folders:
Unable to communicate with report server. Please verify that the report server is operational.
Please help me!
Thanks in advance,
marcell|||
Tudor,
Many thanks. Your pointer solved my problem also.
Regards,
Arun Philip
|||anyone please help.... Im unable to start report server...Im not sure if this is similar with the problem posted by Dillon.....Thanks
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!4/26/2007-09:40:01:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
This node doesnt exist in case you are woking on SQL 2000 Reporting services.
Hope This helps.
Report Service failed to start
New install of the June SQL 05 Standard CTP bits, the Report Service fails to start with the following errors.
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)
The service (and SQL server) is configured to use Local System as the account.
In RsReportServer.config change your WebServiceAccount to be the actual account the web service runs as, for instance ASPNET or Network Service. If you empty it, we will use a default for the OS.Thanks
Tudor|||Dear Tudor,
I have similar problem. I've just installed the final version of sql 2005 (reporting services as well, side by side with the original sql 2000 + reporting services pair) and the Reporting Services (the old one) service doesn't start after the boot process. My error message is the following:
Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: Event source Schedule and Delivery Processor does not exist.
at Microsoft.ReportingServices.Diagnostics.Utilities.RSEventLog.Init()
at Microsoft.ReportingServices.Diagnostics.Globals.Init(RSConfigurationManager configManager, RunningApplication app)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
In my browser I got the following message instead of my report folders:
Unable to communicate with report server. Please verify that the report server is operational.
Please help me!
Thanks in advance,
marcell|||
Tudor,
Many thanks. Your pointer solved my problem also.
Regards,
Arun Philip
|||anyone please help.... Im unable to start report server...Im not sure if this is similar with the problem posted by Dillon.....Thanks
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!4/26/2007-09:40:01:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
This node doesnt exist in case you are woking on SQL 2000 Reporting services.
Hope This helps.
Report Service failed to start
New install of the June SQL 05 Standard CTP bits, the Report Service fails to start with the following errors.
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)
The service (and SQL server) is configured to use Local System as the account.
In RsReportServer.config change your WebServiceAccount to be the actual account the web service runs as, for instance ASPNET or Network Service. If you empty it, we will use a default for the OS.Thanks
Tudor|||Dear Tudor,
I have similar problem. I've just installed the final version of sql 2005 (reporting services as well, side by side with the original sql 2000 + reporting services pair) and the Reporting Services (the old one) service doesn't start after the boot process. My error message is the following:
Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: Event source Schedule and Delivery Processor does not exist.
at Microsoft.ReportingServices.Diagnostics.Utilities.RSEventLog.Init()
at Microsoft.ReportingServices.Diagnostics.Globals.Init(RSConfigurationManager configManager, RunningApplication app)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
In my browser I got the following message instead of my report folders:
Unable to communicate with report server. Please verify that the report server is operational.
Please help me!
Thanks in advance,
marcell|||
Tudor,
Many thanks. Your pointer solved my problem also.
Regards,
Arun Philip
|||anyone please help.... Im unable to start report server...Im not sure if this is similar with the problem posted by Dillon.....Thanks
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!4/26/2007-09:40:01:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
This node doesnt exist in case you are woking on SQL 2000 Reporting services.
Hope This helps.
Report Service failed to start
New install of the June SQL 05 Standard CTP bits, the Report Service fails to start with the following errors.
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)
The service (and SQL server) is configured to use Local System as the account.
In RsReportServer.config change your WebServiceAccount to be the actual account the web service runs as, for instance ASPNET or Network Service. If you empty it, we will use a default for the OS.Thanks
Tudor|||Dear Tudor,
I have similar problem. I've just installed the final version of sql 2005 (reporting services as well, side by side with the original sql 2000 + reporting services pair) and the Reporting Services (the old one) service doesn't start after the boot process. My error message is the following:
Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: Event source Schedule and Delivery Processor does not exist.
at Microsoft.ReportingServices.Diagnostics.Utilities.RSEventLog.Init()
at Microsoft.ReportingServices.Diagnostics.Globals.Init(RSConfigurationManager configManager, RunningApplication app)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
In my browser I got the following message instead of my report folders:
Unable to communicate with report server. Please verify that the report server is operational.
Please help me!
Thanks in advance,
marcell|||
Tudor,
Many thanks. Your pointer solved my problem also.
Regards,
Arun Philip
|||anyone please help.... Im unable to start report server...Im not sure if this is similar with the problem posted by Dillon.....Thanks
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!4/26/2007-09:40:01:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
This node doesnt exist in case you are woking on SQL 2000 Reporting services.
Hope This helps.
Report Service failed to start
New install of the June SQL 05 Standard CTP bits, the Report Service fails to start with the following errors.
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)
The service (and SQL server) is configured to use Local System as the account.
In RsReportServer.config change your WebServiceAccount to be the actual account the web service runs as, for instance ASPNET or Network Service. If you empty it, we will use a default for the OS.Thanks
Tudor|||Dear Tudor,
I have similar problem. I've just installed the final version of sql 2005 (reporting services as well, side by side with the original sql 2000 + reporting services pair) and the Reporting Services (the old one) service doesn't start after the boot process. My error message is the following:
Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: Event source Schedule and Delivery Processor does not exist.
at Microsoft.ReportingServices.Diagnostics.Utilities.RSEventLog.Init()
at Microsoft.ReportingServices.Diagnostics.Globals.Init(RSConfigurationManager configManager, RunningApplication app)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
In my browser I got the following message instead of my report folders:
Unable to communicate with report server. Please verify that the report server is operational.
Please help me!
Thanks in advance,
marcell|||
Tudor,
Many thanks. Your pointer solved my problem also.
Regards,
Arun Philip
|||anyone please help.... Im unable to start report server...Im not sure if this is similar with the problem posted by Dillon.....Thanks
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!4/26/2007-09:40:01:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
This node doesnt exist in case you are woking on SQL 2000 Reporting services.
Hope This helps.
Report Server Stored Credentials
I am getting the standard "Subscriptions cannot be created because the credentials used to run the report are not stored -".I tried to store them in the Stored Data Source in the Visual Studio Project and then deployed. I cannot find in any documentation a reference where to go to STORE CREDENTIALS for a Report Server subscription. I would really appreciate any help on this. I did look at the existing threads, but they don't specifically address where to create the credentials. Thanks for any help you can provide.
Hello Gary,
Using Report Manager, drill down to your report. Click the properties tab, then select 'data sources' on the left side of the page. Make sure the 'A custom data source' is the radio button selected, then click the radio button for 'Credentials stored securely in the report server'. Type in your credentials to run the report and if it's a domain account, then check the box for 'Use as Windows credentials when connecting to the data source'. Click Apply at the bottom and you should be able to create a subscription.
Hope this helps.
Jarret
|||Where is this in the documentation? I searched Books on Line and MSDN and got NADA. What a brilliant person you are. Maybe smarter than the richest man in the world (BG), how bout that. Thanks and thanks again.|||Many thanks for your kind words Gary.
In BOL, just search for 'stored credentials', it also has a way to set the stored credentials via a RS connection in Management Studio.
Jarret
Saturday, February 25, 2012
Report server does not initialize
I am using ms sql 2005 standard edition on windows Nt
Everything is working fine except the report server..
when i run the configuration tool and try to start the report server, it fails to start.. i am using sql on the local machine .
i have set p lmy database on the windows credentials..
i am using my machine name/user name as the account name for the database setup.
i have also used rsconfig utility to configure the report server but nothing happens after that..
pls help
SQL Server 2005 introduces a new inteface for configuring the report server. It is located under Programs --> Microsoft SQL Server 2005 --> Configuration Tools --> Reporting Services Configuration. YOu can reinitialize your report also from here with the graphical UI. If that doens′t solve the problem, try to get the error messages fromt he log directory and the event log to see what is going on behind the scenes.
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
|||Hi
Thanks Jens
I did manage to start my report server.But when i try to build reports in Business intelligence, i get an error saying "out of memory exception".
Everything seems to be running fine in the configuration manager..i even tried to run the service pack 1 but it doesnt work. i get an error which says " setup is not able to access sql with the login details.
I have checked the login details as well.... both RS and SQL server use windows credentials
Please help..what do i do?
|||That sounds strange. Are you getting the errors while deploying the reports on the server or during the creation of a Reporting Services project ? Although it could be that there is a problem within your SQL Server (you might check the event logs for abnormalities) there is sure a problem with your client if the error occurs during the creation of the reports. Before finding the needle in the hay, deinstall the tools / client components and reinstall them. Afterwards apply Service Pack 1 and the post hotfixes that you will have the current built of 2153. Let see if that helps.
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
i am getting the error when i click the preview button in report server for generating the reports...
i have checked the error log and everything seems to be running fine. i have done the reistallation but it still it does not help. i applied the service pack 1 but it does not run properly. it gives me the error " setup cannot access the sql server with the login deails".. i have checked the logins as well. i am using windows credentials for both sql server and report server. please help me as our entire business is developing report and sending it to our clients...
Report Server Database Set Up
Verify Database Edition
The Feature: "Using other editions of sql server for report datasources and/or the report server database" is not supported in this edition of Reporting Services.
i can't i can figure out how to get around this i mean i can configure everything else from the virtual directory but not the Database Setup..What SKU of SQL Server did you install and what SKU of SSRS are you trying to install. This error is thrown when those two don't match.|||yeah i see i have the developer version installed and i installed report server from the standard edition How can i uninstall the report server?|||You should be able to use add/remove programs to get it uninstalled.