Partner Support

How to fix Blank Reports


While reports generated by delivery schedules appear as normal, when you preview a report, it contains no data but simply presents the report template.

The following error appears in Error found in \Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles\ReportServerService.log

Error

An error occurred while attempting to connect or execute a query on the database. 09/01/2015 7:02:19 AM
********************************************************************************************
Additional Info: exec SC_PatchManagement_IsPatchSiteRegistered @siteID
Exception Details: System.Data.SqlClient.SqlException: Cannot open database "SCData_Default" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at LPI.SC.Reports.DynamicDPExt.DynamicCommand.Microsoft.ReportingServices.DataProcessing.IDbCommand.ExecuteReader(CommandBehavior behavior)


Ensure that the user in SQL has the proper permissions for SCData_Default:
  1. Launch SQL Management Studio and connect to the Service Center database server. 
  2. Expand Security > Logins, right-click the user account referenced in the error and choose Properties. 
  3. Select the User Mapping page. 
  4. Choose SCData_Default and make sure the role membership includes db_owner and public.
  5. Click OK. The report will now run as normal.

Was this article helpful?