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:
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:
- Note the version of SQL Server 2000 that is running on the computer where you want to install SQL Server 2000 Notification Services.
- 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