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

Article translations Article translations
Article ID: 947985 - View products that this article applies to.
Expand all | Collapse all

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.
Collapse this tableExpand this table
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: February 26, 2008 - Revision: 1.2
APPLIES TO
  • 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
Keywords: 
kbexpertiseadvanced kbtshoot kbprb KB947985

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com