Reporting Services :: JIT Debugging Error When Reporting Configuration Manager Is Opened
Sep 11, 2015
We have installed SQL Server 2005 with reporting services.When tried to open getting errors as below: how to avoid such errors See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has occurred and no additional error information is available. ---> System.Runtime.InteropServices.COMException (0x8000000A)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
[code]...
View 4 Replies
ADVERTISEMENT
May 24, 2006
Hello
I've got an error when I want to initialize the Report Server by means of RS Configuration Manager.
All points are check in green except "Encryption Keys" that is in "Optionnal configuration" and "Initialization" that is in "Not Configured".
When I click on "Initialization" an error occured :
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)
When I want to browse the report this error occured:
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) (rsRPCError). Cannot generate SSPI context.
Someone can help me ?
Thanks
Arnaud
View 3 Replies
View Related
Jan 11, 2008
I am attempting to set up SQL 2005 reporting on my local system. When I get to the "Initialization" step I get the following error:
ReportServicesConfigUI.WMIProvider.WMIProviderException: Keyset does not exist (Exception from HRESULT: 0x80090016)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)
Can anyone provide assistance or suggestions on resolving this error? Many Thanks!!
View 2 Replies
View Related
Jul 4, 2007
Hi,
I've a slight problem with configuring my Report Server. I have set up everything apart from the initialisation and and the Windows Service Identity, however when I select the panel for the latter I am presented with a message box displaying the following:
" Reporting Services Configuration Manager:
There was an error while switching panels. The most likely cause is an error retreiving WMI properties. The exception details are:
InvalidArgument=Value of '1' is not valid for 'SelectedIndex'.
Parameter name: SelectedIndex "
I have tried re-installing the entire SQL server setup and this made no difference, I followed this by removing then reinstalling just the Report Service. Still nothing.
Any ideas as to what it is doing and how I should go about fixing it?
Sim
View 4 Replies
View Related
Aug 12, 2007
Hi,
I've installed SQL 2005 on a Windows 2003 R2 Server, I also installed another Web Server (Another Windows 2003 R2 Server) on a different machine.
I've installed the Reporting Services on the Web Server.
When I am trying to configure the report server, I successfully created the Virtual Directories, but when trying to do the "Database Setup" step, I am getting an error on the "Create a Grants Rights Script", with this message:
System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String dbServer)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String connectionString, String server, String database, ConfigurationCredentialsType credsType, String account, String password, Boolean upgrade, String dbVersion)
As a result, I cannot run the reports nor get to the folder.aspx page on the manager side of the application.
I am getting this HTML msg:
The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) Get Online Help
When installing the Reporing Server on the SQL Server machine, it works with no problems, and I am doing everything the same.
Would appreciate your help, I've been working on this for few days with no luck.
Thank you!
Yaniv.
View 4 Replies
View Related
Oct 29, 2015
While migrating Report services in SQL Server 2005 to 2014, I am trying to restore the Encryption Key in RS Configuration Manager in2014. But I cannot click the 'Restore' button in RS Configuration Manager. So if I should be grant more right to do so or any other action?
View 2 Replies
View Related
Mar 12, 2007
Hi There,
Our DBA has installed reporting services on a server and now in order to access the report manager, one has to be an Admin on that Server. I am guessing that there is a mistake in the configuration of Reporting Services. Usually it should allow anybody who was added to the roles in the properties section of the Report Manager, right? I have also added the users to the DB..
Also I am using Windows Authentication to access Report Catalog items (Reporting Services is installed on Server2) from a web Application(deployed on Server1) and displaying the report using report viewer. For some reason, server1 has to be in an Admin role on Server2 to access the report catalog/report. This is kinda strange for me as I don't want everybody to be an Admin on Server2. Can anybody please point in the right direction?
Thanks.
View 3 Replies
View Related
Jan 27, 2008
Hi,
I have problem during first configuration of Reporting Services from MS SQL 2005 Server Express with Advanced Services SP2. The error occurs when configuring virtual directory (Reporting Services Configuration Manager -> Report Server Virtual Directory). When I try to create new virtual directory I can see following messages:
Number of errors: 0
Create Virtual Directory
The virtual directory was created and assigned.
Changing Secure Connection Level
After last message Windows reports that SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close (and I can send report to Microsoft).
IIS shows that virtual directory under default web site was created.
Evenet viewer (application log) shows .NET Framework 2.0 error:
EventType clr20r3, P1 rsconfigtool.exe, P2 9.0.3042.0, P3 45cd6ee2, P4 rsconfigtool, P5 9.0.242.0, P6 45cd6ee2, P7 15a, P8 5, P9 system.nullreferenceexception, P10 NIL
My environment:
MS SQL Reporting Services Version 9.00.3042.00
Windows XP Proffessional SP2
IIS 5.1
all components are fresh new installations. The only additional configuration I've made was adding IWAM_<hostname> as WebServiceAccount, all other configuration is default.
Any help would be appreciated.
Best regards
Slawomir Nasiadka
View 2 Replies
View Related
Nov 6, 2007
I've SQL Server Reporting Services 2005 configured on my system, but now I'm NOT Able to start the report server. I get this error on http://<serverurl>/Reports/Home.aspx:
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)
Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)
I don't want to loose any data. Please help me resolving this error.
FYI, I've modified the SQL Reporting Services account LogOnAs info, in Properties of "SQL Server Reporting Services (MSSQLSERVER)" Service, in Windows Service Managment.
Earlier I had .useraccount as username, I modified it to domainnameuseraccount. And then suddenlt everything broke for reporting server.
View 4 Replies
View Related
Sep 14, 2007
Yesterday, literally I was banging my head to the wall, kept getting this error:
A Connection could not be established with the information provided. Hit OK to change your connection settings.
Invalid object name 'sysdatabases'.
I uninstall and re-install back the reporting services couple times and I kept getting the same error.
I have 2 instances of SQL Server on the same Server:
SQL Server 2000
SQL Server 2005
The 2 instances work side by side, I was wondering if this causing the error.
Can anyone help out with this problem?
Thanks - John
View 9 Replies
View Related
May 20, 2008
Hi,
I am getting an error:
1. While connecting to the Reporting Services Engine (Using SQL Server Management Server). The error message is given below. Report Server is working fine, I am able to browse the reports from the report server.
------------------------------------------------------------------------------------------------------------------------------------------------------------
TITLE: Connect to Server
------------------------------
Cannot connect to BTP8NMB03.
------------------------------
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<HTML dir="ltr">
<HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; charset=utf-8" /><meta HTTP-EQUIV="Expires" content="0" /><meta name="ROBOTS" content="NOHTMLINDEX" /><title>
Error
</title><link rel="stylesheet" type="text/css" href="/_layouts/1033/styles/core.css?rev=5msmprmeONfN6lJ3wtbAlA%3D%3D"/>
<script type="text/javascript" language="javascript" src="/_layouts/1033/init.js?rev=VhAxGc3rkK79RM90tibDzw%3D%3D"></script>
<script type="text/javascript" language="javascript" src="/_layouts/1033/core.js?rev=F8pbQQxa4zefcW%2BW9E5g8w%3D%3D"></script>
<meta name="Robots" content="NOINDEX " />
<meta name="SharePointError" content=""/>
</HEAD>
<BODY scroll="yes" onload="javascript:if (typeof(_spBodyOnLoadWrapper) != 'undefined') _spBodyOnLoadWrapper();">
<form name="aspnetForm" method="post" action="../_layouts/error.aspx" id="aspnetForm" onsubmit="return _spFormOnSubmitWrapper();">
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKLTU2NjkxODU3M2RkLuL1ujv9xB7yocvKanNE0G4cIn0=" />
<TABLE class="ms-main" CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%" HEIGHT="100%">
<tr><td>
<table CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%">
<tr>
<td colspan=4 class="ms-globalbreadcrumb" align="right">
<a href="javascript:TopHelpButtonClick('NavBarHelpHome')" id="ctl00_PlaceHolderGlobalNavigation_TopHelpLink" AccessKey="6" title="Help (new window)"><img src="/_layouts/images/helpicon.gif" align="absmiddle" border="0" alt="Help (new window)" /></a>
</td>
</tr>
</table>
</td></tr>
<tr>
<td class="ms-globalTitleArea">
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr>
<td id="GlobalTitleAreaImage" class="ms-titleimagearea"><img id="onetidHeadbnnr0" src="/_layouts/images/titlegraphic.gif" alt="" /></td>
<td class="ms-sitetitle" width=100%>
</td>
<td style="padding-top:8px;" valign=top>
</td>
</tr>
</table>
</td>
</tr>
<TR>
<TD id="onetIdTopNavBarContainer" WIDTH=100% class="ms-bannerContainer">
</TD>
</TR>
<TR height="100%"><TD><TABLE width="100%" height="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="ms-titlearealeft" id="TitleAreaImageCell" valign="middle" nowrap><div style="height:100%" class="ms-titleareaframe"></div></td>
<td class="ms-titleareaframe" id="TitleAreaFrameClass">
<table cellpadding=0 height=100% width=100% cellspacing=0>
<tr><td class="ms-areaseparatorleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=1 alt=""></td></tr>
</table>
</td>
<td valign=top id="onetidPageTitleAreaFrame" class='ms-areaseparator' nowrap width="100%">
<table id="onetidPageTitleAreaTable" cellpadding=0 cellspacing=0 width=100% border="0">
<tr>
<td valign="top" class="ms-titlearea">
<a href="http://btp8nmb03" id="ctl00_PlaceHolderTitleBreadcrumb_idSimpleGoBackToHome">Go back to site</a>
</td>
</tr>
<tr>
<td height=100% valign=top ID=onetidPageTitle class="ms-pagetitle">
<h2 class="ms-pagetitle">
Error
</h2>
</td>
</tr>
</table>
</td>
<td class="ms-titlearearight">
<div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
</td>
</tr>
<TR>
<TD class="ms-leftareacell" valign=top height=100% id="LeftNavigationAreaCell">
<table class=ms-nav width=100% height=100% cellpadding=0 cellspacing=0>
<tr>
<td>
<TABLE height="100%" class=ms-navframe CELLPADDING=0 CELLSPACING=0 border="0">
<tr valign="top">
<td width="4px"><IMG SRC="/_layouts/images/blank.gif" width=4 height=1 alt=""></td>
<td valign="top" width="100%">
</td>
</tr>
<tr><td colspan=2><IMG SRC="/_layouts/images/blank.gif" width=138 height=1 alt=""></td></tr>
</TABLE>
</td>
<td></td>
</tr>
</table>
</TD>
<td>
<div class='ms-areaseparatorleft'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
</td>
<td class='ms-formareaframe' valign="top">
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0" class="ms-propertysheet">
<TR valign="top" >
<TD class="ms-descriptiontext" width="100%">
</TD>
<TD ID=onetidYPadding width="10px"><IMG SRC="/_layouts/images/blank.gif" width=10 height=1 alt=""></TD>
</TR>
<TR >
<TD ID=onetidMainBodyPadding height="8px"><IMG SRC="/_layouts/images/blank.gif" width=1 height=8 alt=""></TD>
</TR>
<tr>
<td valign="top" height="100%">
<A name="mainContent"></A>
<table width=100% border=0 class="ms-titleareaframe" cellpadding=0>
<TR>
<TD valign=top width="100%" style="padding-top: 10px" class="ms-descriptiontext">
<span id="ctl00_PlaceHolderMain_LabelMessage">The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.</span>
<P><span class="ms-descriptiontext">
<span id="ctl00_PlaceHolderMain_helptopic_troubleshooting"><A Title="Troubleshoot issues with Windows SharePoint Services. - Opens in new window" HREF="javascript:HelpWindowKey('troubleshooting')">Troubleshoot issues with Windows SharePoint Services.</A></span>
</span>
</TD>
</TR>
</table>
<script type="text/javascript" language="JavaScript">
var gearPage = document.getElementById('GearPage');
if(null != gearPage)
{
gearPage.parentNode.removeChild(gearPage);
document.title = "Error";
}
</script>
</td>
</tr>
</table>
</td>
<td class="ms-rightareacell">
<div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
</td>
</TR>
<tr>
<td class="ms-pagebottommarginleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
<td class="ms-pagebottommargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
<td class="ms-bodyareapagemargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
<td class="ms-pagebottommarginright"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
</tr>
</TABLE></TD></TR>
</TABLE>
<input type="text" name="__spDummyText1" style="display:none;" size=1/>
<input type="text" name="__spDummyText2" style="display:none;" size=1/>
</form>
</BODY>
</HTML>
--. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
BUTTONS:
OK
------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
2. When I try to connect to the Report Manager. I get the error "The request failed with HTTP status 400: Bad Request."
The log file contains the following information:
-------------------------------------------------------------------------------------------------------------------------------------------------------------
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>India Standard Time</TimeZone>
<Path>D:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerWebApp__05_20_2008_20_12_13.log</Path>
<SystemName>BTP8NMB03</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!5!5/20/2008-20:12:17:: e ERROR: The request failed with HTTP status 400: Bad Request.
w3wp!ui!5!5/20/2008-20:12:17:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 400: Bad Request.
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
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.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!5!5/20/2008-20:12:18:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!7!5/20/2008-20:12:26:: e ERROR: The request failed with HTTP status 400: Bad Request.
w3wp!ui!7!5/20/2008-20:12:26:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 400: Bad Request.
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
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.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!7!5/20/2008-20:12:27:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!1!5/20/2008-20:25:18:: e ERROR: The request failed with HTTP status 400: Bad Request.
w3wp!ui!1!5/20/2008-20:25:18:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 400: Bad Request.
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
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.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!5/20/2008-20:25:19:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Any help in this regard would be appreciated.
Thanks in advance.
Thx,
Datta
View 4 Replies
View Related
Aug 8, 2007
Hello Everyone,
I have installed SQL Server 2005 with Reporting Services on Windows Server 2003. I can run through reporting services configuration and completed all the required steps to initialize it. I can access the reports through //localhost/reportserver and I can also access the reports through Microsoft CRM. But I cannot access the Report Manager (//localhost/reports). I get this Error:
Server Error in '/Reports' Application.
Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLMSoftwareMicrosoftFusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLMSoftwareMicrosoftFusion!EnableLog].
Stack Trace:
[FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +211
System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +141
System.Reflection.Assembly.Load(String assemblyString) +25
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +32
[ConfigurationErrorsException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +596
System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +70
System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +177
System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +180
System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) +3561465
System.Web.Compilation.BuildManager.CompileGlobalAsax() +51
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +462
[HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +57
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +612
System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +521
[HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3540923
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +69
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +275
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
Any ideas? I have done some searching, but could not find any viable solutions. Please Help
Regards,
Ray
View 1 Replies
View Related
Mar 15, 2007
Hi,
I have been trying to get report services installed but another error came:
The feature: "Scale-out deployment" is not supported in this edition of Reporting Services. (rsOperationNotSupported) (rsRPCError)
This error comes when I try to view either http://localhost/Reports or http://localhost/reportserver
Any suggestions?
thank you.
View 2 Replies
View Related
Feb 19, 2007
Hello,
I have installed sql server 2005 along with reporting services... though i am able to design report using business intelligence studio... i am unable to access the report server.... while trying to start the reporting services configuration manager it says no report server found on the specified machine...Invalid Namespace... the installation is local ...
Due to this problem inspite of designing the entire report i am unable to deploy it on the web..since it is asking for a report server...
Can somebody please help me on this...
Thanks in advance...
Nirupa
View 8 Replies
View Related
Jan 25, 2008
When I opened "Reporting Service Configuration Manger" from SQL server configuration tool list, The "Report Server Installation Instance window came out. It showed my local machine name on the field of Machine Name. When I click "Find" button, a message box came out. It says: "No report server were found on the specified machine. Details: Invalid namespace
What is the problem and how to solve it.
View 1 Replies
View Related
May 26, 2015
We have SCCM 2012 primary site and Remote SQL 2012 server. Due to hardening and password reset we are facing reporting issue.
while we Open the SRS report in SQL server and try to edit the Report (Report Builder) we are getting following error due to which we are unable to configure Reporting Service point in the SCCM 2012 server. We created the New Reporting server database still we are getting the below error.
View 14 Replies
View Related
Nov 23, 2006
obviously until I get this sorted I cannot deploy my reports
in my Reporting Services Configuration
All ticked except initialisation (3)
in Database services ticked but on the right hand side there are warnings/errors
Verifying Database Edition - ticked
Verifying Database Version - warning
The current connection string is not valid and can't be used to connect to SQL Server
Where do I check this? (1)
Creating A Grant Rights script for LocalSystem = ticked
Assigning Reporting Services Rights to User = error (2)
System.Data.SqlClient.SqlException: The role 'RSExecRole' does not exist in the current database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
Can someone tell me what I should be checking please?
thanks
View 13 Replies
View Related
Mar 29, 2007
I am installing sql server 2005 reporting services on server running sql server 2005. I get to the reporting services configuration page and configure...
report server virtual directory
report manager virtual directory
windows service identity
web service identity
database setup
encryption keys
when I get to Initialization the button is grey and inactive so I can't initialize reporting
services, Do I need to restart server?
View 1 Replies
View Related
Jan 15, 2007
Wondering if I could get some feedback from 'you All' on how you use the Reporting Services configuration files.
Specifically, I'm interested in -
1) Have you ever made changes to the configuration files? (Yes/No; if Yes - how often?)
2) What if any operations you commonly do in the files? (list)
3) Do you script or otherwise have automated solutions for updating these files? (Yes/No; if Yes - in what scenarios; if No - did you try to?)
Any other feedback about the configuration files is also welcome.
Thanks,
-Lukasz
View 2 Replies
View Related
Jul 11, 2007
Hello all
I am trying to configure reporting services using the Configuration Tool. I get all checks green except for Encryption Keys (Blue), Initialization (Grey), and Email Settings and Execution Account (both Yellow). I am not too worried about the yellow and blue ones because I have read that other people have the same, but I was wondering how to make Initialization available to configure. I am running SQL Server 2005 - Standard Edition.
Thanks for the help,
S.R.
View 39 Replies
View Related
Jul 12, 2007
we just got the new server windows 2003 server, sql server 2005
- i use remote desktop connect to the server.
- i made the report services for testing,
the problem is I can't not published report.
i check the report services configuration tool.
(the page is gray. also warning come "no report server were found on
the specified machine" detail invalid namespace)
what shoul i do?
View 2 Replies
View Related
Jun 20, 2007
Hi,
I've encountered this error when opening up http://localhost/ReportServer/
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerRSReportServer.config' is denied.
Here is the log info:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Daylight Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFilesReportServerService__06_20_2007_10_08_12.log</Path>
<SystemName>CSD060266</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!9!6/20/2007-10:08:13:: i INFO: Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!9!6/20/2007-10:08:13:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 57106 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: SQM timer timer enabled: Next Event: 60706 seconds. Cycle: 86400 seconds
ReportingServicesService!library!e!6/20/2007-10:08:13:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
ReportingServicesService!library!e!6/20/2007-10:08:44:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
ReportingServicesService!library!e!6/20/2007-10:08:44:: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!e!6/20/2007-10:08:44:: Attempting to start service again...
I've been doing all I could think of: reinstall the whole SQL server and its services; stop and restart SQL server service and Reporting service.
It could be my SQL version has a problem...not sure....
I could not think of anything else.
If you have any thoughts about it, please do reply.
Any suggestion is highly appreciated. Thank you...
View 3 Replies
View Related
May 3, 2007
Hi All -
I am trying to configure reporting services on virtual machine but unable to succeed. I never touched this topic before SQL Server 2005. The left hand side options in Reporting Services Configuration Manager such as Server Status, Virtual Directories, Web Identity works fine but it fails in Database Setup section
Here are the details:
AppServer: SQL Server 2005 Reporting Services & Client components build# 2153 (with SP1 & SP1 hotfix)
going to apply SP2 and Add-on component after the configuration
DBServer: SQL Server 2005 Database Services & Client components build# 2153 (with SP1 & SP1 hotfix)
OS: Windows 2003 Server with SP1
IIS version on AppServer: 6
I have SQL 2005 Reporting services and 2005 Database Engine on 2 different machines.
Here is the error message I am receiving when I try to apply the script in "Database Setup" section of Reporting Services Configuration Manager
It did not log any errors in SQL Server however it shows a warning message in Event Log
Event Log message - "The RSReportServer.config file has been modified."
Configuration Manager error message - It shows me "Create a Grants Rights Script" task failed
"System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String dbServer)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String connectionString, String server, String database, ConfigurationCredentialsType credsType, String account, String password, Boolean upgrade, String dbVersion)"
I have captured the screenshot, let me know if I can send this.
One of my friends suggested the following and I have tried the first option but could not work - Option I)
Our account that is used for database connection should have
1) public and RSExecRole roles for the ReportServerDatabase.
2) RSExecRole roles for the master, msdb , and ReportServerTempDB databases.
Else - Option II)
we can run the Reporting Service Windows Service under the local System Account and then the credentials type for the database set up would be Service credentials. This way we would have more permission.
Did anyone face this problem? how should I resolve this?
Anyone have steps to follow as I feel of missing something in the configuration steps?
Any information/ suggestions/ pointer on this are higly appreciated.
Thanks in advance !!
-Satya
View 2 Replies
View Related
Nov 9, 2006
Hi,
I want to configure my Reporting Service.
And if I want to configure the Database Connection I the action
"Create a Grants Rights Script" fails.
I tried all credential types by it doesn't work.
Does anybody have an idea? Thanks for your help!
Jo-Jo
View 3 Replies
View Related
Sep 2, 2015
I have SQL 2008 R2 instance and would like to install SSRS 2012. I have below query related to database configuration...Is there any performance impact while using SQL 2008R2 instance?Once configured SSRS database on 2008 R2, Will there any issue if we move our SQL instance from 2008R2 to SQL 2012 in future?
View 3 Replies
View Related
Jan 29, 2008
Hi,
I developed a report in development environment, which will later be deployed to QA, Staging and then Production. This report has more than 10 datasets and if the report is moved through each of the databases, datasource has to be changed for all the datasets. is there anyway that I can do it globally, what i mean is can i set up any configuration files which I can use in QA, Staging and Production.
Any ideas
Thanks,
Priya T
View 4 Replies
View Related
Aug 6, 2014
I am using BIDS 2012.I am getting this error: Unable to load assembly U2.
Data.Client, Version=2.1.0.0, Culture=neutral , PublicKeyToken=9ab9148678f4f448, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
---> System.IO.FileNotFoundException: Could not load file or assembly 'U2.Data.Client, Version=2.1.0.0, Culture=neutral, PublicKeyToken=9ab9148678f4f448' or one of its dependencies. The system cannot find the file specified.
[code]....
I am expecting
C:WindowsMicrosoft.NETFramework64v4.0.30319configmachine.config
how can I force SSRS to use "C:WindowsMicrosoft.NETFramework64v4.0.30319configmachine.config".
View 5 Replies
View Related
Jul 25, 2015
I have installed SSRS 2012 Standard Edition in our DR site. We replicate over the reporting server databases over from our Production server via storage replication. It is on a different server than the reporting service. When I configure the SSRS in DR it is still seeing the SSRS from our Production server and tries to make it a scale out deployment which it is obviously not allowed to be because of the edition.Is there something in the database itself I need to change so it doesn't think the production server is still connecting?
View 0 Replies
View Related
May 14, 2008
Hi all,
i am tring to install and configure reporting services in Windows 2003 SP2- 64 bit machine as part of installing SCE 2007, and i followed the procedure for confiurng all the options in reportingservices config tool,
all the options show green flag and still could not proceed further as the following error is coming
"The Selected Sql server reportin service instance is not configured , please configure to continue" which halts the further process,
I have installed SQL Server 2005 edition and installed Sql server 2005 SP2 also,
any inputs on this issue , i would welcome them,
View 2 Replies
View Related
Jan 21, 2008
Hi All,
I want to deploy my reports in a Sharepoint site. So I need to change the Deployment mode from Native to Sharepoint Integrated mode. When go to Reporting Services Configuration and in Database Setup - the Server Mode option is not visible. Anyone help me what is the reason for this or How to get Server Mode option in Database Setup in Reporting Services Configuration menu. However the system installed with Sharepoint and SSRS SP2.
Thanks in advance,
Senthil
View 4 Replies
View Related
Nov 22, 2006
I installed 2K5 developer on my box. I was impressed with the Summary tab report functions and the reports available there. Then I ran the "Reporting services configuration" tool to get RS running, but now several of the summary reports are broken. There are several different error messages given in the summary window, depending on the report selected.
For example, the "server dashboard" now displays
Summary Unavailable
The information needed to display a summary page for the selected object is not available.
Error:
"sql_handle" is not a recognized table hints option. If it is intended as a parameter to a table-valued function, ensure that your database compatibility mode is set to 90.
The next two reports work, but the "Scheduler Health" report displays
Summary Unavailable
The information needed to display a summary page for the selected object is not available.
Error:
Incorrect syntax near '.'.
"Memory Consumption" works GREAT, but "Activity - All blocking transaction" shows:
Summary Unavailable
The information needed to display a summary page for the selected object is not available.
Error:
Incorrect syntax near '.'.
Incorrect syntax near '.'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near the keyword 'as'.
What could be the cause of such errors? Is there an "easy fix"? I wouldn't know how to "unconfigure" reporting services and have a feeling that wouldn't help anyway...
View 11 Replies
View Related
May 21, 2008
Hi
I'm getting a blank Report Manager Page or a recurring username popup for users from another domain added to Reporting Services. Adding the users to the Local Administrators group on the Reporting Services server solves the problem but for security reasons this obviously is not ideal.
I've tried adding a Global Group from the other domain to a local group on the RS server and adding the local group to RS as a role.
I've tried adding the Global Group from the other domain as a role.
I've tried adding individual users from the other domain to RS
I've tried adding the Domain Users group from the other domain to the Local Users Group on the RS Server.
What am I missing? It should be as simple as "click, click, add group and like magic, it works"
Thanks in advance
View 1 Replies
View Related
May 6, 2015
I came across a SQL 2000 instance with a report server database on it - looking at the execution log storage I can see that its still being used and running the following query tells me that the connections are coming from the same server: SELECT hostname, * FROM sysprocesses WHERE dbid = DB_ID ('ReportServer') but I cant find the SSRS instance in the services -Did it work differently with SQL 2000? How can I find the report manager URL?
View 3 Replies
View Related
