Showing posts with label aspx. Show all posts
Showing posts with label aspx. Show all posts

Monday, March 12, 2012

Report Manager Not Working

I am suddenly unable to access report manager :
http://localhost/ReportManager/Pages/Folder.aspx
I am getting the error :
Could not find file "C:\WINDOWS\TEMP\_cm2qpki.dll".
The name of the DLL is different each time I try, but the end result
is the same. I can't find much on this. What I did find indicates a
lack of permission. I have tried accessing it with a couple of
different accounts (both were administrators on the server) and
security methods (anonymous access w/ an admin account, integrated
windows , digest, and basic authentication). I still get the same
error. This is Windows 2003 server, and SQL 2000. Any ideas? Thanks in
advance.
EricDOH!
I must have searched the web for an hour and a half for this. As soon
as I posted this I found the solution right here on Google groups:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/9f7ef9267b35eb5c/300a9da8cb33b9f7?lnk=gst&q=Report+manager+%22could+not+find+file%22+temp&rnum=1#300a9da8cb33b9f7

Report Manager error

I am able to view reports by navigating directly to /ReportServer however the
report manager (/Reports/Home.aspx) gives the following:
ERROR.
Object reference not set to an instance of an object.
No other info is provided. I'm using SSL and RS SP2 is installed, SQL has
SP4. I've looked in the Reporting Services Log files but I don't see
anything there to help trap this error.
What "object" might this be? Any ideas about how to debug this?
Thanks,
Jeff Munson
University of WashingtonMaybe this will help someone?
When I hit https://localhost/SQLReports/Pages/Folder.aspx from the web
server itself and view source here is what's displayed in the HEAD tag:
(Note that the virtual directories are actually SQLReports and
SQLReportServer - this wasn't how I labelled them in my first post)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD> <script language="JScript" type="text/Javascript"
src="/SQLReports/js/ReportingServices.js"></script>
<TITLE>Report Manager</TITLE>
<link href="http://links.10026.com/?link=/SQLReports/styles/ReportingServices.css"type="text/css"
rel="stylesheet">
<META Name='Generator' CONTENT='Microsoft SQL Server Report Manager
8.00.1038.00'>
<META Name='Report Server' CONTENT='http://MYDOMAIN/SQLReportServer'>
<META Name='StackTrace' CONTENT='System.NullReferenceException: Object
reference not set to an instance of an object.
at
Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetReportServerAuthentication()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetWebRequest(Uri
uri)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()'>
"JMunson" wrote:
> I am able to view reports by navigating directly to /ReportServer however the
> report manager (/Reports/Home.aspx) gives the following:
> ERROR.
> Object reference not set to an instance of an object.
> No other info is provided. I'm using SSL and RS SP2 is installed, SQL has
> SP4. I've looked in the Reporting Services Log files but I don't see
> anything there to help trap this error.
> What "object" might this be? Any ideas about how to debug this?
> Thanks,
> Jeff Munson
> University of Washington