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…


ODBC Driver 11 and above fails with Output parameter of type SQL_VARIANT

Problem: If you have an application which is using ODBC driver 11 or above and is executing a stored procedure with an output parameter of type SQL_VARIANT, the execution fails with the following exception: An error encountered: SQLState = HY000, NativeError: 0, ErrorMessage: [Microsoft][ODBC Driver 11 for SQL Server]Protocol error in TDS stream. Please do…


A new release of ODBC for Modern Data Stores

  After more than 15 years since the last release, Microsoft is looking at updating the Open Data Base Connectivity (ODBC) specification. ODBC was first released in September of 1992 as a C-based call-level interface for applications to connect to, describe, query, and update a relational store. Since its introduction, ODBC has become the most…


Connection timeout issue with .NET Framework 4.6.1 – TransparentNetworkIPResolution

  Understanding of the issue: Client application using .NET Framework 4.6.1 fails to connect to SQL Server and the error we get is something like following. Error: ‘Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake failed or the server was unable to respond back in time. The duration spent…


How to perform a silent installation with SQL Server Migration Assistant (SSMA)

In this blog, I would like to discuss about how we can perform a silent installation (without constant interaction or prompts) of SQL Server Migration Assistant (SSMA). Please note that this method is not a documented and hence this post is provided “AS IS” with no warranties, conferring no rights. / supported scenario. As you…


SQLCMD 2014 fails to authenticate via Kerberos

  Understanding of the issue: When we try to execute a query on a SQL server from a remote machine using SQLCMD.exe, the connection goes via NTLM rather than KERBEROS even though all the pre-requisites for the Kerberos authentication is fulfilled.   When using SQLCMD of version 2012 and below, the connection goes via Kerberos…


The OLE DB provider "MSDASQL" for linked server " " supplied inconsistent metadata for a column.The column " " (compile-time ordinal 2) of object " " was reported to have a "DBCOLUMNFLAGS_ISLONG" of 0…

Applies To: SQL 2012 and above. (Requires supportability towards Multi-Subnet Failover) Understanding of the Issue: Let us consider a situation where we want to create a Linked Server to pull data from SQL Server Always On (using the Listener name) onto our local SQL Server (or another SQL Server) and along with it also leverage…


Error while connecting to SQL Server – “Could not connect because the maximum number of ‘1’ user connections has already been reached.”

Applies To: Tested on SQL Server 2008, 2008 R2, 2012 and 2014. Issue: In this blog, I would like discuss about one of most commonly faced issues that you may encounter when connecting to the SQL Server. When you try to connect SQL Server you may get the error below. The error can occur while connecting…


Report Manager: “System.InvalidOperationException: This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms.”

Applies To: Tested on SQL Server Reporting Services 2008, 2008 R2, 2012 and 2014. When you browse Report Manager URL, you get an HTTP 500 error or a blank page (in case if you have disabled friendly HTTP messages) on the browser window. When you check the Reporting Services log files you would find the…