Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
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 ID | : | 947985 |
| Last Review | : | February 26, 2008 |
| Revision | : | 1.0 |
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.
Back to the top
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 name | Original version | New version |
|---|
| Dtspump.dll | 2000.80.2039.0 | 2000.90.1187.0 |
| Dtspkg.dll | 2000.80.2039.0 | 2000.90.1187.0 |
| Sqldmo.dll | 2000.80.2039.0 | 2000.85.1054.0 |
| Dtsffile.dll | 2000.80.2039.0 | 2000.90.1187.0 |
| Custtask.dll | 2000.80.2039.0 | 2000.90.1187.0 |
These DLLs are located in the following folder:
%ProgramFiles%\Microsoft SQL Server\80\Tools\Binn
Back to the top
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 (http://kbalertz.com/Feedback.aspx?kbNumber=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:| a. | Extract the package. | | b. | 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. |
Back to the top
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top
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 |
Back to the top
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please