SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2012 running SSRS without the ability to add users.


SQL 2012 running SSRS without the ability to add users.

Author
Message
bryan.adams
bryan.adams
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 11

I am new to SSRS but we have been requested by a vender to add the reporting service.

If I go into folder or users in site settings I do not see any users.

If I try to add a user to either site settings or folders I get the same generic error.

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

I have tried using the http://localhost/reports instead of the server name, I have tried running IE as administrator and I have tried inprivate browsing.

All of these have resulted in the same error list above. I have researched the error in the log but it also does not seem to help.

I did not setup the report side of the server I believe the vender did but I went thru the config and have not found anything incorrect.

ANY HELP WOULD BE AMAZING!

I will provide a copy of the error log below.

<Header>
<Product>Microsoft SQL Server Reporting Services Version 2011.0110.6020.00 ((SQL11_PCU_Main).151020-1526 )</Product>
<Locale>English (United States)</Locale>
<TimeZone>Mountain Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__12_10_2017_22_53_47.log</Path>
<SystemName>TMHSQL-VM</SystemName>
<OSName>Microsoft Windows NT 6.1.7601 Service Pack 1</OSName>
<OSVersion>6.1.7601</OSVersion>
<ProcessID>5500</ProcessID>
<Virtualization>Hypervisor</Virtualization>
< /Header>
< ProcessorArchitecture>AMD64</ProcessorArchitecture>
< ApplicationArchitecture>AMD64</ApplicationArchitecture>
rshost!rshost!1d14!12/10/2017-22:53:47:: i INFO: CLR runtime is initialized.
rshost!rshost!1d14!12/10/2017-22:53:47:: i INFO: Derived memory configuration based on physical memory as 16776760 KB
appdomainmanager!DefaultDomain!1d14!12/10/2017-22:53:47:: i INFO: Entered managed ServiceMain in DefaultDomain.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing DisableSecureFormsAuthenticationCookie to 'False' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to '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' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing AuthenticationTypes to '4' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing RSWindowsExtendedProtectionLevel to 'Off' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing RSWindowsExtendedProtectionScenario to 'Proxy' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing EnableAuthPersistence to 'True' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: w WARN: Initializing UrlRoot to default value of '' because it was incorrectly specified in Configuration file as ''.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing IsReportManagerEnabled to 'True' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing MaxConnections to '2' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing Timeout to '10' second(s) as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing AppID to '(Default)' as specified in Configuration file.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Initializing CacheLevel to 'Default' as specified in Configuration file.
resourceutilities!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Reporting Services starting SKU: Standard
configmanager!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Using report server internal url http://localhost:80/ReportServer.
configmanager!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Using report server external url http://TMHSQL-VM:80/ReportServer.
configmanager!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Using url root http://TMHSQL-VM:80/ReportServer.
rshost!rshost!132c!12/10/2017-22:53:48:: i INFO: Configuring maxPhysicalCpu=4, minLogicalCpu=0
rshost!rshost!132c!12/10/2017-22:53:48:: i INFO: Logical processor per physical processor 2
rshost!rshost!132c!12/10/2017-22:53:48:: i INFO: Logical processor per core 1
rshost!rshost!132c!12/10/2017-22:53:48:: i INFO: Maximum logical CPU is 2
configmanager!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Using report server internal url http://localhost:80/ReportServer.
configmanager!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Using report server external url http://TMHSQL-VM:80/ReportServer.
configmanager!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Using url root http://TMHSQL-VM:80/ReportServer.
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
library!DefaultDomain!132c!12/10/2017-22:53:48:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
library!DefaultDomain!132c!12/10/2017-22:53:48:: 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!132c!12/10/2017-22:53:48:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
appdomainmanager!DefaultDomain!132c!12/10/2017-22:53:49:: i INFO: Appdomain:2 WindowsService_0 started.
library!WindowsService_0!132c!12/10/2017-22:53:50:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
library!WindowsService_0!132c!12/10/2017-22:53:50:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
library!WindowsService_0!132c!12/10/2017-22:53:50:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
library!WindowsService_0!132c!12/10/2017-22:53:50:: 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!132c!12/10/2017-22:53:50:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
resourceutilities!WindowsService_0!132c!12/10/2017-22:53:50:: i INFO: Reporting Services starting SKU: Standard
library!WindowsService_0!1e8c!12/10/2017-22:53:50:: i INFO: Catalog SQL Server Edition = Standard
crypto!WindowsService_0!1e8c!12/10/2017-22:53:50:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
crypto!WindowsService_0!1e8c!12/10/2017-22:53:50:: i INFO: Exporting public key
rshost!rshost!5c8!12/10/2017-22:53:50:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer.
rshost!rshost!5c8!12/10/2017-22:53:50:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2
rshost!rshost!5c8!12/10/2017-22:53:50:: i INFO: Registered url=http://+:80/Reports/, vdir=/Reports, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportManager.
rshost!rshost!5c8!12/10/2017-22:53:50:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3
rshost!rshost!5c8!12/10/2017-22:53:50:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.
crypto!WindowsService_0!1e8c!12/10/2017-22:53:50:: i INFO: Performing sku validation
crypto!WindowsService_0!1e8c!12/10/2017-22:53:50:: i INFO: Importing existing encryption key
resourceutilities!DefaultDomain!132c!12/10/2017-22:53:50:: i INFO: Maximum memory limit is 65536Mb
rshost!rshost!132c!12/10/2017-22:53:50:: i INFO: Derived memory configuration based on physical memory as 16776760 KB
servicecontroller!DefaultDomain!5c8!12/10/2017-22:53:50:: i INFO: Total Physical memory: 17179402240
rpcserver!DefaultDomain!1350!12/10/2017-22:53:50:: i INFO: Process monitoring started.
dbpolling!WindowsService_0!1e8c!12/10/2017-22:53:51:: i INFO: EventPolling polling service started
dbpolling!WindowsService_0!1e8c!12/10/2017-22:53:51:: i INFO: NotificationPolling polling service started
dbpolling!WindowsService_0!1e8c!12/10/2017-22:53:51:: i INFO: SchedulePolling polling service started
dbpolling!WindowsService_0!1e8c!12/10/2017-22:53:51:: i INFO: UpgradePolling polling service started
dbpolling!WindowsService_0!1a58!12/10/2017-22:53:51:: i INFO: PollingMaintenance: Polling started
resourceutilities!WindowsService_0!1a58!12/10/2017-22:53:51:: i INFO: Maximum memory limit is 65536Mb
rpcserver!DefaultDomain!1e8c!12/10/2017-22:53:51:: i INFO: RPC Server started.
servicecontroller!DefaultDomain!1e8c!12/10/2017-22:53:51:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS11.MSSQLSERVER'
appdomainmanager!WindowsService_0!1e8c!12/10/2017-22:53:51:: i INFO: Appdomain:2 WindowsService_0 initialized.
appdomainmanager!DefaultDomain!1fec!12/10/2017-22:54:10:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-131574452496895727 started.
appdomainmanager!ReportManager_0-1!1fec!12/10/2017-22:54:12:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/Reports.
appdomainmanager!DefaultDomain!1fec!12/10/2017-22:54:12:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-131574452496895727 initialized (#1).
library!ReportManager_0-1!1fec!12/10/2017-22:54:18:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
library!ReportManager_0-1!1fec!12/10/2017-22:54:18:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
library!ReportManager_0-1!1fec!12/10/2017-22:54:18:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
library!ReportManager_0-1!1fec!12/10/2017-22:54:18:: 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!ReportManager_0-1!1fec!12/10/2017-22:54:18:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
ui!ReportManager_0-1!1fec!12/10/2017-22:54:18:: i INFO: Registering with Software Usage Metrics Product:SQL Server 2012, Role:Microsoft SQL Server Reporting Services, RoleGuid:8cc0ac85-40f7-4886-9dab-021519800418
ui!ReportManager_0-1!1fec!12/10/2017-22:54:18:: e ERROR: Software Usage Metrics initialize failed
ui!ReportManager_0-1!1fec!12/10/2017-22:54:18:: i INFO: Unhandled exception: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeClientDisconnectionException: A client has disconnected from the Report Server Web service application domain ReportManager_MSSQLSERVER_0-1-131574452496895727. No corrective action is required. An error code has been submitted to ASP.NET to release the connection. The error code is 800708CA. ---> System.Runtime.InteropServices.COMException: This network connection does not exist. (Exception from HRESULT: 0x800708CA)
appdomainmanager!DefaultDomain!6e4!12/10/2017-22:54:22:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-131574452620245727 started.
appdomainmanager!ReportServer_0-2!6e4!12/10/2017-22:54:24:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/ReportServer.
appdomainmanager!DefaultDomain!6e4!12/10/2017-22:54:25:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-131574452620245727 initialized (#1).
webserver!ReportServer_0-2!144c!12/10/2017-22:55:02:: i INFO: Reporting Web Server started
library!ReportServer_0-2!144c!12/10/2017-22:55:03:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
library!ReportServer_0-2!144c!12/10/2017-22:55:03:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
library!ReportServer_0-2!144c!12/10/2017-22:55:03:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
library!ReportServer_0-2!144c!12/10/2017-22:55:03:: 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-2!144c!12/10/2017-22:55:03:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
resourceutilities!ReportServer_0-2!144c!12/10/2017-22:55:03:: i INFO: Reporting Services starting SKU: Standard
ui!ReportServer_0-2!144c!12/10/2017-22:55:03:: i INFO: Registering with Software Usage Metrics Product:SQL Server 2012, Role:Microsoft SQL Server Reporting Services, RoleGuid:8cc0ac85-40f7-4886-9dab-021519800418
ui!ReportServer_0-2!144c!12/10/2017-22:55:03:: e ERROR: Software Usage Metrics initialize failed
resourceutilities!ReportServer_0-2!6e4!12/10/2017-22:55:03:: i INFO: Maximum memory limit is 65536Mb
resourceutilities!ReportServer_0-2!144c!12/10/2017-22:55:03:: i INFO: Maximum memory limit is 65536Mb
resourceutilities!ReportServer_0-2!298!12/10/2017-22:55:03:: i INFO: Maximum memory limit is 65536Mb
library!ReportServer_0-2!144c!12/10/2017-22:55:06:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!15e4!12/10/2017-22:55:06:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!298!12/10/2017-22:55:06:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!298!12/10/2017-22:55:06:: i INFO: Catalog SQL Server Edition = Standard
library!ReportServer_0-2!15e4!12/10/2017-22:55:06:: i INFO: Catalog SQL Server Edition = Standard
library!ReportServer_0-2!144c!12/10/2017-22:55:06:: i INFO: Catalog SQL Server Edition = Standard
crypto!ReportServer_0-2!298!12/10/2017-22:55:07:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
crypto!ReportServer_0-2!298!12/10/2017-22:55:07:: i INFO: Exporting public key
crypto!ReportServer_0-2!298!12/10/2017-22:55:07:: i INFO: Performing sku validation
crypto!ReportServer_0-2!298!12/10/2017-22:55:07:: i INFO: Importing existing encryption key
library!ReportServer_0-2!17c8!12/10/2017-22:55:10:: i INFO: Call to GetSystemPoliciesAction().
library!ReportServer_0-2!144c!12/10/2017-22:55:10:: i INFO: Call to GetSystemPoliciesAction().
library!ReportServer_0-2!15e4!12/10/2017-22:55:10:: i INFO: Call to GetSystemPoliciesAction().
library!ReportServer_0-2!144c!12/10/2017-22:55:11:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!15e4!12/10/2017-22:55:11:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!144c!12/10/2017-22:55:11:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1a8c!12/10/2017-22:55:14:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!132c!12/10/2017-22:55:14:: i INFO: Call to ListRolesAction(System).
library!ReportServer_0-2!1a8c!12/10/2017-22:55:14:: i INFO: Call to GetSystemPoliciesAction().
library!ReportServer_0-2!1a8c!12/10/2017-22:55:14:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!12e0!12/10/2017-22:55:24:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!12e0!12/10/2017-22:55:24:: i INFO: Call to ListRolesAction(System).
library!ReportServer_0-2!12e0!12/10/2017-22:55:24:: i INFO: Call to GetSystemPoliciesAction().
library!ReportServer_0-2!12e0!12/10/2017-22:55:24:: i INFO: Call to SetSystemPoliciesAction().
library!ReportServer_0-2!12e0!12/10/2017-22:55:24:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Null SID was found, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.;
library!ReportServer_0-2!12e0!12/10/2017-22:55:30:: i INFO: Dump result: External dump process return code 0x20000001.
External dump process returned no errors.
.
ui!ReportManager_0-1!1a8c!12/10/2017-22:55:30:: e ERROR: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Library.ReportingService2005Impl.SetSystemPolicies(Policy[] Policies, Guid batchId)
at Microsoft.ReportingServices.Library.ReportingService2005Impl.SetSystemPolicies(Policy[] Policies)
at Microsoft.ReportingServices.WebServer.ReportingService2010.SetSystemPolicies(Policy[] Policies)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.SetSystemPolicies(Policy[] Policies)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<>c__DisplayClass38.<SetSystemPolicies>b__37()
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetSystemPolicies(Policy[] policies)
at Microsoft.ReportingServices.UI.EditGroup.ApplyChanges()
at Microsoft.ReportingServices.UI.BaseApplyPage.ApplyBtn_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
ui!ReportManager_0-1!1a8c!12/10/2017-22:55:30:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Library.ReportingService2005Impl.SetSystemPolicies(Policy[] Policies, Guid batchId)
at Microsoft.ReportingServices.Library.ReportingService2005Impl.SetSystemPolicies(Policy[] Policies)
at Microsoft.ReportingServices.WebServer.ReportingService2010.SetSystemPolicies(Policy[] Policies)

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.SetSystemPolicies(Policy[] Policies)

at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<>c__DisplayClass38.<SetSystemPolicies>b__37()

at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)

at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetSystemPolicies(Policy[] policies)

at Microsoft.ReportingServices.UI.EditGroup.ApplyChanges()

at Microsoft.ReportingServices.UI.BaseApplyPage.ApplyBtn_Click(Object sender, EventArgs e)

at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
library!ReportServer_0-2!12e0!12/10/2017-22:55:30:: i INFO: Call to GetSystemPropertiesAction().
ui!ReportManager_0-1!1a8c!12/10/2017-22:55:30:: e ERROR: 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 Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
library!ReportServer_0-2!1a8c!12/10/2017-22:57:45:: i INFO: Call to GetPermissionsAction(/).
library!ReportServer_0-2!1a8c!12/10/2017-22:57:45:: i INFO: Call to GetPropertiesAction(/, PathBased).
library!ReportServer_0-2!144c!12/10/2017-22:57:45:: i INFO: Call to GetPropertiesAction(/, PathBased).
library!ReportServer_0-2!144c!12/10/2017-22:57:45:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!144c!12/10/2017-22:57:45:: i INFO: Call to ListChildrenAction(/, False).
library!ReportServer_0-2!1a8c!12/10/2017-22:57:45:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!18c8!12/10/2017-22:58:26:: i INFO: Call to GetPermissionsAction(/).
library!ReportServer_0-2!18c8!12/10/2017-22:58:26:: i INFO: Call to GetPropertiesAction(/, PathBased).
library!ReportServer_0-2!18c8!12/10/2017-22:58:26:: i INFO: Call to GetPropertiesAction(/, PathBased).
library!ReportServer_0-2!18c8!12/10/2017-22:58:26:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!18c8!12/10/2017-22:58:26:: i INFO: Call to GetPoliciesAction(/).
library!ReportServer_0-2!18c8!12/10/2017-22:58:26:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1fec!12/10/2017-22:58:30:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1fec!12/10/2017-22:58:30:: i INFO: Call to ListRolesAction(Catalog).
library!ReportServer_0-2!1fec!12/10/2017-22:58:30:: i INFO: Call to GetPoliciesAction(/).
library!ReportServer_0-2!1fec!12/10/2017-22:58:30:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1fec!12/10/2017-22:58:43:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1fec!12/10/2017-22:58:43:: i INFO: Call to ListRolesAction(Catalog).
library!ReportServer_0-2!1fec!12/10/2017-22:58:43:: i INFO: Call to GetPoliciesAction(/).
library!ReportServer_0-2!1fec!12/10/2017-22:58:43:: i INFO: Call to SetPoliciesAction(/).
library!ReportServer_0-2!1fec!12/10/2017-22:58:43:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Null SID was found, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.;
library!ReportServer_0-2!1fec!12/10/2017-22:58:46:: i INFO: Dump result: External dump process return code 0x20000001.
External dump process returned no errors.
.
ui!ReportManager_0-1!1328!12/10/2017-22:58:46:: e ERROR: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Library.ReportingService2005Impl.SetPolicies(String Item, Policy[] Policies, Guid batchId)
at Microsoft.ReportingServices.Library.ReportingService2005Impl.SetPolicies(String Item, Policy[] Policies)
at Microsoft.ReportingServices.WebServer.ReportingService2010.SetPolicies(String ItemPath, Policy[] Policies)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.SetPolicies(String ItemPath, Policy[] Policies)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<>c__DisplayClass34.<SetPolicies>b__33()
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetPolicies(String itemPath, Policy[] policies)
at Microsoft.ReportingServices.UI.EditGroup.ApplyChanges()
at Microsoft.ReportingServices.UI.BaseApplyPage.ApplyBtn_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
ui!ReportManager_0-1!1328!12/10/2017-22:58:46:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Library.ReportingService2005Impl.SetPolicies(String Item, Policy[] Policies, Guid batchId)
at Microsoft.ReportingServices.Library.ReportingService2005Impl.SetPolicies(String Item, Policy[] Policies)
at Microsoft.ReportingServices.WebServer.ReportingService2010.SetPolicies(String ItemPath, Policy[] Policies)

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.SetPolicies(String ItemPath, Policy[] Policies)

at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<>c__DisplayClass34.<SetPolicies>b__33()

at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)

at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetPolicies(String itemPath, Policy[] policies)

at Microsoft.ReportingServices.UI.EditGroup.ApplyChanges()

at Microsoft.ReportingServices.UI.BaseApplyPage.ApplyBtn_Click(Object sender, EventArgs e)

at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
library!ReportServer_0-2!1fec!12/10/2017-22:58:46:: i INFO: Call to GetSystemPropertiesAction().
ui!ReportManager_0-1!1328!12/10/2017-22:58:46:: e ERROR: 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 Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
library!ReportServer_0-2!144c!12/10/2017-22:58:53:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!144c!12/10/2017-22:58:54:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!144c!12/10/2017-22:58:54:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1404!12/10/2017-22:58:56:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1404!12/10/2017-22:58:56:: i INFO: Call to GetSystemPoliciesAction().
library!ReportServer_0-2!1404!12/10/2017-22:58:56:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1fec!12/10/2017-22:58:59:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1fec!12/10/2017-22:58:59:: i INFO: Call to ListRolesAction(System).
library!ReportServer_0-2!1fec!12/10/2017-22:58:59:: i INFO: Call to GetSystemPoliciesAction().
library!ReportServer_0-2!1fec!12/10/2017-22:58:59:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!144c!12/10/2017-22:59:07:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!144c!12/10/2017-22:59:07:: i INFO: Call to ListRolesAction(System).
library!ReportServer_0-2!144c!12/10/2017-22:59:07:: i INFO: Call to GetSystemPoliciesAction().
library!ReportServer_0-2!144c!12/10/2017-22:59:07:: i INFO: Call to SetSystemPoliciesAction().
library!ReportServer_0-2!144c!12/10/2017-22:59:07:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Null SID was found, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.;
library!ReportServer_0-2!144c!12/10/2017-22:59:07:: i INFO: Skipped creating a dump file for the error InternalCatalogException, because a dump with the identical stack trace (with signature 3984958333) was already created.
ui!ReportManager_0-1!17c8!12/10/2017-22:59:07:: e ERROR: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Library.ReportingService2005Impl.SetSystemPolicies(Policy[] Policies, Guid batchId)
at Microsoft.ReportingServices.Library.ReportingService2005Impl.SetSystemPolicies(Policy[] Policies)
at Microsoft.ReportingServices.WebServer.ReportingService2010.SetSystemPolicies(Policy[] Policies)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.SetSystemPolicies(Policy[] Policies)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<>c__DisplayClass38.<SetSystemPolicies>b__37()
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetSystemPolicies(Policy[] policies)
at Microsoft.ReportingServices.UI.EditGroup.ApplyChanges()
at Microsoft.ReportingServices.UI.BaseApplyPage.ApplyBtn_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
ui!ReportManager_0-1!17c8!12/10/2017-22:59:07:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Library.ReportingService2005Impl.SetSystemPolicies(Policy[] Policies, Guid batchId)
at Microsoft.ReportingServices.Library.ReportingService2005Impl.SetSystemPolicies(Policy[] Policies)
at Microsoft.ReportingServices.WebServer.ReportingService2010.SetSystemPolicies(Policy[] Policies)

<input id="12c5b80b-3136-45d3-ae7b-b80a2e0e9626_attachments" type="hidden" value="" />
Subramaniam Chandrasekar
Subramaniam Chandrasekar
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3102 Visits: 531
Hi There,
Hope you're doing well !
I've gone thru your problem case as above, What I can conclude from my end is, Memory issue in the server where the SSRS is installed.
Firstly I want to check,
  1. Whereis the SSRS installed ? Is it installed in DB server / Application server ?

  2. Howmuch the main memory is allocated In the server where the SSRS isinstalled ? ( RAM size )

  3. What isthe OS version, If it is windows, what is the windows server and clientversions ? ( 32 bit / 64 bit ) ( this info will help to trouble shootcompatibility issue )

  4. If RAMsize is 10gb, say for example, how much memory was given to SSRS ? (Please check report server config file )

  5. IIS isinstalled in the server where SSRS is configured ? If it is there, check foractive internet connections

Please reply to these, Once you've replied we can further investigate into SSRS config file and settings.
Thanks
Subbu
bryan.adams
bryan.adams
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 11
It was the webconfig file. The auth was set incorrectly by another program.

<Security>

<Extension Name="Windows"Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,Microsoft.ReportingServices.Authorization"/>

</Security>

<Authentication>

<Extension Name="Windows"Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,Microsoft.ReportingServices.Authorization"/>

</Authentication>


Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (199K reputation)SSC Guru (199K reputation)SSC Guru (199K reputation)SSC Guru (199K reputation)SSC Guru (199K reputation)SSC Guru (199K reputation)SSC Guru (199K reputation)SSC Guru (199K reputation)

Group: General Forum Members
Points: 199368 Visits: 18538
check you are a member of the local admins group

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search