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

    Posted over 3 years ago
    by SQL Server Support Content}
    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...

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

    Posted over 3 years ago
    by SQL Server Support Content}
    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...