Monday, June 15, 2015
SSRS Report Builder "Application cannot be started, contact application vendor"
The problem might be the application could not be started from your client machine.
If the activation error throws then it would be the problem of your downloaded application has corrupted in your application temporary area.
So follow the below steps to fix.
1) Go to the C:\Users\[User Name]\AppData\Local\Apps\2.0
Delete the all temporay files.
2) Re launch the application
It will work fine.
Friday, June 12, 2015
List all SSRS subscriptions
The following script was originally conceived by Olaf Helper:
https://gallery.technet.microsoft.com/scriptcenter/List-all-SSRS-subscriptions-968ae4d5
It has helped me tremendously in finding errors quickly.
https://gallery.technet.microsoft.com/scriptcenter/List-all-SSRS-subscriptions-968ae4d5
It has helped me tremendously in finding errors quickly.
-- List all SSRS subscriptions USE [ReportServer]; -- You may change the database name. GO SELECT USR.UserName AS SubscriptionOwner ,SUB.ModifiedDate ,SUB.[Description] ,SUB.EventType ,SUB.DeliveryExtension ,SUB.LastStatus ,SUB.LastRunTime ,SCH.NextRunTime ,SCH.Name AS ScheduleName ,CAT.[Path] AS ReportPath ,CAT.[Description] AS ReportDescription FROM dbo.Subscriptions AS SUB INNER JOIN dbo.Users AS USR ON SUB.OwnerID = USR.UserID INNER JOIN dbo.[Catalog] AS CAT ON SUB.Report_OID = CAT.ItemID INNER JOIN dbo.ReportSchedule AS RS ON SUB.Report_OID = RS.ReportID AND SUB.SubscriptionID = RS.SubscriptionID INNER JOIN dbo.Schedule AS SCH ON RS.ScheduleID = SCH.ScheduleID ORDER BY USR.UserName ,CAT.[Path];
How to determine the version and edition of SQL Server and its components
To determine the version of the client tools that are installed on your system, start Management Studio, and then clickAbout on the Help menu. (The screen shot for this step is listed below).
How to determine which version and edition of SQL Server Database Engine is running
Connect to the instance of SQL Server, and then run the following query:
Select @@version
Stacked toolbars SSRS report server
This problem is caused by the combination of Internet Explorer 11 and SQL Server 2012. The solution is described here:
https://connect.microsoft.com/SQLServer/feedback/details/810527/sql-server-reporting-services-is-not-compatible-with-internet-explorer-11
Installing SP2 or SP1 CU # 8 solves the problem.
Subscribe to:
Posts (Atom)