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

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137502&SiteID=1 


-- 
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)




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

>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>