Microsoft SQL Server Support Blog

By Gregory Suarez | Sr. Escalation Engineer | SQL Server I was recently working with one of our customers when he indicated it would be great if the Microsoft Linux ODBC driver could be used to access his other database systems - in addition to Microsoft...

By Gregory Suarez | Sr. Escalation Engineer | SQL Server   The CTP release of the Microsoft SQL Server ODBC Driver for Linux ( http://www.microsoft.com/download/en/details.aspx?id=28160 ) opens many  opportunities for Red Hat Enterprise Linux...

The other day I was working with a customer who was in the process of developing SSIS "Control Flow" custom component. He was having an issue in compiling/building his code in Visual Studio and getting Warning about the build process about indirect...

We use certificates while setting up database mirroring for two partners that are in a workgroup or in non-trusted domains.   The idea is to create a certificate on each partner, export it to the other and then setup a login to use that certificate...

Recently I got a case and the customer was trying to create an SSIS package to e-mail results of several files to several individuals and he wanted to know if there is any inbuilt task in SSIS out of the box that can do this. He was saving few files in...

In this blog I will discuss a connection timeout issue that one of my customers was having after failing over the mirror database. For better understanding of the issue let me discuss some key terms/concepts of database mirroring before I get into the...

Consider the following scenario: 1) You have a .NET 4.0 application connecting to SQL Server 2005 or SQL Server 2008 edition (including SQL Server Express Edition) with ADO.NET using SQLClient provider. 2) Only Shared Memory is enabled for protocols for...

Recently we had few cases, where .NET Applications, connecting to a mirrored SQL Server Database, using ADO.NET SQLClient provider, in a mirrored SQL Server 2005 or SQL Server 2008 instance scenario, may intermittently fail with the following error message...

Consider this scenario where you have a linked server from one SQL server to another SQL Server. Both the SQL Servers are SQL Server 2008 SP2 on Windows 2008. Say the two SQL Servers are Server A and Server B. Linked server from Server A to Server B is...

  The Denali discs will not contain any of the Books Online content; setup only installs the help viewer and a handful of utility .chm files. All of the BOL documentation will by default come from online (MSDN). With the Microsoft strategy moving...

Recently we had a case where customer wanted to stream output parameter using SNAC 11. Rather than let the good research go to waste, we're posting the steps here.  It’s not optimum or sometimes  not even possible to define  large buffer ...

If SharePoint 2007 is configured to use Web SSO authentication by using ADFS v1 , when trying to render a RS 2008 Report in SharePoint integrated mode, the following error occurs when clicking on the report: An unexpected error occured while connecting...

When a package is being loaded, the runtime will enumerate all of the connection managers, tasks, and data flow components on the system. It does this by looking in certain directories (under <sql>\100\dts), and also by looking in COM registry for...

Recently we came across a case where the customer was running a Data Flow Task that was executing to it's completion without transferring any data.  We finally figured out the whys. Rather than let the good research go to waste, we're posting the...

Recently we came across a case where the customer was developing a .NET managed application using SQL Server Integration Services (SSIS) object model.  The managed application was behaving differently in different versions of Visual Studio (2008...

If you try to view a netmon trace in Netmon 3.4, you will see TDS traffic is nicely parsed for you. You will see a display similar to this: The parsing works nicely because SQLServer is listening on default tcp port 1433. But, if your SQLServer is listening...

While debugging a dump, we commonly see various CPU registers. Each register has different purpose. I am trying to put them together in one place for your easy reference.   You can list all the registers in windbg with “r” command:   Please...

Recently I have worked on couple of cases where customers were trying to use N-tier configuration of Sync services for ADO.NET on IIS. In this blog we will use IIS and setup N-tier configuration of sync service for ADO.NET version 2.0 which comes as part...

The .NET Framework 3.5 SP1 (also referred to as .NET Framework 3.5.1) is a prerequisite for SQL Server 2008. SQL Server 2008 Setup for standalone instance will install the .NET Framework 3.5 SP1 if it is not already installed. In Windows Server 2008 R2...

Creating a HTTP endpoint in SQL Server 2005 or SQL Server 2008 may fail with the following error messages: Msg 7850, Level 16, State 1, Line 1 The user 'domain\myuser' does not have permission to register endpoint 'training_sql_endpoint' on the...

A WinDbg extension DLL is set of exported callback functions for implementing user defined commands to extract specific customized information from the memory dump(s). Extension DLLs are loaded by debugger engine and can provide extra functionality of...

The Issue: A 64-bit process can load only 64-bit components in it's process boundary. Same is true for a 32-bit process also. So, if your application is 64 bit, you will need a 64-bit provider or driver to connect to Microsoft Access (mdb, accdb) or...

  There is a known issue with SQL Server setup when MSXML6 component update has been installed on the system. The problem described in KB 968749 http://support.microsoft.com/kb/968749 has raised a lot of concerns by customers. The concerns are related...

Technorati Tags: SQL Port The following post describes how you can configure your SQL Server to listen on a different port(s) on different IP addresses that are available on your system. This procedure applies to both SQL server 2005 and SQL server...

Working with very large SQL Compact files, you may run into two issues: 1. Manipulating a large SQL Compact database in VS 2008 IDE requires a hotfix http://support.microsoft.com/kb/968436 Error message when you use the Visual Studio...