Microsoft KB Archive/829091

From BetaArchive Wiki
Knowledge Base


BUG: Database Components Are Not Installed When You Install SQL Server Notification Services

Article ID: 829091

Article Last Modified on 11/21/2006



APPLIES TO

  • Microsoft SQL Server Notification Services 2.0 Service Pack 1
  • Microsoft SQL Server Notification Services 2.0
  • Microsoft SQL Server 2000 Standard Edition




SYMPTOMS

When you install Microsoft SQL Server 2000 Notification Services, SQL Server 2000 Notification Services database components are not installed. You may receive the following error message:

The database components require a qualified version of SQL Server on the machine.



This problem occurs even when SQL Server 2000 is installed on the computer where you want to install SQL Server 2000 Notification Services.

CAUSE

When you remove an instance of SQL Server 2000, the Sqdedev.dll file may also be removed from the computer. If the Sqdedev.dll file is not available on the computer where you want to install SQL Server 2000 Notification Services, the problem that is mentioned in the "Symptoms" section of this article may occur.

WORKAROUND

To work around this problem, copy the Sqdedev.dll file on your computer. To do so, follow these steps:

  1. Note the version of SQL Server 2000 that is running on the computer where you want to install SQL Server 2000 Notification Services.
  2. Copy the Sqdedev.dll file that corresponds to your version of SQL Server 2000 to the <drivename>\Program Files\Microsoft SQL Server\80\Tools\Binn folder (where <drivename> is the name of the drive that you selected when you installed SQL Server 2000.


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section of this article.

MORE INFORMATION

Microsoft SQL Server 2000 Notification Services requires the Sqdedev.dll file to identify the version of Microsoft SQL Server that is installed on a computer. Therefore, the option to install the database components may not be available if the Sqdedev.dll file is not on the computer where you want to install SQL Server 2000 Notification Services.

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

321185 HOW TO: Identify Your SQL Server Service Pack Version and Edition


Keywords: kberrmsg kbbug KB829091