Browse Site by Tags - MSMVPS.COM

Error message when an application connects to SQL Server on a server that is running Windows Server 2003: "General Network error," "Communication link failure," or "A transport-level error"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Error message when an application connects to SQL Server on a server that is running Windows...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 10-07-2007
Filed under: sql server, server, kba, connections, failure, general network error, transport-level, link, windows 2003, communication

FIX: Error message when you use SQL Native Client to connect to an instance of a principal server in a database mirroring session: "The connection attempted to fail over to a server that does not have a failover partner"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Error message when you use SQL Native Client to...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 09-21-2007
Filed under: sql server, instance, kba, connections, database mirroring, principal, native

How to change the network IP addresses of SQL Server failover cluster instances

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications How to change the network IP addresses of SQL Server failover cluster instances http://support.microsoft.com/kb/244980/en-US...( read...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-29-2007
Filed under: sql server, kba, connections, clustering, network, failover

FIX: Performance is very slow when the same stored procedure is executed at the same time in many connections on a multiple-processor computer that is running SQL Server 2005

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: Performance is very slow when the same stored...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-23-2007
Filed under: sql server, performance, kba, connections, stored procedure, slow, multi-processor

SQL Server logs 17832 with multiple TCP\IP connection requests

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications SQL Server logs 17832 with multiple TCP\IP connection requests http://support.microsoft.com...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-22-2007
Filed under: sql server, kba, connections, 17832, tcp/ip

FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections http://support.microsoft.com/kb/937745/en-US...( read more )

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 06-04-2007
Filed under: sql server, kba, enterprise, concurrent, connections