Dear all,
Whenever that I change my password on domain NT, then MSSQLSERVER
service failed (local sql server of course). So that I've got to enter in
that service
and update the password manually on LOG ON flap.
At the same time when I open my enterprise manager not appears all those
Network Sql Serverthat before I had. '?
I would like to have automatically this change.
Any help will be welcomed,
Thanks in advance,Enric,
That means that the service is using your account and every time you change
your password, you have to update the service.
Why you do not create an account just for the service?
See "Setting up Windows Services Accounts" in BOL.
AMB
"Enric" wrote:
> Dear all,
> Whenever that I change my password on domain NT, then MSSQLSERVER
> service failed (local sql server of course). So that I've got to enter in
> that service
> and update the password manually on LOG ON flap.
> At the same time when I open my enterprise manager not appears all those
> Network Sql Serverthat before I had. '?
> I would like to have automatically this change.
> Any help will be welcomed,
> Thanks in advance,|||It is better to create a special service account rather than using your own
for SQL Server services.
Hope this helps.
Dan Guzman
SQL Server MVP
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:DEF51AED-F720-46A1-9512-EBEE6E6DBFA2@.microsoft.com...
> Dear all,
> Whenever that I change my password on domain NT, then MSSQLSERVER
> service failed (local sql server of course). So that I've got to enter in
> that service
> and update the password manually on LOG ON flap.
> At the same time when I open my enterprise manager not appears all those
> Network Sql Serverthat before I had. '
> I would like to have automatically this change.
> Any help will be welcomed,
> Thanks in advance,|||Local System Account?
take care,
"Dan Guzman" wrote:
> It is better to create a special service account rather than using your ow
n
> for SQL Server services.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:DEF51AED-F720-46A1-9512-EBEE6E6DBFA2@.microsoft.com...
>
>|||Enric,
He meant a "domain user account".
AMB
"Enric" wrote:
> Local System Account?
> take care,
> "Dan Guzman" wrote:
>|||You could use the build-in Local System account if access to network
resources isn't needed (e.g. backup to UNC). As Alejandro suggested, I was
thinking of a domain account since this is apparently what you are currently
using.
Hope this helps.
Dan Guzman
SQL Server MVP
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:E2E61BAB-6C00-4B9A-AC44-FCD759E22E6E@.microsoft.com...
> Local System Account?
> take care,
> "Dan Guzman" wrote:
>
Sunday, February 12, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment