You are currently offline, waiting for your internet to reconnect

You cannot remove the GUEST account after you install the SQL Server 2005 client tools on a computer that has the SQL Server 2000 client tools installed

SYMPTOMS
You have a computer that has the Microsoft SQL Server 2000 client tools installed. You install the Microsoft SQL Server 2005 client tools on the computer.

For instances of SQL Server 2000 that are registered in Enterprise Manager, the GUEST account appears in all databases of these instances. This problem occurs even if you have removed the GUEST account from the databases before you install the SQL Server 2005 client tools.

Additionally, when you try to remove the GUEST account from the databases, you receive the following error message:
Error 15008: User 'guest' does not exist in the current database.
CAUSE
This problem occurs because some DLLs of the SQL Server 2000 client tools are updated after you install the SQL Server 2005 client tools. The following table lists the updated DLLs.
DLL nameOriginal versionNew version
Dtspump.dll2000.80.2039.02000.90.1187.0
Dtspkg.dll2000.80.2039.02000.90.1187.0
Sqldmo.dll2000.80.2039.02000.85.1054.0
Dtsffile.dll2000.80.2039.02000.90.1187.0
Custtask.dll2000.80.2039.02000.90.1187.0
These DLLs are located in the following folder:
%ProgramFiles%\Microsoft SQL Server\80\Tools\Binn
WORKAROUND
To work around this problem, follow these steps:
  1. Close SQL Server Enterprise Manager.
  2. Open the following folder:
    %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn
  3. Back up the Sqldmo.dll file in the Binn folder that you opened in step 2.
  4. Download the SQL Server 2000 service pack that matches the SQL Server 2000 service pack level that is installed on the computer.

    For more information about how to obtain a SQL Server 2000 service pack, click the following article number to view the article in the Microsoft Knowledge Base:
    290211 How to obtain the latest SQL Server 2000 service pack
  5. Extract the Sqldmo.dll file from the SQL Server 2000 service pack package. To do this, follow these steps:
    1. Extract the package.
    2. Locate the Sqldmo.dll file in the following folder:
      ExtractedPath\x86\binn
      Note ExtractedPath represents that folder where you extract the package.
  6. Copy the Sqldmo.dll file that you obtained in step 5 to the Binn folder that you opened in step 2.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Properties

Article ID: 947985 - Last Review: 02/26/2008 21:59:10 - Revision: 1.2

Microsoft SQL Server 2000 Developer Edition, Microsoft SQL Server 2000 Enterprise Edition, Microsoft SQL Server 2000 Personal Edition, Microsoft SQL Server 2000, Workgroup Edition, Microsoft SQL Server 2000 Standard Edition

  • kbexpertiseadvanced kbtshoot kbprb KB947985
Feedback