Microsoft SQL Server Support Blog

SQL Server information from the folks at Microsoft Support

Azure Analysis Services – How to use a different user account in reporting and development tools

All the tools, SSMS, SSDT, and Power BI Desktop share the IE cookies cache that stores the Azure...

Author: Haidong Huang Date: 01/25/2017

Azure Analysis Services – How to switch to a different user account in reporting tools

All the tools, SSMS, SSDT, and Power BI Desktop share the IE cookies cache that stores the Azure...

Author: Haidong Huang Date: 01/25/2017

Azure Analysis Services processing/refresh sample AMO code

Sample code to process object in Azure Analysis Services Visit this web page Data providers for...

Author: Haidong Huang Date: 01/25/2017

SSAS processing performance gain by using OLE DB provider for Oracle instead of using .NET provider for Oracle

Problem: You are unable to change the size set parameter in the data source of an SSAS model that...

Author: Haidong Huang Date: 01/25/2017

Azure Analysis Services Preview shows workspace databases not being deleted

Problem: You may see Analysis Services tabular model workspace databases remain on the Azure...

Author: Haidong Huang Date: 01/24/2017

Azure Analysis Services Preview -How to add security group

The information posted originally in this blog is now out-of-date due to change in the Azure...

Author: Haidong Huang Date: 01/24/2017

Azure Analysis Services connection error “The connection string is not valid”

Problem 1: When you try to design an SSRS report to get data form an Azure Analysis Services server,...

Author: Haidong Huang Date: 01/24/2017

Client unable to establish connection.. error when you configure ‘max server memory’ to a low value

When you inadvertently set SQL Server’s ‘max server memory’ to a very low value, you may experience...

Author: SQL Server Support Content Date: 08/24/2016

You are not able to start more than 4 SSAS tabular model instances with default configuration settings

I have worked on a few cases with this problem. You are not able to start more than 4 SSAS tabular...

Author: Haidong Huang Date: 07/27/2016

Excel 2016 PivotTable timeout error on SSAS data source after 1 minute

Excel 2016 PivotTable report may generate an error message after running the report for 1 minute....

Author: Haidong Huang Date: 06/10/2016

Excel 2016 PivotTable timeout error on SSAS data source after 1 minute

Excel 2016 PivotTable report may generate an error message after running the report for 1 minute....

Author: Haidong Huang Date: 05/04/2016

SSAS tabular model database fails to restore due to out of memory error

We have 2 customers getting an out of memory error when they backup or restore a large tabular model...

Author: Haidong Huang Date: 11/17/2015

Excel 2016 PowerPivot MDX query designer error

Problem: When you open Excel 2016, go to the Power Pivot tab, click the Mange button to bring up...

Author: Haidong Huang Date: 11/09/2015

How to import data from a Teradata database into Excel 2013 using LDAP authentication

Problem: Teradata can accepts authentication of different types. Teradata can authentication user...

Author: Haidong Huang Date: 09/29/2015

Power BI Personal Gateway supplemental information

Note: Power BI software is updated frequently. This is written based on the Power BI Personal...

Author: Haidong Huang Date: 08/27/2015

SSAS MOLAP dimension size limit

After the introduction of the StringStoresCompatibilityLevel property in SSAS dimension after SQL...

Author: Haidong Huang Date: 08/24/2015

SSIS execution time out error when using SSISDB stored procedure [catalog].[create_execution]

After SQL Server 2012 is released, SSISDB provides stored procedures to create SSIS package...

Author: Haidong Huang Date: 08/24/2015

Error in MDX query result cell is not shown in SSRS query designer

This is a very little known problem regarding how SSRS query designer having trouble showing cells...

Author: Haidong Huang Date: 08/24/2015

Performance problems on high cardinality column in tabular model

Marco Russo has a great article regarding optimization on high cardinality column in tabular model...

Author: Haidong Huang Date: 08/24/2015

Power BI PowerPivot report error after 30-second timeout

Power BI allows you to upload an Excel file that contains a report that gets data from the...

Author: Haidong Huang Date: 06/16/2015

SSAS DSV COM error from SSDT SSAS design Data Source View

Recently I worked on a case regarding a COM error when opening the data source view (DSV) of an...

Author: Haidong Huang Date: 06/10/2015

New SSAS tabular model parallel processing in SQL Server 2016 CTP2

There is a known limitation on SQL Server 2012 and 2014 SSAS tabular model. If you have a table with...

Author: Haidong Huang Date: 06/10/2015

PowerPivot scheduled data refresh should use an Oracle account that does not have password expiration

I have a customer who encountered a server hang issue on the PowerPivot SSAS instance. No PowerPivot...

Author: Haidong Huang Date: 06/10/2015

SSAS error “The operation has been cancelled because there is not enough memory for the application” when there is still a lot of memory available

In SQL Server Analysis Services (SSAS), you may encounter the following error message in the...

Author: Haidong Huang Date: 06/10/2015

What is SSAS error "An unexpected exception occurred" or 0xC1000016

When working with SQL Server Analysis Services, it is not uncommon to see this error message "An...

Author: Haidong Huang Date: 12/16/2014

Timeout expired while publishing to SQL Database via SSDT

We recently saw some cases where customer migrated their SQL Database to Basic edition. After the...

Author: Microsoft SQL Server Support Team Date: 11/13/2014

Is my query running fine in the cloud?

This is the fifth installment in a blog series. The previous entry is located here We ended the last...

Author: Microsoft SQL Server Support Team Date: 11/01/2013

Do I need to upgrade my DBA skills for the cloud?

This is the fourth installment in a blog series. The previous entry is located here Based on the...

Author: Microsoft SQL Server Support Team Date: 11/01/2013

Call the movers at 1800-Move-To-CloudDb

This is the third installment in a blog series. The previous entry is located here Based on the...

Author: Microsoft SQL Server Support Team Date: 11/01/2013

Is your WA SQL Database open to the world?

The introductory post in this blog series is located here Windows Azure SQL Database has a firewall...

Author: Microsoft SQL Server Support Team Date: 11/01/2013

Windows Azure SQL Database (WASD) Primer

Are you a SQL Server DBA who is now being asked to migrate databases to Windows Azure SQL Database...

Author: Microsoft SQL Server Support Team Date: 11/01/2013

Use Microsoft Linux ODBC Driver and Linked Server to access OLEDB Data sources on Remote Systems

By Gregory Suarez | Sr. Escalation Engineer | SQL Server I was recently working with one of our...

Author: SQL Server Support Content Date: 02/08/2012

Use Existing MSDN C++ ODBC Samples for Microsoft Linux ODBC Driver

By Gregory Suarez | Sr. Escalation Engineer | SQL Server The CTP release of the Microsoft SQL Server...

Author: SQL Server Support Content Date: 01/26/2012

How to get "Microsoft.sqlserver.msxml6_interop.dll" without buying SQL Server 2008

The other day I was working with a customer who was in the process of developing SSIS "Control Flow"...

Author: SQL Server Support Content Date: 12/07/2011

Setting up database mirroring with certificates

We use certificates while setting up database mirroring for two partners that are in a workgroup or...

Author: SQL Server Support Content Date: 08/24/2011

Sending several files to several individuals using SSIS Send Email Task

Recently I got a case and the customer was trying to create an SSIS package to e-mail results of...

Author: SQL Server Support Content Date: 06/14/2011

.NET application doesn’t connect to the SQL server after a Database mirroring failover

In this blog I will discuss a connection timeout issue that one of my customers was having after...

Author: SQL Server Support Content Date: 06/14/2011

App using SQLClient(.NET 4.0) will automatically construct an SPN when using shared memory with windows authentication

Consider the following scenario:1) You have a .NET 4.0 application connecting to SQL Server 2005 or...

Author: SQL Server Support Content Date: 05/25/2011

ADO.NET application connecting to a mirrored SQL Server Database may timeout long before the actual connection timeout elapses, sometimes within milliseconds

Recently we had few cases, where .NET Applications, connecting to a mirrored SQL Server Database,...

Author: SQL Server Support Content Date: 05/25/2011

Executing an INSERT statement on a View in linked server

Consider this scenario where you have a linked server from one SQL server to another SQL Server....

Author: SQL Server Support Content Date: 02/22/2011

No Books Online Content “in the box” for the next version of SQL Server– Denali

The Denali discs will not contain any of the Books Online content; setup only installs the help...

Author: SQL Server Support Content Date: 02/03/2011

Output parameter streaming feature in SQL Native client 11

Recently we had a case where customer wanted to stream output parameter using SNAC 11. Rather than...

Author: SQL Server Support Content Date: 01/18/2011

SharePoint 2007 using ADFS v1 authentication integrated with Reporting Services 2008 : "Object Moved" error

If SharePoint 2007 is configured to use Web SSO authentication by using ADFS v1, when trying to...

Author: SQL Server Support Content Date: 01/10/2011

Why SSIS package runs little slower on the first run

When a package is being loaded, the runtime will enumerate all of the connection managers, tasks,...

Author: SQL Server Support Content Date: 12/31/2010

Have you checked the MaximumErrorCount in your SSIS Package ?

Recently we came across a case where the customer was running a Data Flow Task that was executing to...

Author: SQL Server Support Content Date: 12/31/2010

Configuration changes needed for running SSIS 2008/2008 R2 classes in .NET4.0

Recently we came across a case where the customer was developing a .NET managed application using...

Author: SQL Server Support Content Date: 11/04/2010

How to enable TDS parser to display TDS frames when SQLServer is listening on port other than default 1433

If you try to view a netmon trace in Netmon 3.4, you will see TDS traffic is nicely parsed for you....

Author: SQL Server Support Content Date: 06/30/2010

Commonly used 32-bit CPU registers and their purpose

While debugging a dump, we commonly see various CPU registers. Each register has different purpose....

Author: SQL Server Support Content Date: 06/30/2010

Step by step N-tier configuration of Sync services for ADO.NET 2.0

Recently I have worked on couple of cases where customers were trying to use N-tier configuration of...

Author: SQL Server Support Content Date: 04/19/2010

How to install/enable .Net 3.5 SP1 on Windows Server 2008 R2 for SQL Server 2008 and SQL Server 2008 R2

The .NET Framework 3.5 SP1 (also referred to as .NET Framework 3.5.1) is a prerequisite for SQL...

Author: SQL Server Support Content Date: 01/08/2010

Next>