Microsoft KB Archive/320597

= PRB: Commerce Server requires at least 98 available SQL 2000 connections =

Article ID: 320597

Article Last Modified on 8/12/2004

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition
 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q320597



SYMPTOMS
When you perform several processes with Commerce Server, you must have at least 98 Microsoft SQL Server 2000 connections available. For some of these processes, the use of these SQL connections is only temporary, although the following processes may have to maintain these connections:


 * Unpupping any of the solution sites (for example: Blank, Retail, Supplier Active Directory, CSharp, Visual Basic, and Retail 2002) with the Data Warehouse resource.
 * Adding the Data Warehouse resource to an existing site.
 * Accessing one of the solution sites through a Web browser.
 * Loading Commerce Server Business Desk on a client computer.



RESOLUTION
To resolve this problem, you must purchase additional SQL Server 2000 licenses or perform the task or tasks when there are at least 98 SQL connections available. When more than 98 connections are available, try the problem processes again.

NOTE: When you unpup a site, delete the site and the resources of the site before you try to unpup the site again.



MORE INFORMATION
When there are less than 98 connections available, the processes to unpup a solution site and to add a Data Warehouse resource do not complete successfully. Access to a solution site is denied because of an application error.   When you unpup the solution sites with the Data Warehouse resource, the process takes three or more times longer if you do not have at least 98 connections available. At the end of the unpup process, you receive the following error message:

Errors occurred during unpacking

The Pup.log file has an entry as follows: Failed to call method Run on Commerce.SyncAdminInterface.[xx:xx:xx] Error importing object data for VBBizDesk from file C:\Documents and Settings\xxxxx\Local Settings\Temp\VBBizDesk 80004005: Method '~' of object '~' failed  When you access a site with the Blank, Retail, or Supplier Active Directory solution sites, and the site has less than 98 connections available, you receive the following error message in the browser:

The page cannot be displayed

When you access a site with the CSharp and Visual Basic solution sites, you receive the following error message in the browser:

Server Application Unavailable

The Application event log has an MSSQLSERVER service entry with the following description:

Event ID: 17052 Error: 17809, Severity: 20, State: 1 Could not connect. The maximum number of 'xx' configured user connections are already connected. The system administrator can change the maximum to a higher value using sp_configure

 When you install the Commerce Server Business Desk application from the site to a client computer, it takes longer for the application to start if less than 98 connections are available. If it is the first time that you access the site, you must refresh your browser. Eventually, you are prompted for the installation path for the Business Desk application.

If fewer than 98 connections are available when you access the Business Desk application, you may receive the following error message:

Errors occurred while loading part of the Business Desk

In some cases, the Business Desk application may start, but only after a long response time. After it is loaded, the Business Desk application functions as expected.

