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…


A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The Local Security Authority cannot be contacted)

Symptoms: Connections to the SQL Server fails after certain windows update and getting the below error: Error: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The Local Security Authority cannot be contacted) —> System.ComponentModel.Win32Exception (0x80004005): The Local Security Authority cannot…


Intermittent JDBC Connectivity issue – The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: SQL Server returned an incomplete response. The connection has been closed

Symptoms: When connections are repeatedly made to SQL Server, one can observe about ~ 1% of connections having inability to connect.  The user witnesses the following error message, Error: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “SQL Server returned an incomplete response. The…