Changing Agent User

I have to change the Sql Server 7 startup account from LocalSystem to a
domain account. This domain account has the same permissions that SA does.
As long as the new domain account has the same set of permissions, there
should be no problem with executing jobs, accessing objects, etc.? Can
anyone recommend a reference/article on the implications behind changing the
user?
Thank youSearch Books Online for "level token" and you'll find the attributed you need to give the new
service account. If you change the account using EM, these permissions will be set by EM.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Ick" <nospamplease> wrote in message news:%23bEf7r4gDHA.2248@.TK2MSFTNGP09.phx.gbl...
> I have to change the Sql Server 7 startup account from LocalSystem to a
> domain account. This domain account has the same permissions that SA does.
> As long as the new domain account has the same set of permissions, there
> should be no problem with executing jobs, accessing objects, etc.? Can
> anyone recommend a reference/article on the implications behind changing the
> user?
> Thank you
>|||Thank you Tibor. This is very helpful (although I would never have thought
to search under that phrase lol - I guess that is why you are the MVP and I
am the lowly n00b)
;-)
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:OdHNz2AhDHA.2296@.TK2MSFTNGP09.phx.gbl...
> Search Books Online for "level token" and you'll find the attributed you
need to give the new
> service account. If you change the account using EM, these permissions
will be set by EM.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "Ick" <nospamplease> wrote in message
news:%23bEf7r4gDHA.2248@.TK2MSFTNGP09.phx.gbl...
> > I have to change the Sql Server 7 startup account from LocalSystem to a
> > domain account. This domain account has the same permissions that SA
does.
> >
> > As long as the new domain account has the same set of permissions, there
> > should be no problem with executing jobs, accessing objects, etc.? Can
> > anyone recommend a reference/article on the implications behind changing
the
> > user?
> >
> > Thank you
> >
> >
>|||I'm glad it helped. Reason I remember this is from me training, wanting to have as few characters to
write on the whiteboard. I.e., all about being lazy :-).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Ick" <nospamplease> wrote in message news:eczFhMChDHA.4468@.TK2MSFTNGP12.phx.gbl...
> Thank you Tibor. This is very helpful (although I would never have thought
> to search under that phrase lol - I guess that is why you are the MVP and I
> am the lowly n00b)
> ;-)
> "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:OdHNz2AhDHA.2296@.TK2MSFTNGP09.phx.gbl...
> > Search Books Online for "level token" and you'll find the attributed you
> need to give the new
> > service account. If you change the account using EM, these permissions
> will be set by EM.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >
> > "Ick" <nospamplease> wrote in message
> news:%23bEf7r4gDHA.2248@.TK2MSFTNGP09.phx.gbl...
> > > I have to change the Sql Server 7 startup account from LocalSystem to a
> > > domain account. This domain account has the same permissions that SA
> does.
> > >
> > > As long as the new domain account has the same set of permissions, there
> > > should be no problem with executing jobs, accessing objects, etc.? Can
> > > anyone recommend a reference/article on the implications behind changing
> the
> > > user?
> > >
> > > Thank you
> > >
> > >
> >
> >
>