Commerce Server 2000 or Commerce Server 2002 Installer error 8000ffff when you specify SQL Server connection (281299)


The information in this article applies to:

  • Microsoft Commerce Server 2002
  • Microsoft Commerce Server 2000
This article was previously published under Q281299

SYMPTOMS

When you try to install Microsoft Commerce Server 2000 or Commerce Server 2002, after you specify the Microsoft SQL Server connection information for the Administration database (MSCS_admin), you may receive an error message that is similar to the following:
Title: Commerce Server 2000 Installer

Error: SQL Error encountered

Description: Execution of the TSQL command "select * from sysdatabases where name='MSCS_Admin'" failed with error code 8000ffff. Please verify that the SQL Server and Administrator user credentials specified are correct.
An event that is similar to one of the following events may be logged in the Application Event Log:
Source: MsiInstaller
Category: None
Event ID: 1000
Type: Error
Description:
Product: Commerce Server 2000 -- Commerce Server 2000 WARNING: A failure occurred in SendTSQLCommand() on d:\cs40\private\cs40\setup\ca_dll\database.cpp:731. The error description is: Execution of the TSQL command "select * from sysdatabases where name='MSCS_Admin'" failed with error code -2147418113.

Source: MsiInstaller
Category: None
Event ID: 1000
Type: Error
Description:
Product: Commerce Server 2000 -- Commerce Server 2000 WARNING: A failure occurred in SendTSQLCommand() on d:\cs40\private\cs40\setup\ca_dll\database.cpp:733. The error code is -2147418113, and the description is: Catastrophic failure

CAUSE

This problem can occur for several reasons:
  • Microsoft SQL Server service is not started.
  • SQL Server 2000 was installed with no default instance.
  • You installed to a SQL Server 2000 Named instance, but you entered the instance name incorrectly.
  • You have the wrong version of Microsoft Data Access Components (MDAC).
  • For Commerce Server 2000, SQL Server was not installed in Mixed Mode. Mixed Mode Authentication is the only mode supported by Commerce Server 2000.

    Note For Commerce Server 2002, SQL Server can be installed in Mixed Mode or only Windows Authentication.

RESOLUTION

Use one of the following methods to resolve this problem:
  • Make sure that SQL Server service is started.
  • If you install to the default instance of SQL Server 2000, verify that the default instance is running, and enter the ServerName when you are prompted by the Commerce Server installer.
  • If you install to a named instance of SQL Server 2000, you must specify the instance name as ServerName\InstanceName.
  • Make sure that you have MDAC version 2.6 or later.
  • Change the authentication mode from Windows only to SQL Server and Windows. (In SQL Server Enterprise Manager, right-click Properties, on the Security tab, click Authentication property, and then set it to SQL Server and Windows.)

REFERENCES

For more information on SQL Server 2000 Named instances, see the SQL Server 2000 online documentation.
Modification Type:MajorLast Reviewed:11/22/2004
Keywords:kbprb KB281299
©2004 Microsoft Corporation. All rights reserved.