PRB: Commerce Server requires at least 98 available SQL 2000 connections (320597)


The information in this article applies to:

  • Microsoft Commerce Server 2002
  • Microsoft Commerce Server 2000
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:
    Site Name
    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.

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

870643 The Commerce Server 2002 Profile Service creates many connections to SQL Server

Modification Type:MinorLast Reviewed:8/12/2004
Keywords:kbfix kbnofix kbpending kbprb KB320597
©2004 Microsoft Corporation. All rights reserved.