Re: Installing Notification Services 2.0 on a SQL Server 2005 Server
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.
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:
> 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
> Server: DEMOSERVER
> Message: Could not find stored procedure
> Procedure: NSCheckGeneratorAndXp
> Line Number: 9
> Could not find stored procedure 'master.dbo.xp_NSPermissions_2_0_3008_0'.