"Joe Webb" wrote:

> Hi Jplankala -
>
> The db user that the service uses requires access to the instance,
> application, and master databases. It also must be granted permissions
> to execute extended stored procedures. The easiest way to do this is via
> the GrantXpExec.cmd file in the install bin folder.
>
> Have you executed that for the user in question?
>
> HTH...
> Joe Webb
> SQL Server MVP
>
> ~~~
> Get up to speed quickly with SQLNS
> http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
>
>
>
> jplankala wrote:
> > Whenever I try to run the Notification services from, the services is
> > getting stopped immediatley after getting started. The error message I am
> > geting is
> >
> > "The XYZ Service on Local Computer started and stopped. Some Services stop
> > automatically if they have no work to do, for example, The performace logs
> > and Alerts Service."
> >
> >
> > When I verified the eventlogger, The error message says the SP
> > "master.dbo.xp_NSPermissions_2_0_3008_0" is not available .( The whole log
> > message is given below). I tried to run "GrantXpExec.cmd" but falied to run
> > successfully.
> >
> > Please help me to resolve this.
> >
> > I am using SQL server 200 Evaluation version and .NET Framework 1.1
> >
> >
> > ------------------------
> >
> > Event Viewer error message.
> > ------
> >
> > "<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: VZTEST-JOBY
> > Message: Could not find stored procedure
> > 'master.dbo.xp_NSPermissions_2_0_3008_0'.
> > Procedure:
> > Line Number: 9
> > </SqlServerError>
> >
> > </Context>
> > <Description>
> > Could not find stored procedure 'master.dbo.xp_NSPermissions_2_0_3008_0'.
> > </Description>
> > <Instance>RealtorInstance</Instance>
> > <Component>Service</Component>
> > <ComponentDetails>
> > ServiceName: NS$RealtorInstance
> > </ComponentDetails>
> > <Thread>204</Thread>
> > </NotificationServicesEvent>
> >
> >