Both of these responses are absolutely correct.
I'd also like to suggest that you review the Notification Services Books
Online Topic:
"NS$instance_name Service Account Security"
It discusses the various types of accounts you can use, but also it
contains a section on required permissions. Here is a snippet from that
topic:
Windows Permissions Required by the Service Account
The account under which the NS$instance_name service runs must have the
following permissions:
Read permission in the Notification Services folder (Program
Files\Microsoft SQL Server Notification Services\vn.n.n.n) and subfolders.
By default, only members of the local Administrators and Power Users groups
have access to the files within these folders.
Permission to log on as a service. This right is granted by the NSControl
Register command when you create the service.
Permission to read and write registry keys at the following registry
locations: HKEY_LOCAL_MACHINE\Software\Microsoft\NotificationServices and
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services.
Read and modify permissions in the events folder. For applications using
the file system watcher event provider, the event provider must be able to
read and rename files in the folder where events are dropped. This requires
the service to have read and modify permissions in that folder.
Write permission in the notifications folder. For applications using the
File delivery protocol to post notifications, the service account must have
the write permission in the folder where the notifications are written.
Possibly membership in the local Administrators group. If an application
hosted by the instance uses the Internet Information Services (IIS) Simple
Mail Transfer Protocol (SMTP) service to send notifications, the
distributor must send those notifications in the context of an
administrator. So, for any NS$instance_name service that runs the
distributor component and sends notifications through IIS SMTP, the service
account must be a member of the local Administrators group.
Important The service also must have permissions in the SQL Server
databases used by the instance. For more information, see SQL Server
Permissions for NS$instance_name.
Hope that helps!
Donna Lambert
Microsoft SQL Server Support Engineer
--------------------
| From: "Colin Meek [MSFT]" <CMeek@online.microsoft.com>
| References: <OdAeT6MuEHA.3728@TK2MSFTNGP10.phx.gbl>
<#2XOkoouEHA.2136@TK2MSFTNGP15.phx.gbl>
| Subject: Re: I am getting 1053 erro code
| Date: Mon, 25 Oct 2004 08:18:33 -0700
| Lines: 50
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.3790.181
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
| Message-ID: <uURIGZquEHA.2136@TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.notificationsvcs
| NNTP-Posting-Host: tide70.microsoft.com 131.107.71.225
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP0
8.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.notificationsvcs:2804
| X-Tomcat-NG: microsoft.public.sqlserver.notificationsvcs
|
| When the service fails to start, the event log is a good place to diagnose
| the problem (run 'eventvwr'). NS logs application error events on
failures.
|
| -Colin Meek [MSFT]
|
| --
| This posting is provided "AS IS" with no warranties, and confers no
rights.
| Use of included script samples are subject to the terms specified at
|
http://www.microsoft.com/info/cpyright.htm. |
| Please do not send e-mail directly to this alias. This alias is for
| newsgroup purposes only.
| --
|
[quoted text, click to view] | "Joe Webb" <joew@webbtechsolutions.com> wrote in message
| news:#2XOkoouEHA.2136@TK2MSFTNGP15.phx.gbl...
| > When the service fails to start, it's very likely that the problem is a
| > permissions issue. Make sure that the account specified in the
| > NS$<InstanceName> service has permission to log in to SQL Server and has
| > permission to use the <InstanceName>NSMain and <InstanceName><AppName>
| > databases. Try re-registering the the instance using NSControl register
| > and make sure you're specifying the right account/password combo. (Best
| > to you a domain account if possible).
| >
| > Also, look at the GrantPermissions.cmd text file that comes with the
| > sample apps for more information.
| >
| >
| > HTH...
| > Joe Webb
| >
| > ~~~
| > Get up to speed quickly with SQLNS
| >
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 | >
| >
| >
[quoted text, click to view] | > SqlJunkies User wrote:
| > > Hai
| > > when i am going to start my services in local machine i am
getting
| error 1053.. i dodn't know that what actually problem.
| > > please help me in that problem
| > >
| > > ---
| > > Posted using Wimdows.net NntpNews Component -
| > >
| > > Post Made from
http://www.SqlJunkies.com/newsgroups Our newsgroup
engine
| supports Post Alerts, Ratings, and Searching.
|
|
|