Several IIS Per One ReportServer Database

May 14, 2007

Hello!

Is it possible to make reporting services use several IIS instances which share one common ReportServer database?

Thanks.

View 1 Replies

Reportserver Is Asking For Username And Password Everytime I Call Http://servername/reportserver

Dec 2, 2006

Please help everytime i call http://servername/reportserver it is presenting the login screen, if i enter the username and password then i can access the reportserver screen, same with reportmanager tool.

under iis manager for the reportserver virtual directory i have given anonymous login access.

do i have to set any other extra permissions other than anonymous login(iusr_machinenname)

thank you all for the information.

View 6 Replies View Related

ReportServer - Http://localhost/ReportServer - Error

Mar 25, 2006

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Object reference not set to an instance of an object.

And my ReportServer log:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Standard Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServer__03_24_2006_16_45_06.log</Path>
<SystemName>USPROFILING</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!webserver!1!3/24/2006-16:45:06:: i INFO: Reporting Web Server started
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing ConnectionType to '1' as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!3/24/2006-16:45:06:: i INFO: Reporting Services starting SKU: Enterprise
w3wp!resourceutilities!1!3/24/2006-16:45:06:: i INFO: Evaluation copy: 0 days left
w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!03/24/2006-16:45:06:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()
at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
--- End of inner exception stack trace ---
w3wp!library!1!03/24/2006-16:45:09:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!03/24/2006-16:45:11:: i INFO: Catalog SQL Server Edition = Enterprise
w3wp!library!1!03/24/2006-16:45:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()
at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
--- End of inner exception stack trace ---
w3wp!library!1!03/24/2006-16:45:14:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson

Any help would be appreciated:

System 2003 Server IIS6 and Sql2005 enterprise all housed on Virtual Server. all housed locally.

View 12 Replies View Related

ReportServer Database Replication?

Feb 14, 2008

I'm working on an application for a client. The application is distributed to 100 mobile (SQLExpress SP2 w/ Advanced Services) users via the web, and uses merge replication to sync data back to corporate with Web Synchronization.

All of this works great. No problems at all.

The client now wishes to use the Reporting Services component of SQL to deploy reports, rather than building them into the application with Crystal Reports. The rationale is it will require less work (probably true to some degree) and it will make updates easier since each time they add a report, it will not require regenerating an entire binary image of the application for users to download.

Naturally, the client asks me if there is a way to use the same replication technology to simply build the reports in-house against an internal ReportServer database, and then replicate the contents of that database down to those 100 clients with the same merge replication -- except, making it a "one way" subscription, with no updates sent back to the server.

I'm wondering if anyone has attempted to do something along these lines.. Is it possible to use SQL Server replication technology to replicate the Reporting Services database down to mobile clients?

Or... is there some other mechanism I should be investigating that will allow me to deploy and update roughly 200 reports to 100 mobile clients on a regular basis?

Thoughts from other users would be appreciated.

I've tried using replication for the past few days, but have had no success. I have created a publication and subscription, have managed to pull the data down and build the local database, but when I do so, Reporting Services immediately breaks. I've even attempted to limit the data I pull down to simply the Catalog, Datasource, and Chunk tables (eliminating what appears to be the other tables that contain site-specific configuration data), with no success.

If anyone has tried something similar, or has managed a similar application, feedback would be appreciated.

-MD

View 5 Replies View Related

Reconstructing RDL From The ReportServer Database

Apr 5, 2007

In my shop we hired a contractor who build our SQL Server 2005 Reporting Services reports on his laptop. After a tiff between him and our manager, he left with the laptop and we no longer have the source code for these reports. We have backups, but not the latest.

These reports ARE deployed to our production server, but I need to know if it's possible to reconstruct the RDL for the reports from the database contents. I understand that the report contents are encrypted and I'm guessing the RDL is in the Catalog.Content column.

Is there a way to recover the RDL for deployed reports or do we have to resort to the legal system?

View 7 Replies View Related

How To Get The RDL Back From The ReportServer Database?

Feb 8, 2008

Hi,

I have a report deployed and working. Now I need to change it but I lost the source (RDL).

Can I get the RDL back from the reportServer database? How?

Help is really appreciated

Tks in advance,
DD

P.S: I'm Using SQL Server 2000

View 3 Replies View Related

Querying Reportserver Database

Mar 24, 2008

Hi everybody,
Our SRS reporting security model had to be designed so that the access is by individual report basis and by user. I cannot give access to individual reports based on windows AD group. Because everybody in that group does not need to have access to a particular report. Two people from one AD group needs access to say Report1. Only one person need to have access to Report2 etc.... Creating lot of AD groups for the security is also not advisable.

Right now I can tell right away users having access to a particular report as the number of reports and the users is small. But I want to design a report that can give me a list of users who have access to a specific report.
How do I query the reportserver database to get this information. I mean is this information saved in any of the tables?
Can you please give any info that you know of such information?
Thank you in advance for all your help,

View 5 Replies View Related

Copying The Reportserver Database..

May 2, 2007

Is it possible to copy a reportserver database from one sql server to another without problems?

Has anyone done this?

View 2 Replies View Related

Editing The Sys Built ReportServer Database

Feb 21, 2008

BACKGROUND:
When SQL Server 2005 w/ SSRS2005 was installed, a database named "ReportServer" was created by the system. I use the tables in this database to generate audit/statistical reports primarily hitting the dbo.ExecutionLog & dbo.Subscriptions tables for analyzing server activity.

QUESTION:
Can I modify the tables in the system built "ReportServer" database? Or, will RS stop working? Also, if i modify the tables will it prevent an update?

DETAILS:
As for the Subscriptions table, I want to add the Field "LastRunTime" as a PK so all the history will be storeded. Curently, this table only stores the last subscription that was sent and gets over written when a that subscription is sent out again. Or, is there another way to store all history?

As for the ExecutionLog table, it only stores data for 60 days. I want to store all history. Is this possible?

All comments & suggestions are welcome & I look forward to all your respoonces!

-Jeff

View 4 Replies View Related

Unable To Connect To ReportServer Database

Feb 6, 2008

Hi!

I am in the process of installing and configuring Reporting Services and have run across a problem... I created a domain user to run the service, configured the virtual directories and created the database using this domain user. However when I browse to http://localhost/Reports I get the following error:

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help

Cannot open database "ReportingServices" requested by the login. The login failed. Login failed for user 'DOMAINuser'.

This is totally weird, since I've given the user every possible right in SQL Management Studio... I even tried giving it Administrator rights, to no effect. I can do a remote dekstop connection to the machine with this user and connect to the SQL server using the Management Studio and windows authentication just fine... Something I've missed?

View 9 Replies View Related

Database 'ReportServer$SQLExpressTempDB' Cannot Be Opened

Jul 23, 2007

When I try the open the report file, I got the following error message. Database 'ReportServer$SQLExpressTempDB' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. Anyony have ideas to fix this error?

View 3 Replies View Related

Reportserver Database Table Definitions

Feb 15, 2008

Where can i find more information on the table definitions? I am trying to understand the definition of User.AuthType & User.UserType. There should be some sort of documentation somewhere.

When I add a user to a report or folder it will assign it to UserType = 1, AuthType = 3. I have no idea what that means.

Any ideas?

View 3 Replies View Related

Http://localhost/reportserver Works Http://&&<servername&&>/reportserver Doesn't

Aug 1, 2007

Hi All,

I have setup SSRS 2000 and gotten it to work but I am having trouble with SSRS 2005. I can't access to reportserver anywhere on the network. The only way to get to reportserver is termserv into the server and hit it with http://localhost/reportserver The server is Windows 2003 server Standard Ed. running SQL 2005 SP2 and Sharepoint Portal Server 2007. Can somebody please help? Thank you.

View 11 Replies View Related

ReportServer

Sep 14, 2007

I want to create ReportServer which processes crystal report and sybase database using c#. Particulary this report server
get parameters from user and process this report send it back to user additional also send email,print,ftp etc... Also report server should be able to schedule reports as per user request.
Does microsoft gives any classes /services to start programming for this?? Any suggestion or Any Idea ??
thanks for looking into this..

View 6 Replies View Related

ReportServer

Feb 20, 2008

When I publish a reportsapplication from vs2008 to http://myserver/reportserver/reportapplication7 I get this error:

Code Snippet
Error 1 Failed to connect to 'http://myserver/reportserver/reportsApplication7/' with the following error: Unable to create the Web site 'http://malachi/reportserver/reportsApplication7/'. Server error: You cannot convert a virtual directory into a subweb remotely. Ask your web server administrator or ISP to do this for you. 1 1 ReportsApplication7

The website ReportServer is the one that sql server 2005 > Config Tools> Reporting Server Configuartion created.

How do I correct the problem?

View 4 Replies View Related

Copy .rdl From ReportServer

May 6, 2008

I have a report on the ReportServer that I need to copy to my local computer. It was not saved in SourceSafe. Is there a way to get the .rdl file for that report copied to my computer from the ReportServer?
I have googled the topic but no sites come close to what I want.

Thanks in advance!

View 15 Replies View Related

Use Of ReportServer Service ?

Apr 10, 2007

Hi,
I used to think ReportServer service running for reporting is essential for reporting service work but today I stopped this service and tried to access reports....they were working fine ...can somebody explain me why its working so fine ?? even I stop it ?

I am very much confused ....
thanks
prashant

View 2 Replies View Related

ReportServer Project

Jun 1, 2007

I am getting the following problem when I try to build the ReportServer Project:----------------------- Build started: Project: Report Project9, Configuration: Debug ------Error: Value cannot be null.========== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped ==================== Deploy: 0 succeeded, 0 failed, 0 skipped ==========-----------------But in the report preview, report display correctly. Plz. suggest me what should i have to do.

View 2 Replies View Related

ReportServer Website

Feb 13, 2007

Ok, I have this up and running thanks to the help of lots of users in this forum (Thank You again)

I deployed some reports, and everything looks fine, however to add another twist to this, I would like the website to look prettier, by adding something like a welcome page,and some folders and such.

Does anyone have any ideas on how to do that ??? DO you have any material or a website, where I can get some info ??

Thanks

View 1 Replies View Related

ReportServer And Dynamics CRM 3.0

Aug 30, 2006

hi all

i'm currently installing MS Dynamics CRM 3.0. on the check page before installing is an error:
The Web Site for Installing SQL Server Reporting Services {0} uses an application pool of non-supported identity. Supported identity is Network Service.

so, when i open the properties (tab identity) of the reportserver under application pools in iis manager prefered "Network Service" is choosen, this should by right. do i made any failure? have anyone an idea, tanks

dear
riv

View 4 Replies View Related

Restore ReportServer

Jul 24, 2007

I keep getting this message when i try and restore the ReportServer "system.data.sqlclient.sqlerror: Exclusive access could not be obtained because the database in in use"

All the other databases restored successfully.

Any ideas?

View 1 Replies View Related

Help With Accessing Reportserver With Web Browser

Apr 25, 2007

I am using sql express w/ advanced services on xp pro with IIS 5.1 installed. On the local machine named 'Tester' i am able to access reportserver using a web browser and the url: http://localhost/reportserver. But when i go to another machine on the same network and domain and try to access the reportserver with url: http://Tester.domain/reportserver or http://<ip address of Tester>/reportserver ie tells me page cannot be found and does not give me any errors. How do I set up network access to reportserver on the machine Tester? Help would be greaty appreciated.

View 1 Replies View Related

How Can I Rename My ReportServer Databases?

Oct 12, 2007

Hi,

I am trying to move my Reporting Services databases from one server to another one. On the old server there was only a single instance so my databases were named ReportServer & ReportServerTempDB. On my new server I have multiple instances and, after installation (which I didn't perform), the databases on the new server are ReportServer$SQL_VS11 & ReportServer$SQL_VS11TempDB.

I was able to successfully restore both databases and rename them at the time of restore and also restore my encryption key but now when I try to view one of the reports I'm given the error:

Invalid object name 'ReportServerTempDB.dbo.PersistedStream'.

I found this article:

http://technet.microsoft.com/en-us/library/ms159093.aspx

It states that "This error occurs because the ReportServerTempdb name is stored internally and used by stored procedures to perform internal operations. Renaming the temporary database will prevent the stored procedures from working properly."

This leads me to believe that what I'm attempting to do is not possible. I asked the developer in charge of the reports if we could simply republish but he informed me that we would lose history in this case. I may have to simply leave the old database names alone which would be inconsistent with our corporate naming schemes. Can anyone offer a suggestion?

Thanks,
Pat Brickson

View 6 Replies View Related

Http://localhost/reportserver

Feb 10, 2008

Hi. Does anybody know why I'm getting the following error when I go to http://localhost/reportserver in a browser? is there a problem with how to setup permission or Windows Vista?

Server Error in Application "Default Web Site"

HTTP Error 404.0 - Not Found

Description: The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

Error Code: 0x80070002

Notification: MapRequestHandler

Module: IIS Web Core

Requested URL: http://localhost:80/reportserver

Physical Path: C:inetpubwwwroot
eportserver

Logon User: Anonymous

Logon Method: Anonymous

Handler: StaticFile

Most likely causes:

The directory or file specified does not exist on the Web server.
The URL contains a typographical error.
A custom filter or module, such as URLScan, restricts access to the file.

What you can try:

Create the content on the Web server.
Review the browser URL.
Create a tracing rule to track failed requests for this HTTP status code and see which module is calling SetStatus. For more information about creating a tracing rule for failed requests, click here.

More Information... This error means that the file or directory does not exist on the server. Create the file or directory and try the request again.

Server Version Information: Internet Information Services 7.0.

View 5 Replies View Related

ReportServer DB And ReportServerTempDB Databases

Feb 9, 2007

Hi all,

Is it possible to cleanup ReportServer DB and ReportServerTempDB by setting the time interval ? For example, I want data in these two dbs to be deleted automatically after 5 or 10 minutes. How can I do that because as new reports are added and executed data goes on increasing in very short time and hurts performance.

Thanks,

Prashant

View 5 Replies View Related

Sharepoint Needed For ReportServer?

May 9, 2007

Dears,

I have XP Professional and my IIS is installed and works fine because i can browse to http://localhost.

But when I go to http://localhost/ReportServer, I get the error below:

"Server Application Unavailable" The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request. Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur."I've struggled almost a day with it, researched on the internet and so on.... Is it possible that this is because I don't have Sharepoint Services installed????

And SharePoint services is not standard in Windows XP Professional????
So I can not use the ReportServer????

View 7 Replies View Related

Index Tuning : ReportServer DB

Nov 1, 2007

Hi All!

I would like to try and increase the performance of the reportserver database. Im thinking of adding an index to dbo.catalog.itemID - before I break the database and subsequently kill the 200+ reports i spent ages writing, does anyone know of any problems doing this?

The reports seem to be a bit slow first run but speed up during the course of the day - the server generates about 1500 instances of reports each day (7 instances of reportmanager all pointing to the reportserver db). I primarily use precompiled storedprocedures to feed the datasets so this is why im thinking index tuning may help.

Any thoughts/comments are welcomed!

View 2 Replies View Related

Moving ReportServer Databases

Apr 17, 2007

Followed the steps in Books Online to move the Reporting Services databases from one server to another. After resetting all the keys and configurations, the site comes up. However, all my shared datasources have lost their connection strings, and have reverted to requesting login information. Is this how it is supposed to work? If not, how do I fix this easily (as I have about 25 data sources)?

View 4 Replies View Related

Unable To Connect To Reportserver?

Mar 8, 2007

Hi,

I am unable to connect to report server.

but on Report server Configuration it showing Report server is properly initialized.

If i try to connect on SQL management studio. it showing this error message

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>

<body bgcolor="white">

<span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>

<h2> <i>Configuration Error</i> </h2></span>

<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>

<b> Parser Error Message: </b>An error occurred loading a configuration file: Failed to start monitoring changes to 'C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer' because access is denied.<br><br>

<b>Source Error:</b> <br><br>

<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>

[No relevant source lines]</pre></code>

</td>
</tr>
</table>

<br>

<b> Source File: </b> C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerweb.config<b> Line: </b> 0
<br><br>

<hr width=100% size=1 color=silver>

<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

</font>

</body>
</html>

--. (Microsoft.SqlServer.Management.UI.RSClient)

can any one help me to solve this problem.

Thank you

View 3 Replies View Related

Cannot Connect To Reportserver From Outside Of Network

Oct 12, 2007

I am able to connect to reportserver from within the network. However I am unable to connect to reportserver from outside of network.

I am using the syntax http://xxx.xxx.xxx.xxx:1433/reportserver where xxx.xxx.xxx.xxx denotes the ip adress and the 1433 denotes the port

Reportserver is on a windows 2003 small business server. I added exceptions to my firewalll and checked all permissions to the physical directories. I am sure it is a simple issue but cannot figure it out.

Any help would be appreciated.

Thanks.

View 2 Replies View Related

ReportServer Site Error

Mar 20, 2007

Hi, i installed SQL Server with Reporting Services... when i try to access the ReportServer website i get this error. Can someone help me?

Server Error in '/ReportServer' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:inetpubwwwrootweb.config' because access is denied.

Source Error:

[No relevant source lines]
Source File: c:inetpubwwwrootweb.config Line: 0

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

If you see, it says that the source file is "c:inetpubwwwrootweb.config" but my ReportServer document root is in other place, i've tried coping the web.config file to wwwroot, but nothing.

View 8 Replies View Related

IIS 6 MMC Problem With ReportServer And ASP.NET Configuration

Feb 14, 2006

Hello,

I had a working Report server till I did the following:

- Go to IIS 6 MMC

- Display Reportserver vs properties

- click on the ASP.NET tab (2.0 50727)

- click on the "Edit Configuration" button

- Look at the config, do not change nothing

- Click OK

This has kill the Report server, it is now giving an error:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Object reference not set to an instance of an object.

Just to see, I did the exact same thing on another test machine and it did screw up the report server as well.

Any idea on how I can fix, this? I tried to repair ASP.net 2 and uninstall reinstall IIS6 as well as deleting and recreating the reports and reportserver vs.

Thanks

Philippe

View 23 Replies View Related

WSS-based ReportServer URL Parameters

Mar 5, 2007

Hi all,

I'm trying to pass parameters in a URL to a report deployed to a report server that has been migrated to WSS using SP2.I can call the report itself with no problems but am having trouble duplicating the ability to pass URL parameter values in a similar fashion to an unmigrated reportserver. I am sure I'm just missing a few differently placed question marks or ampersands. So far I haven't found any doco which gives me the specific format & rules for URL parameter passing and how it may have changed.

This URL will run the report:
http://bi-vpc/Reports/ReportsLibrary/MyReport.rdl

I just need to figure out how to pass in values for the two parameters: Date and Country.

Any and all help/suggestions much appreciated.

Cheers,
Nick

View 8 Replies View Related