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…


Error while impersonating an user in SQL Server Analysis Services

  Hi folks, recently I came across an interesting issue related to impersonation in SSAS and I thought of sharing with you. Scenario and Issue: Let’s say we are trying to impersonate a user while browsing a cube in SSAS (Fig2). You might encounter with below error(Fig1). In first occurrence, it might feel like this…


Analysis Service 2016 Model gets corrupted if you add unsupported parameter while configuring the data source

Applies To: Tested on SQL Server Analysis Service 2016   Hello Everyone, today I am going to discuss about a known issue is Analysis Service 2016 Tabular Model. If you have built an Analysis Service tabular project and added some unsupported content in the data source, then neither you will able to open the Model from…


Accessing SSRS URL hosted on Azure VM over the Internet

There might be a requirement where you would like the SQL Server Reporting Services URL hosted on your on premise environment to be accessed over the Internet (outside of your domain). This can be achieved by hosting Reporting Services on an Internet-facing Web server to distribute general information to the public at large or private…


Creating dynamic SSIS package [Object model] and using OleDBSource & OleDBDestination internally fails in SSIS 2016

  Issue: While dynamically creating SSIS packages using the object model and referencing the following SSIS libraries, you may receive the following exception thrown SSIS Libraries referenced: C:\Program Files (x86)\Microsoft SQL Server\130\SDK\Assemblies\ SqlServer.DTSPipelineWrap.dll SQLServer.ManagedDTS.dll SQLServer.DTSRuntimeWrap.dll    Error Message: System.Runtime.InteropServices.COMException’ occurred in ConsoleApplication1.exe Additional information: Exception from HRESULT: 0xC0048021 {“Exception from HRESULT: 0xC0048021”}    at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSDesigntimeComponent100.ProvideComponentProperties()…


Connecting to SQL Server Using PowerShell

In this blog, I would like to show you how we can connect to a SQL Server Instance using PowerShell cmdlets. Let us consider a situation where you are in a remote machine and you don’t have SQL Server Management Studio(SSMS) client tool to access the SQL Server and you would like to query your…