If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
all the things that I should cross check to make sure that everything is
fine and smooth transition.
1. All scheduled job on SQL Server.
Any thing else I am missing in the above list?
SQL 2K.
Thanks,
SmithHi,
If you are changing to an Login account which has got the identical
privilege as old account then there is
no issues.
Thanks
Hari
SQL Server MVP
"Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
> If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
> all the things that I should cross check to make sure that everything is
> fine and smooth transition.
> 1. All scheduled job on SQL Server.
> Any thing else I am missing in the above list?
> SQL 2K.
> Thanks,
> Smith
>
>|||Thank you.
Smith
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eWaK7yZgFHA.572@.TK2MSFTNGP14.phx.gbl...
> Hi,
> If you are changing to an Login account which has got the identical
> privilege as old account then there is
> no issues.
> Thanks
> Hari
> SQL Server MVP
> "Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
> news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
> > If I change the login account for MSSQLSERVER and SQLSERVERAGENT what
are
> > all the things that I should cross check to make sure that everything is
> > fine and smooth transition.
> >
> > 1. All scheduled job on SQL Server.
> >
> > Any thing else I am missing in the above list?
> >
> > SQL 2K.
> >
> > Thanks,
> >
> > Smith
> >
> >
> >
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment