Skip to main content

Posts

Showing posts from May, 2016

System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object ‘xp_sqlagent_notify’, database ‘mssqlsystemresource’, schema ‘sys’.

  This error occured to me when im trying to access the Manage Processing Oprions in SharePoint SSRS. “ An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. —> 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: The EXECUTE permission was denied on the object ‘xp_sqlagent_notify’, database ‘mssqlsystemresource’, schema ‘sys’ .” Cause is configurations isses and provisioning issues of Reporting Server User on Related Databases (Master , SSRS) You can resolve the issue by re run the script on your database server. For that you can downlod the report from the Central Admin by Application Management  ->  Manage service applications Then go to Reporting server service app

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

  This error occured to me when i triyng to connect to a SQL database from SharePoint App which is use Entity Framework. This is a timeout issue when app is trying to connect to a SQL database and connection was expired before execution. I simply connected it adding a Coonection Timeout to the connection string. <add name="dbtemponeEntities" connectionString="metadata=res://*/DataModels.dbtempone.csdl|res://*/DataModels.dbtempone.ssdl|res://*/DataModels.dbtempone.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=ASQL;initial catalog=dbtempone;persist security info=True; Connection Timeout=120 ;user id=SQLAdmin;password=*****$so;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

Dissable paging in SSRS Reports on SharePoint 2013

  I have a problem with showing a entire report (without page brakes) in the SharePoint with the ssrs integrated mode. I have tried many options and nothing work but changing the Height of the InteractiveSize to 0 worked for me