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…


Running SSIS packages outside the Developer tools using DTEXEC.exe without installing the Integration services.

In this blog, I would like to address one of the important information about SQL Server Integration services licensing. Say that you had installed the Visual Studio – SQL Server Data Tools (SSDT) / Business Intelligence Development Studio (BIDS) and developed your SSIS packages on your development machines. The SSIS packages has some Script tasks…


SSAS cube design errors while creating data source views for Teradata tables with columns having default date constraint

Issue: While trying to create a data source view (DSV) on the SSAS project connecting to a Teradata source table which has a DateTime column with a default_date constraint, we get the below errors: Error: “The string was not recognized as a valid DateTime. There is an unknown word starting at index 0. (Microsoft Visual…