“Unexpected error from external database driver (1). (Microsoft JET Database Engine)” after applying October security updates.

  We have been seeing a recent influx in cases where the JET provider is no longer able to connect after the October update. This update (released October 10th, 2017) includes a security update release that inadvertently affects the JET provider. The update was kb4041678 and included in the patch kb4041681.  These patches affected the…


ARM Resource Manager Template Deployment with Azure Analysis Services

Analysis Services model can be deployed in Azure in different ways like from SSDT or by running the JSON create script from SSMS. We can leverage the richness of template deployment in our Azure Analysis Services as well. What is Template Deployment in Azure? The Resource Manager template you deploy can either be a local…


How to display report parameter Label field in RDLC reports

While working on customer issue recently, I came across following scenario where there was a problem in displaying the report parameter label filed in the RDLC reports. Scenario and issue: Let’s say we have report parameter called “Customer” in the RDLC report which get values from the “DataSet1” as shown below We have a text…


Reporting Services Web Services with .NET CORE 2

  Any application built using .NET CORE SDK can be executed on any platform (Windows, Linux & Mac). But due to this there are a lot of APIs available in .NET Framework that are no longer available in .NET CORE. One of the missing APIs is Web Service (SOAP) Clients. The way to move forward…


SQL Server Reporting Services 2016 Integration with an Application

There are multiple ways to integrate or embed SQL Reporting Services Report in an application. This can be achieved via:- URL Access Method Using SOAP APIs Using Report Viewer Control Couple of common issue that we face while calling reports in an application are: – How to pass credentials from application to SSRS. How to…


Automating Azure Analysis Service Processing using Azure Automation Account

  Analysis Services has been progressing day-by-day with new exciting features and there is an ask from the users to automate the Azure Analysis Services Processing. There are few ways which we can automate the processing. Using the conventional way what we have for the On-Prem. Using SQL Agent Job/ Using AMO Objects/ Using PowerShell….


SSRS – Bing Maps seem to be broken with latest changes in Bing Map Service

Reporting Services Reports that contain Bing Maps seem to broken due to a change in the Bing Map APIs. From the initial analysis, Bing Maps SOAP web service seems to be shut down after July 31, 2017. When we access the Bing Maps API from SSRS we are calling into this method http://dev.virtualearth.net/webservices/v1/imagery/contracts/IImageryService/GetImageryMetadata, and are…


Dynamically enable or disable the report printing option on the client side

Hello Everyone, in this blog I am going to discuss about an interesting scenario while working on a customer issue recently related to Client Printing of SSRS Reports. Scenario: Let’s say you want to disable Client Side Printing on Reporting Services when you open your reports through your application on Internet Explorer. You use Report…