[Top] [All Lists]

Re: Installing Notification Services 2.0 on a SQL Server 2005 Server

Subject: Re: Installing Notification Services 2.0 on a SQL Server 2005 Server
From: Joe Webb
Date: Fri, 02 Dec 2005 10:49:00 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi Alan - 

SQLNS v2 requires SQL Server 2000 to run. SQLNS 2005 works only with
SQL Server 2005. As I understand your post, you want BSM to run on SQL
Server 2005 and it will use SQLNS v2.0. For this to happen, you'll
need to have side-by-side instances of SQL Server installed. 

This forum posting may help. 

Joe Webb
SQL Server MVP

Get up to speed quickly with SQLNS 

I support PASS, the Professional Association for SQL Server.

On Fri, 2 Dec 2005 08:50:46 -0500, "Alan Whitehouse"
<[email protected]> wrote:

>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:
> <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>
> Source: .Net SqlClient Data Provider
> Number: 2812
> State: 62
> Class: 16
> Message: Could not find stored procedure 
> Procedure: NSCheckGeneratorAndXp
> Line Number: 9
> </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>

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