[Top] [All Lists]

Installing Notification Services 2.0 on a SQL Server 2005 Server

Subject: Installing Notification Services 2.0 on a SQL Server 2005 Server
From: "Alan Whitehouse"
Date: Fri, 2 Dec 2005 08:50:46 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs

Anyone know what you have to do to make this work?  I need this in order to 
complete an implementation of Business Socrecard Manager who supports SQL 
2005 but says for Notification Services you need to use version 2.0.

When I run the installation routine for Notification Services I cannot 
select the Database Components selection because when I do I get an error 
stating "The database components require a qualified version of SQL Server 
on the machine".

When I install without the database components then try to start the 
Notification Services service it fails and I get an error message stating 
"Service 'NS$ScorecardAlertInstance' (NS$ScorecardAlertInstance) failed to 
start.  Verify that you have sufficient privileges to start system 

The Event Viewer error log has the following:


  The service account does not have sufficient privileges to run some 
extended stored procedures. Please run the command GrantXpExec.cmd to grant 
the required rights.

 Source: .Net SqlClient Data Provider
 Number: 2812
 State: 62
 Class: 16
 Message: Could not find stored procedure 
 Procedure: NSCheckGeneratorAndXp
 Line Number: 9

  Could not find stored procedure 'master.dbo.xp_NSPermissions_2_0_3008_0'.
ServiceName: NS$ScorecardAlertInstance




<Prev in Thread] Current Thread [Next in Thread>