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” custom component. He was having an issue in compiling/building his code in Visual Studio and getting Warning about the build process about indirect dependency on the .NET Framework assembly due to SSIS references. Error: The primary…


Setting up database mirroring with certificates

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. As explained in BOL here, this is called setting up Inbound…


.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 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 issue description. Database mirroring is first introduced in SQL Server 2005 for…


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 SQL Server 2008 edition (including SQL Server Express Edition) with ADO.NET using SQLClient provider. 2) Only Shared Memory is enabled for protocols for SQL Server Instance 3) All client protocols are enabled for SQL Native Client and SQL…


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, 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: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server…


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 render a RS 2008 Report in SharePoint integrated mode, the following error occurs when clicking on the report: An unexpected error occured while connecting to the report server. Verify that the report server is available and configured for…