Microsoft KB Archive/281299

= Commerce Server 2000 or Commerce Server 2002 Installer error 8000ffff when you specify SQL Server connection =

Article ID: 281299

Article Last Modified on 7/10/2007

-

APPLIES TO


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

-



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 &quot;select * from sysdatabases where name='MSCS_Admin'&quot; 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 &quot;select * from sysdatabases where name='MSCS_Admin'&quot; 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

For example, you run the Microsoft Commerce Server 2000 Setup program. When you click Next in the Administration Database Configuration dialog box, you may receive this error message, even after you verify that the Microsoft SQL Server administrative user credentials are correct. Therefore, you cannot install Commerce Server 2000.



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.)

