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…


Date format Issues in SSIS Packages between MM/dd/yyyy & dd/MM/yyyy

In this blog, I would like to address one of the interesting issues that I came across recently with the SQL Server Integration services packages related to the inconsistencies noticed with the Date format. In this scenario, the SSIS packages were using a system variable @[System::StartTime], which was giving the value in format as ’18/08/2016…


Loading SSAS Tabular Databases in SSMS fails for Non-admin users with “Failed to retrieve data for this request”

I was working with one of my customers where he came across the following issue. I thought of sharing the info related to this, because I didn’t find any articles online that talks about this issue. The issue is, users are getting the below error when they are connecting to SSAS tabular instance using SQL…


Migrating Oracle to SQL Server using SSMA – Error: Cannot find either column “ssma_oracle” or the user-defined function or aggregate “ssma_oracle.rpad_varchar”

Issue: You are trying to migrate server objects and data from Oracle to SQL Server using SSMA for Oracle and for a particular view which has the RPAD function and getting the following error while performing database synchronization. Errors: Cannot find either column “ssma_oracle” or the user-defined function or aggregate “ssma_oracle.rpad_varchar”, or the name is…


SSAS (ROLAP) with Azure SQL Data Warehouse

  Let’s consider you are using SQL Server Analysis Services in MOLAP (Multi-Dimensional Online Analytical Processing) Storage Mode with Azure SQL Data Warehouse and everything has been working as expected. Due to a requirement, the Storage Mode was changed to ROLAP (Relational Online Analytical Processing) Mode.   Now when you try to execute a simple…