Hi,

Been trying to troubleshoot this for a day and had already done the following:

1. http://myitforum.com/myitforumwp/2012/10/10/reporting-services-site-role-setup-instance-blankempty/

2. Reinstalled reporting services on SQL Database Server

3. https://social.technet.microsoft.com/Forums/en-US/4479e73e-8a19-4c7e-9418-b36770656b9b/action?threadDisplayName=sccm-2012-reporting-point-server-instance-blank

I'm not sure what I am missing but regardless after restarting countless times and troubleshooting, I still can't get the reporting services setup on our SCCM 2012 server. The database is SQL 2012 SP1. Both are on a different VM instance. I'm getting a blank value on the Reporting point server instance.

The good part is I can get the website working but getting the reports via web by opening it on the reports services manager on the SQL server. Other than that, I am stuck between a rock and a hard place.

Any suggestion?

Make sure that you are adding the Reporting Services Point to the SQL server rather than the site server.

Thanks.

I have done what is suggested and still get the same issue.

I may have failed to mention this was working before. I believe this happened after the SQL license expired on the SQL Server which the admin failed to inform me. Also, the previous admin unexpectedly remove Reporting Services on the SQL server in hopes of restoring it. Now that the license is fixed, Is there any way to revert the setup just to restore the reporting services?

• Edited by Eisen Yuan Monday, November 17, 2014 2:31 AM updates

Continuing with the same issue:

Microsoft.Reporting.WinForms.ReportServerException
The DefaultValue expression for the report parameter UserSIDs contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. (rsRuntimeErrorInExpression)

Stack Trace:
   at Microsoft.Reporting.WinForms.ServerReportSoapProxy.OnSoapException(SoapException e)
   at Microsoft.Reporting.WinForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod)
   at Microsoft.Reporting.WinForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID)
   at Microsoft.Reporting.WinForms.ServerReport.EnsureExecutionSession()
   at Microsoft.Reporting.WinForms.ServerReport.SetParameters(IEnumerable`1 parameters)
   at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerWindowsForms.SetParameterValues_DoWork(Object sender, DoWorkEventArgs e)

-------------------------------

Not sure what I am missing now

• Edited by Eisen Yuan Monday, November 17, 2014 7:51 AM

Hello,

I read the  link you provided in your original post, but I still have some questions.

Are ReportServer and ReportServerTempDB exist?

Can you get access to  the report server via web site?

Try to Delete Encrtped Content in reporting service manager.

• Edited by Daniel JiSunMicrosoft contingent staff, Moderator Tuesday, November 18, 2014 9:24 AM

Thanks Daniel for the response.

Yes, the two DB are present as I have recreated them via Reporting Service Manager.

I've also tried uninstalling and reinstalling the reporting service in the SQL server and recreated the DB as mentioned. The only thing I didn't recreate was the service account used.

Update on this at the moment is that, I can now add the reporting services into the SQL Server on the ConfigManager Console. The thing I am missing now is that I cannot get the reports to appear and gives me an error: "there is a problem connecting to the specified reporting server"

When I checked the logs in the SQL Server, this is what I found:

1st error:

"microsoft.reportingservices.diagnostics.utilities.itemnotfoundexception: The item '/reportserver_sccmint' cannot be found."

2nd error:

rshost!rshost!98c!11/19/2014-07:19:55:: w WARN: Endpoint 3 is enabled but no url is registered for vdir=/ReportServer_SCCM, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.SCCMINT\Reporting Services\ReportManager.
servicecontroller!DefaultDomain!130c!11/19/2014-07:19:55:: e ERROR: Error creating HTTP endpoint. System.Runtime.InteropServices.COMException (0x800700B7): Cannot create a file when that file already exists. (Exception from HRESULT: 0x800700B7)
   at Microsoft.ReportingServices.HostingInterfaces.IRsUnmanagedCallback.CreateHttpEndpoint(RsAppDomainType application, String[] urlPrefixes, Int32 cPrefixes, String[] hosts, Int32 cHosts, Boolean wildCardPresent, String virtualDirectory, String filePath, Int32 authType, Int32 logonMethod, String authDomain, String authRealm, Boolean authPersist, Int32 extendedProtectionLevel, Int32 extendedProtectionScenario, Boolean enabled)
   at Microsoft.ReportingServices.Library.ServiceAppDomainController.SetWebConfiguration(RunningApplication rsApplication, Boolean enabled, String folder)
rshost!rshost!98c!11/19/2014-07:19:55:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer_SCCM/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.SCCMINT\Reporting Services\ReportServer\ReportBuilder.
rshost!rshost!130c!11/19/2014-07:19:55:: i INFO: Derived memory configuration based on physical memory as 33553912 KB
appdomainmanager!DefaultDomain!130c!11/19/2014-07:19:55:: i INFO: Appdomain:12 ReportServer_SCCMINT_0-2-130607833365572849 unregistered.
appdomainmanager!ReportServer_0-2!130c!11/19/2014-07:19:55:: i INFO: Appdomain:12 ReportServer_SCCMINT_0-2-130607833365572849 unloading
servicecontroller!DefaultDomain!130c!11/19/2014-07:19:55:: i INFO: Recycling the service from the default domain

When I do load the page, I get a blank website which shows the name of the server and the folder where the reports are supposed to be and nothing else. Any help?

Hi JiSun

Thanks for the response.

Yes, they are recreated after I deleted them and recreated them via Reporting Services Configuration Manager.

Also, the report service is running and successfully added to the SCCM Site Server Roles. But when I go to the reports in ConfigMgr, I get the error: "there is a problem connecting to the specified Reporting server"

When I click the site on the Reporting Services Manager, it also shows a site with only the servername and folder where the report should be, the rest is blank.

I opened the logs in the SQL server and got this log:

rshost!rshost!98c!11/19/2014-07:19:55:: w WARN: Endpoint 3 is enabled but no url is registered for vdir=/ReportServer_SCCM, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.SCCMINT\Reporting Services\ReportManager.

servicecontroller!DefaultDomain!130c!11/19/2014-07:19:55:: e ERROR: Error creating HTTP endpoint. System.Runtime.InteropServices.COMException (0x800700B7): Cannot create a file when that file already exists. (Exception from HRESULT: 0x800700B7)

   at Microsoft.ReportingServices.HostingInterfaces.IRsUnmanagedCallback.CreateHttpEndpoint(RsAppDomainType application, String[] urlPrefixes, Int32 cPrefixes, String[] hosts, Int32 cHosts, Boolean wildCardPresent, String virtualDirectory, String filePath, Int32 authType, Int32 logonMethod, String authDomain, String authRealm, Boolean authPersist, Int32 extendedProtectionLevel, Int32 extendedProtectionScenario, Boolean enabled)

   at Microsoft.ReportingServices.Library.ServiceAppDomainController.SetWebConfiguration(RunningApplication rsApplication, Boolean enabled, String folder)

rshost!rshost!98c!11/19/2014-07:19:55:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer_SCCM/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.SCCMINT\Reporting Services\ReportServer\ReportBuilder.

rshost!rshost!130c!11/19/2014-07:19:55:: i INFO: Derived memory configuration based on physical memory as 33553912 KB

appdomainmanager!DefaultDomain!130c!11/19/2014-07:19:55:: i INFO: Appdomain:12 ReportServer_SCCMINT_0-2-130607833365572849 unregistered.

appdomainmanager!ReportServer_0-2!130c!11/19/2014-07:19:55:: i INFO: Appdomain:12 ReportServer_SCCMINT_0-2-130607833365572849 unloading

servicecontroller!DefaultDomain!130c!11/19/2014-07:19:55:: i INFO: Recycling the service from the default domain

Any idea what else am I missing?

Thanks, Max

Here is another part of the log:

configmanager!DefaultDomain!119c!11/19/2014-13:46:05:: i INFO: Using report server internal url http://localhost:80/ReportServer_SCCM.
configmanager!DefaultDomain!119c!11/19/2014-13:46:05:: i INFO: Using report server external url http://SPQES3489:80/ReportServer_SCCM.
configmanager!DefaultDomain!119c!11/19/2014-13:46:05:: i INFO: Using url root http://SPQES3489:80/ReportServer_SCCM.
rshost!rshost!119c!11/19/2014-13:46:05:: i INFO: Configuring maxPhysicalCpu=4, minLogicalCpu=0
rshost!rshost!119c!11/19/2014-13:46:05:: i INFO: Logical processor per physical processor 4
rshost!rshost!119c!11/19/2014-13:46:05:: i INFO: Logical processor per core 1
rshost!rshost!119c!11/19/2014-13:46:05:: i INFO: Maximum logical CPU is 4
configmanager!DefaultDomain!119c!11/19/2014-13:46:05:: i INFO: Using report server internal url http://localhost:80/ReportServer_SCCM.
configmanager!DefaultDomain!119c!11/19/2014-13:46:05:: i INFO: Using report server external url http://SPQES3489:80/ReportServer_SCCM.
configmanager!DefaultDomain!119c!11/19/2014-13:46:05:: i INFO: Using url root http://SPQES3489:80/ReportServer_SCCM.
library!DefaultDomain!119c!11/19/2014-13:46:05:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
library!DefaultDomain!119c!11/19/2014-13:46:05:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
library!DefaultDomain!119c!11/19/2014-13:46:05:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
library!DefaultDomain!119c!11/19/2014-13:46:05:: i INFO: Do not dump on: System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException,Microsoft.ReportingServices.WmiProvider.WMIProviderException
library!DefaultDomain!119c!11/19/2014-13:46:05:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.SCCMINT\Reporting Services\Logfiles
appdomainmanager!DefaultDomain!119c!11/19/2014-13:46:06:: i INFO: Appdomain:2 WindowsService_0 started.
library!WindowsService_0!119c!11/19/2014-13:46:07:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
library!WindowsService_0!119c!11/19/2014-13:46:07:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
library!WindowsService_0!119c!11/19/2014-13:46:07:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
library!WindowsService_0!119c!11/19/2014-13:46:07:: i INFO: Do not dump on: System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException,Microsoft.ReportingServices.WmiProvider.WMIProviderException
library!WindowsService_0!119c!11/19/2014-13:46:07:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.SCCMINT\Reporting Services\Logfiles
resourceutilities!WindowsService_0!119c!11/19/2014-13:46:07:: i INFO: Reporting Services starting SKU: Standard
library!WindowsService_0!1084!11/19/2014-13:46:07:: i INFO: Catalog SQL Server Edition = Standard
crypto!WindowsService_0!1084!11/19/2014-13:46:07:: i INFO: Initializing crypto as user: NT SERVICE\ReportServer$SCCMINT
crypto!WindowsService_0!1084!11/19/2014-13:46:07:: i INFO: Exporting public key
crypto!WindowsService_0!1084!11/19/2014-13:46:07:: i INFO: Performing sku validation
crypto!WindowsService_0!1084!11/19/2014-13:46:07:: i INFO: Importing existing encryption key
dbpolling!WindowsService_0!1084!11/19/2014-13:46:07:: i INFO: EventPolling polling service started
dbpolling!WindowsService_0!1084!11/19/2014-13:46:07:: i INFO: NotificationPolling polling service started
dbpolling!WindowsService_0!1084!11/19/2014-13:46:07:: i INFO: SchedulePolling polling service started
dbpolling!WindowsService_0!1084!11/19/2014-13:46:07:: i INFO: UpgradePolling polling service started
dbpolling!WindowsService_0!1094!11/19/2014-13:46:07:: i INFO: PollingMaintenance: Polling started
resourceutilities!WindowsService_0!1094!11/19/2014-13:46:07:: i INFO: Maximum memory limit is 65536Mb
rpcserver!DefaultDomain!1084!11/19/2014-13:46:08:: i INFO: RPC Server started.
servicecontroller!DefaultDomain!1084!11/19/2014-13:46:08:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS11.SCCMINT'
appdomainmanager!WindowsService_0!1084!11/19/2014-13:46:08:: i INFO: Appdomain:2 WindowsService_0 initialized.
rshost!rshost!1084!11/19/2014-13:46:09:: i INFO: Registered url=http://+:80/ReportServer_SCCM/, vdir=/ReportServer_SCCM, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.SCCMINT\Reporting Services\ReportServer.
rshost!rshost!1084!11/19/2014-13:46:09:: i INFO: Currently registered url http://+:80/ReportServer_SCCM/ on endpoint 2
rshost!rshost!1084!11/19/2014-13:46:09:: e ERROR: Failed to register url=http://+:80/ReportServer_SCCM/ for endpoint 3, error=b7.
rshost!rshost!1084!11/19/2014-13:46:09:: w WARN: Endpoint 3 is enabled but no url is registered for vdir=/ReportServer_SCCM, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.SCCMINT\Reporting Services\ReportManager.
servicecontroller!DefaultDomain!119c!11/19/2014-13:46:09:: e ERROR: Error creating HTTP endpoint. System.Runtime.InteropServices.COMException (0x800700B7): Cannot create a file when that file already exists. (Exception from HRESULT: 0x800700B7)
   at Microsoft.ReportingServices.HostingInterfaces.IRsUnmanagedCallback.CreateHttpEndpoint(RsAppDomainType application, String[] urlPrefixes, Int32 cPrefixes, String[] hosts, Int32 cHosts, Boolean wildCardPresent, String virtualDirectory, String filePath, Int32 authType, Int32 logonMethod, String authDomain, String authRealm, Boolean authPersist, Int32 extendedProtectionLevel, Int32 extendedProtectionScenario, Boolean enabled)
   at Microsoft.ReportingServices.Library.ServiceAppDomainController.SetWebConfiguration(RunningApplication rsApplication, Boolean enabled, String folder)
rshost!rshost!1084!11/19/2014-13:46:09:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer_SCCM/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.SCCMINT\Reporting Services\ReportServer\ReportBuilder.
resourceutilities!DefaultDomain!119c!11/19/2014-13:46:09:: i INFO: Maximum memory limit is 65536Mb
rshost!rshost!119c!11/19/2014-13:46:09:: i INFO: Derived memory configuration based on physical memory as 33553912 KB
servicecontroller!DefaultDomain!bb8!11/19/2014-13:46:09:: i INFO: Total Physical memory: 34359205888
rpcserver!DefaultDomain!1084!11/19/2014-13:46:09:: i INFO: Process monitoring started.
library!WindowsService_0!1094!11/19/2014-13:46:58:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database.;
dbpolling!WindowsService_0!1094!11/19/2014-13:46:58:: e ERROR: PollingFunction: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.).
library!WindowsService_0!1094!11/19/2014-13:47:12:: i INFO: PollingMaintenance: Polling cycle completed.
appdomainmanager!DefaultDomain!620!11/19/2014-13:47:55:: i INFO: Appdomain:3 ReportServer_SCCMINT_0-1-130608496751271532 started.
appdomainmanager!ReportServer_0-1!620!11/19/2014-13:47:57:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/ReportServer_SCCM.
appdomainmanager!DefaultDomain!620!11/19/2014-13:47:57:: i INFO: Appdomain:3 ReportServer_SCCMINT_0-1-130608496751271532 initialized (#1).
webserver!ReportServer_0-1!620!11/19/2014-13:48:07:: i INFO: Reporting Web Server started
library!ReportServer_0-1!620!11/19/2014-13:48:07:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
library!ReportServer_0-1!620!11/19/2014-13:48:07:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
library!ReportServer_0-1!620!11/19/2014-13:48:07:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
library!ReportServer_0-1!620!11/19/2014-13:48:07:: i INFO: Do not dump on: System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException,Microsoft.ReportingServices.WmiProvider.WMIProviderException
library!ReportServer_0-1!620!11/19/2014-13:48:07:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.SCCMINT\Reporting Services\Logfiles
resourceutilities!ReportServer_0-1!620!11/19/2014-13:48:07:: i INFO: Reporting Services starting SKU: Standard
ui!ReportServer_0-1!620!11/19/2014-13:48:07:: i INFO: Registering with Software Usage Metrics Product:SQL Server 2012, Role:Microsoft SQL Server Reporting Services, RoleGuid:8cc0ac85-40f7-4886-9dab-021519800418
resourceutilities!ReportServer_0-1!620!11/19/2014-13:48:07:: i INFO: Maximum memory limit is 65536Mb
library!ReportServer_0-1!620!11/19/2014-13:48:07:: i INFO: Call to GetItemTypeAction(/).
library!ReportServer_0-1!620!11/19/2014-13:48:08:: i INFO: Catalog SQL Server Edition = Standard
crypto!ReportServer_0-1!620!11/19/2014-13:48:08:: i INFO: Initializing crypto as user: NT SERVICE\ReportServer$SCCMINT
crypto!ReportServer_0-1!620!11/19/2014-13:48:08:: i INFO: Exporting public key
crypto!ReportServer_0-1!620!11/19/2014-13:48:08:: i INFO: Performing sku validation
crypto!ReportServer_0-1!620!11/19/2014-13:48:08:: i INFO: Importing existing encryption key
library!ReportServer_0-1!620!11/19/2014-13:48:08:: i INFO: Call to ListParentsAction(/).
library!ReportServer_0-1!620!11/19/2014-13:48:08:: i INFO: Call to ListChildrenAction(/, False).
webserver!ReportServer_0-1!620!11/19/2014-13:48:08:: i INFO: Processed folder '/'
library!DefaultDomain!120c!11/19/2014-13:50:39:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: SELECT SERVERPROPERTY failed to execute., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.  ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.WriteSni()
   at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
   at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at Microsoft.ReportingServices.Diagnostics.SkuUtil.GetSqlSku(SqlConnection sqlConn)
   at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
   --- End of inner exception stack trace ---;

Hello,

You have already installed reporting service role, right?

Then I have the same quesion as that in my last post. Can you access your report server via web? Can you view reports via web?

Find out your datasource and test if you have credential issue during the connection.

• Marked as answer by Eisen Yuan 20 hours 49 minutes ago
• Unmarked as answer by Eisen Yuan 20 hours 48 minutes ago
• Marked as answer by Eisen Yuan 20 hours 48 minutes ago

Hi Daniel,

I ended up reinstalling the whole SCCM with the database intact as what happened is that the folders lost their permissions of some sort and can't seem to edit it. Suggestion was to reinstall everything to have the folder permissions reinstated.

Thanks for the help.

Regards,

Max