Monday, May 30, 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.

image

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

image

Then go to Reporting server service application

image

and clisk and download the script and execute in the database server.

image

Thursday, May 26, 2016

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" />

Wednesday, May 11, 2016

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

image