Reporting Services add (browser) back button

Dear all,

I have a client that has 4 reports; 1 main, and 3 that are rendered when the user clicks the report data on the main report (which passes parameters to generate the other 3).

They would like to have a back button in the report header of the 3 reports (they don't want to use the browser back button).

Is this possible using a text box, then editing the navigation properties and does anyone have an example? Or am I missing something quite obvious?

Any help would be gratefully received!!

Dan

Actually I managed to use javascript:history.back(1)

Reporting Services 2005

What is the best option to monitor user accesses to published reports? IT department wants to have an idea about the need (value and time) of produced reports.

Regards,

Vitor Mota

I will not comment on what the "best option" is, but this is an option I use frequently for debugging.

If you use stored procedures to generate the data for your reports, you can have them update a stats table to indicate that a given report has been run. You would have to have stored procedures unique to a given report for this to work, but I suppose if you wanted to be fancy, you could write stored procedures just for this purpose.

Otherwise, there are lots of IIS log analyzers out there.

|||

Thanks for your answer.

I'm reading data to reports using MDX queries without using sps and analyzing the IIS logs are hard to do.

I was looking for an "almost" ready solution to use. Any other idea?

Best regards,

Vitor Mota

reporting services (client or server) ad-hoc user created reports?

Hi,
I would like to allow my users to create report templates and save them.
The reports should get their data from my business objects. I'm not really
sure where to begin with this.. I image that i'll need to setup reporting
services.
Currently I have rdlc client reports and report viewer. I don't mind moving
to server reports if required, but i'd like to continue to use the viewer to
display them in my application.
Has anyone else done this?
Thanks
Andyhey Andy
have you had a look at Report Builder? This is really what this is
for.
Dianne
On Apr 26, 8:50 am, Andy <A...@.discussions.microsoft.com> wrote:
> Hi,
> I would like to allow my users to create report templates and save them.
> The reports should get their data from my business objects. I'm not really
> sure where to begin with this.. I image that i'll need to setupreportingservices.
> Currently I have rdlc client reports and report viewer. I don't mind moving
> to server reports if required, but i'd like to continue to use the viewer to
> display them in my application.
> Has anyone else done this?
> Thanks
> Andy|||On Apr 26, 5:55 pm, jewelfire <jewelfi...@.gmail.com> wrote:
> hey Andy
> have you had a look at Report Builder? This is really what this is
> for.
Yes, but I'm at the point where I still need to learn how to build the
model for use in report builder. As I said, I'm just starting with
this.. and only one book I found spends any time on ad-hoc reports,
and only one chapter.

Reporting service not starting - The user or group name 'VIDICOM\ASPNET' is not recognized.

Hi, I've been trying for the past week to get SQL 2005 Server up and running.

The SQL is up and running however I am unable to get the Reporting service to start. The log file is below but the main line is:

ReportingServicesService!library!4!29/06/2006-14:33:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:The user or group name 'VIDICOM\ASPNET' is not recognized.

But the domain user ASPNET is present. Similar posts across the internet mention about the .NET Framework not be installed correctly. I have reinstalled it many times.

Any help is most appreciated.

Tom

Here is the full log file:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\ReportServerService__main_06_29_2006_14_33_39.log</Path>
<SystemName>CRM</SystemName>
<OSName>Microsoft Windows NT 5.0.2195 Service Pack 4</OSName>
<OSVersion>5.0.2195.262144</OSVersion>
</Header>
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!servicecontroller!9!29/06/2006-14:33:45:: Total Physical memory: 267894784
ReportingServicesService!library!4!29/06/2006-14:33:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!29/06/2006-14:33:47:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)

Dear,

From question and log poseted above it seems that the user u are using to start the reporting services doesnt have right to access the reporting databases .

Flow these steps

Browse to the reporting services configuration manager.

delete the encription keys if delete option is enabled in the ecription key section.

check report server virtual directory is connect to Reportserver$..... database

report manager virtual directoy to Reports$...... database

Windows service identity : Service account must be NT Authority / Network Service

In the database connection

confirm that the database connection is ReportServer$......

Then backup the Encription keys.

HTH

from

sufian

|||Thanks for the reply but it hasnt worked. In the reporting configuration manager I have ticks next to:

Report Server Virtual Directory
Report Manager Virtual Directory
Windows Service Identity
Database Setup
Email Settings
Execution Account

But have crosses next to:
Server Status
Web Service Identity
Initialization

and an exclaimation mark next to encryption keys.

On the Database setup page, what should the credentials type be set to? and also how about the execution account?|||

Dear,

On the database setup page the credential should be set to service credentials.

Leave the exection account and email seeting this time first start the reporting services.

Delete the encription keys.

Tell me onething do u have namedstance installed on the server.

Regards

sufian

|||

Hi there. If I understand correctly, you are using win2K, with SQL 2k5, and want to get Reporting Service to Start? (And this is a fresh install?)

have you seen this ? http://support.microsoft.com/default.aspx/kb/911846

It says that you should make your Rsreportserver.config file's <WebServiceAccount></WebServiceAccount> tag the IWAM_ComputerName for windows 2000.

Hope This helps

-Hoovie

P.S. Is you Server a Domain Controler? "For more information about potential problems running version 1.1 on a domain controller, see article Q824308, "IWAM Account is Not Granted the Impersonate Privilege for ASP.NET 1.1 on Windows 2000 Domain Controller with SP4," in the Microsoft Knowledge Base at http://support.microsoft.com. For more information about running version 1.0 of the .NET Framework on a domain controller, see article Q315158, "ASP.NET Does Not Work with the Default ASPNET Account on a Domain Controller," in the Microsoft Knowledge Base at http://support.microsoft.com."

Reporting service not starting - The user or group name 'VIDICOM\ASPNET' is not recognized.

Hi, I've been trying for the past week to get SQL 2005 Server up and running.

The SQL is up and running however I am unable to get the Reporting service to start. The log file is below but the main line is:

ReportingServicesService!library!4!29/06/2006-14:33:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:The user or group name 'VIDICOM\ASPNET' is not recognized.

But the domain user ASPNET is present. Similar posts across the internet mention about the .NET Framework not be installed correctly. I have reinstalled it many times.

Any help is most appreciated.

Tom

Here is the full log file:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\ReportServerService__main_06_29_2006_14_33_39.log</Path>
<SystemName>CRM</SystemName>
<OSName>Microsoft Windows NT 5.0.2195 Service Pack 4</OSName>
<OSVersion>5.0.2195.262144</OSVersion>
</Header>
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!servicecontroller!9!29/06/2006-14:33:45:: Total Physical memory: 267894784
ReportingServicesService!library!4!29/06/2006-14:33:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!29/06/2006-14:33:47:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)

Dear,

From question and log poseted above it seems that the user u are using to start the reporting services doesnt have right to access the reporting databases .

Flow these steps

Browse to the reporting services configuration manager.

delete the encription keys if delete option is enabled in the ecription key section.

check report server virtual directory is connect to Reportserver$..... database

report manager virtual directoy to Reports$...... database

Windows service identity : Service account must be NT Authority / Network Service

In the database connection

confirm that the database connection is ReportServer$......

Then backup the Encription keys.

HTH

from

sufian

|||Thanks for the reply but it hasnt worked. In the reporting configuration manager I have ticks next to:

Report Server Virtual Directory
Report Manager Virtual Directory
Windows Service Identity
Database Setup
Email Settings
Execution Account

But have crosses next to:
Server Status
Web Service Identity
Initialization

and an exclaimation mark next to encryption keys.

On the Database setup page, what should the credentials type be set to? and also how about the execution account?|||

Dear,

On the database setup page the credential should be set to service credentials.

Leave the exection account and email seeting this time first start the reporting services.

Delete the encription keys.

Tell me onething do u have namedstance installed on the server.

Regards

sufian

|||

Hi there. If I understand correctly, you are using win2K, with SQL 2k5, and want to get Reporting Service to Start? (And this is a fresh install?)

have you seen this ? http://support.microsoft.com/default.aspx/kb/911846

It says that you should make your Rsreportserver.config file's <WebServiceAccount></WebServiceAccount> tag the IWAM_ComputerName for windows 2000.

Hope This helps

-Hoovie

P.S. Is you Server a Domain Controler? "For more information about potential problems running version 1.1 on a domain controller, see article Q824308, "IWAM Account is Not Granted the Impersonate Privilege for ASP.NET 1.1 on Windows 2000 Domain Controller with SP4," in the Microsoft Knowledge Base at http://support.microsoft.com. For more information about running version 1.0 of the .NET Framework on a domain controller, see article Q315158, "ASP.NET Does Not Work with the Default ASPNET Account on a Domain Controller," in the Microsoft Knowledge Base at http://support.microsoft.com."

Reporting service not starting - The user or group name 'VIDICOM\ASPNET' is not recognized

Hi, I've been trying for the past week to get SQL 2005 Server up and running.

The SQL is up and running however I am unable to get the Reporting service to start. The log file is below but the main line is:

ReportingServicesService!library!4!29/06/2006-14:33:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:The user or group name 'VIDICOM\ASPNET' is not recognized.

But the domain user ASPNET is present. Similar posts across the internet mention about the .NET Framework not be installed correctly. I have reinstalled it many times.

Any help is most appreciated.

Tom

Here is the full log file:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\ReportServerService__main_06_29_2006_14_33_39.log</Path>
<SystemName>CRM</SystemName>
<OSName>Microsoft Windows NT 5.0.2195 Service Pack 4</OSName>
<OSVersion>5.0.2195.262144</OSVersion>
</Header>
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!servicecontroller!9!29/06/2006-14:33:45:: Total Physical memory: 267894784
ReportingServicesService!library!4!29/06/2006-14:33:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!29/06/2006-14:33:47:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)

Dear,

From question and log poseted above it seems that the user u are using to start the reporting services doesnt have right to access the reporting databases .

Flow these steps

Browse to the reporting services configuration manager.

delete the encription keys if delete option is enabled in the ecription key section.

check report server virtual directory is connect to Reportserver$..... database

report manager virtual directoy to Reports$...... database

Windows service identity : Service account must be NT Authority / Network Service

In the database connection

confirm that the database connection is ReportServer$......

Then backup the Encription keys.

HTH

from

sufian

|||Thanks for the reply but it hasnt worked. In the reporting configuration manager I have ticks next to:

Report Server Virtual Directory
Report Manager Virtual Directory
Windows Service Identity
Database Setup
Email Settings
Execution Account

But have crosses next to:
Server Status
Web Service Identity
Initialization

and an exclaimation mark next to encryption keys.

On the Database setup page, what should the credentials type be set to? and also how about the execution account?|||

Dear,

On the database setup page the credential should be set to service credentials.

Leave the exection account and email seeting this time first start the reporting services.

Delete the encription keys.

Tell me onething do u have namedstance installed on the server.

Regards

sufian

|||

Hi there. If I understand correctly, you are using win2K, with SQL 2k5, and want to get Reporting Service to Start? (And this is a fresh install?)

have you seen this ? http://support.microsoft.com/default.aspx/kb/911846

It says that you should make your Rsreportserver.config file's <WebServiceAccount></WebServiceAccount> tag the IWAM_ComputerName for windows 2000.

Hope This helps

-Hoovie

P.S. Is you Server a Domain Controler? "For more information about potential problems running version 1.1 on a domain controller, see article Q824308, "IWAM Account is Not Granted the Impersonate Privilege for ASP.NET 1.1 on Windows 2000 Domain Controller with SP4," in the Microsoft Knowledge Base at http://support.microsoft.com. For more information about running version 1.0 of the .NET Framework on a domain controller, see article Q315158, "ASP.NET Does Not Work with the Default ASPNET Account on a Domain Controller," in the Microsoft Knowledge Base at http://support.microsoft.com."

reporting service client and column selection

can I use excel as a client for my reporting service? I see some docs on it,
but can't find the actual product. I want the user to be able to select what
column to be displayed. Is that possible now? how about sql 2005.Reporting Services 2000 can export to Excel format.
Reporting Services 2005 can too.
Office 12 (due in about a year?) has some additional Business
Intelligence functionality. There isn't much public yet about what
that will consist of, but it looks likely that Excel will do some
interesting things with Analysis Services information.
Can you elaborate on your column-related question? I am not sure
precisely what you are asking.
Thanks
Andrew Watt
MVP - InfoPath
On Fri, 14 Oct 2005 11:55:02 -0700, NewSPUser
<NewSPUser@.discussions.microsoft.com> wrote:
>can I use excel as a client for my reporting service? I see some docs on it,
>but can't find the actual product. I want the user to be able to select what
>column to be displayed. Is that possible now? how about sql 2005.|||I don't mean export, I mean using excel directly connect to a reporting
server. basically, excel acting as a fat client.
column selection: if the report dispaly a table which consists of 10
columns, however, some user may not be interested in seeing all 10 columns.
Can the end user have the ability to hide/collapse that column? i.e. make the
report to display 5 columns instead of ten.
"Andrew Watt [MVP - InfoPath]" wrote:
> Reporting Services 2000 can export to Excel format.
> Reporting Services 2005 can too.
> Office 12 (due in about a year?) has some additional Business
> Intelligence functionality. There isn't much public yet about what
> that will consist of, but it looks likely that Excel will do some
> interesting things with Analysis Services information.
> Can you elaborate on your column-related question? I am not sure
> precisely what you are asking.
> Thanks
> Andrew Watt
> MVP - InfoPath
> On Fri, 14 Oct 2005 11:55:02 -0700, NewSPUser
> <NewSPUser@.discussions.microsoft.com> wrote:
> >can I use excel as a client for my reporting service? I see some docs on it,
> >but can't find the actual product. I want the user to be able to select what
> >column to be displayed. Is that possible now? how about sql 2005.
>|||I don't know precisely what BI in Office 12 will consist of but I
would expect to see more off-the-shelf functionality/integration of
SQL Server (2005?) BI apps with Office apps, including Excel then.
I believe you can use Excel (not sure which versions) to connect to a
Web Service. Since RS has a Web Service it should be possible to
produce a custom Excel app if you have the relevant VBA etc skills.
It's not something I have explored in detail.
Andrew Watt
MVP - InfoPath
On Sat, 15 Oct 2005 17:20:23 -0700, NewSPUser
<NewSPUser@.discussions.microsoft.com> wrote:
>I don't mean export, I mean using excel directly connect to a reporting
>server. basically, excel acting as a fat client.
>column selection: if the report dispaly a table which consists of 10
>columns, however, some user may not be interested in seeing all 10 columns.
>Can the end user have the ability to hide/collapse that column? i.e. make the
>report to display 5 columns instead of ten.
>"Andrew Watt [MVP - InfoPath]" wrote:
>> Reporting Services 2000 can export to Excel format.
>> Reporting Services 2005 can too.
>> Office 12 (due in about a year?) has some additional Business
>> Intelligence functionality. There isn't much public yet about what
>> that will consist of, but it looks likely that Excel will do some
>> interesting things with Analysis Services information.
>> Can you elaborate on your column-related question? I am not sure
>> precisely what you are asking.
>> Thanks
>> Andrew Watt
>> MVP - InfoPath
>> On Fri, 14 Oct 2005 11:55:02 -0700, NewSPUser
>> <NewSPUser@.discussions.microsoft.com> wrote:
>> >can I use excel as a client for my reporting service? I see some docs on it,
>> >but can't find the actual product. I want the user to be able to select what
>> >column to be displayed. Is that possible now? how about sql 2005.
>>

Reporting Service Client

I am asked to install Microsoft SQL Server 2000 Reporting Service Client on
user's desktop. I loaded the CD (Microsoft SQL Server 2000 Reporting
Services) on my desktop, it says:
1. IIS is not installed.
2. ASP.NET is not installed.
3. Visual Studio.NET is not installed.
My question is: Is there a standalone Reporting Service Client I can install
on any user's desktop to access Reporting Servcie Server? Why it asked
IIS/ASP.NET/Visual Studio.NET to be installed on desktop?To access RS and view the reports the client only needs IE. To use the
Report Designer to author (create) reports in the RDL and to publish the
reports to the report server, the client requires the entries you listed
from the RS prerequisites.
HTH
Jerry
"renhai" <renhai@.discussions.microsoft.com> wrote in message
news:1417D98F-53D7-4C45-A50C-A3719C98E7EA@.microsoft.com...
>I am asked to install Microsoft SQL Server 2000 Reporting Service Client on
> user's desktop. I loaded the CD (Microsoft SQL Server 2000 Reporting
> Services) on my desktop, it says:
> 1. IIS is not installed.
> 2. ASP.NET is not installed.
> 3. Visual Studio.NET is not installed.
> My question is: Is there a standalone Reporting Service Client I can
> install
> on any user's desktop to access Reporting Servcie Server? Why it asked
> IIS/ASP.NET/Visual Studio.NET to be installed on desktop?

Reporting Service

I am trying to write a win app that will display the list of reports on a server that a given user id has access to. For example, if there are 150 reports on a server, how to tell which reports loginA has access to. I can get the list of reports, but I am not sure how to get the security information for each report. Anyone have any ideas?

R

Hi Ron,

Take a look at the ListChildren SOAP method. I believe it does exactly what you are looking for.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_2yt2.asp

|||

I am using that, and I am getting the report listing. The trouble is I want to know what login has access to which reports. ListChildren doesn't do this and I am REALLY trying not to directly access the RS database. I am assuming that the Profile related tables have the info I want.

R

Reporting Server user access

Hi,
I'm having problem with the authentication in reports. When a user sign
in to Report Administrator or Report Server validates with the IIS'
configuration. Onces inside always use the same user with the rules
security: IWAM_machine.
I need the account used inside of Reporting Server/Reporting Administration
should be the same that the account used to validates with IIS.
It's possible'
Thank you in advanced.
OliverUsually this is because anonymous is set on the IIS web site settings.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"oli" <oli1350@.hotmail.com> wrote in message
news:eHPoJtZZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm having problem with the authentication in reports. When a user sign
> in to Report Administrator or Report Server validates with the IIS'
> configuration. Onces inside always use the same user with the rules
> security: IWAM_machine.
> I need the account used inside of Reporting Server/Reporting
> Administration
> should be the same that the account used to validates with IIS.
> It's possible'
> Thank you in advanced.
> Oliver
>|||I've configured the IIS with only windows authentication, when i connect to
Reporting Server or Reporting Administrator uses the windows account, but
the security rules work different:
I have configured rules for two accounts: my windows account and
IUSR_machine.
When i try to connect to servers i put my windows account and goes ok, but
the security rules works with the rules assigned to the iusr_machine. Any
rule assigned to my user doesn't have effect, and all the changes makes in
the IUSR_machine's rules have effect.
I've configured restrict access to the iusr_machine and grant permission for
my windows account. When i connect with my windows account and i try to do
any task that iusr_machine haven't permission, the server response me that
the iusr_machine haven't permmission to do it.
Any idea?
thank you.
Oliver
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> escribió en el
mensaje news:OT0ifxqZEHA.212@.TK2MSFTNGP12.phx.gbl...
> Usually this is because anonymous is set on the IIS web site settings.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "oli" <oli1350@.hotmail.com> wrote in message
> news:eHPoJtZZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> > I'm having problem with the authentication in reports. When a user
sign
> > in to Report Administrator or Report Server validates with the IIS'
> > configuration. Onces inside always use the same user with the rules
> > security: IWAM_machine.
> > I need the account used inside of Reporting Server/Reporting
> > Administration
> > should be the same that the account used to validates with IIS.
> >
> > It's possible'
> >
> > Thank you in advanced.
> >
> > Oliver
> >
> >
>