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:

It has helped me tremendously in finding errors quickly.

-- List all SSRS subscriptions 
USE [ReportServer];  -- You may change the database name. 
SELECT USR.UserName AS SubscriptionOwner 
      ,SCH.Name AS ScheduleName       
      ,CAT.[PathAS ReportPath 
      ,CAT.[DescriptionAS ReportDescription 
FROM dbo.Subscriptions AS SUB 
     INNER JOIN dbo.Users AS USR 
         ON SUB.OwnerID = USR.UserID 
     INNER JOIN dbo.[CatalogAS 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 

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:

Installing SP2 or SP1 CU # 8 solves the problem.