microsoft.public.sqlserver.notificationsvcs
[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
Hi,

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 
services."

The Event Viewer error log has the following:

****************

<NotificationServicesEvent>
 <Description>
  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.
 </Description>
 <Context>

<SqlServerError>
 Source: .Net SqlClient Data Provider
 Number: 2812
 State: 62
 Class: 16
 Server: DEMOSERVER
 Message: Could not find stored procedure 
'master.dbo.xp_NSPermissions_2_0_3008_0'.
 Procedure: NSCheckGeneratorAndXp
 Line Number: 9
</SqlServerError>

 </Context>
 <Description>
  Could not find stored procedure 'master.dbo.xp_NSPermissions_2_0_3008_0'.
 </Description>
 <Instance>ScorecardAlertInstance</Instance>
 <Component>Service</Component>
 <ComponentDetails>
ServiceName: NS$ScorecardAlertInstance
 </ComponentDetails>
 <Thread>5</Thread>
</NotificationServicesEvent>

****************

Thoughts?

Alan



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