changing password for sql server service and sql agent service

If I change the password for sql server under the server/properties/security
tab and for sql agent under sql server agent/properties/general tab do I
still have to change the password in windows services? Or does changing the
passwords within em also change the password in services?
But if I change the passwords in windows services do I also have to change
the passwords in sql server?
Thanks,
--
Dan D.Always change them in Enterprise Manager. That is enough. You don't have to
change them again from Services.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:EA51464A-9EFE-4B41-B397-3129AF4378FB@.microsoft.com...
> If I change the password for sql server under the
> server/properties/security
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing
> the
> passwords within em also change the password in services?
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
> Thanks,
> --
> Dan D.|||> If I change the password for sql server under the server/properties/securityn">
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing th
e
> passwords within em also change the password in services?
Yes it does.

> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
No, but it is recommended to do this using SQLEM. There are other things
that EM does regarding to this operation. Read the "Important" note at the
end.
Changing Passwords and User Accounts
http://msdn.microsoft.com/library/d...nstall_4p0z.asp
AMB
"Dan D." wrote:

> If I change the password for sql server under the server/properties/securi
ty
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing th
e
> passwords within em also change the password in services?
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
> Thanks,
> --
> Dan D.|||I did try to change the password in sql agent/properties after changing the
password for sql agent in services and I got this message:
"SQL Server Agent start-up account could not be verifited."
Do you think it means that the password entered in SQL Agent/Properties and
the password entered in the SQL Agent service were not the same?
Thanks,
Dan D.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Yes it does.
>
> No, but it is recommended to do this using SQLEM. There are other things
> that EM does regarding to this operation. Read the "Important" note at the
> end.
> Changing Passwords and User Accounts
> http://msdn.microsoft.com/library/d...nstall_4p0z.asp
>
> AMB
> "Dan D." wrote:
>|||Dan,
Sorry, no idea.
AMB
"Dan D." wrote:
[vbcol=seagreen]
> I did try to change the password in sql agent/properties after changing th
e
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties an
d
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
>|||Thanks.
--
Dan D.
"Narayana Vyas Kondreddi" wrote:

> Always change them in Enterprise Manager. That is enough. You don't have t
o
> change them again from Services.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:EA51464A-9EFE-4B41-B397-3129AF4378FB@.microsoft.com...
>
>|||Are the two services using the same service account? I could imagine that if
they aren't, then SQL
Server cannot verify the password for another account (Agent).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:B411CAE6-B998-4D72-A658-7943BA7BDCA5@.microsoft.com...[vbcol=seagreen]
>I did try to change the password in sql agent/properties after changing the
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties an
d
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
>|||The sql server service and the sql agen tservice are using different
accounts. But the account that the sql agent servce is using and the account
under sql agent/properties/general tab are the same.
--
Dan D.
"Tibor Karaszi" wrote:

> Are the two services using the same service account? I could imagine that
if they aren't, then SQL
> Server cannot verify the password for another account (Agent).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:B411CAE6-B998-4D72-A658-7943BA7BDCA5@.microsoft.com...
>|||Hello, I'm Legacy. I have no idea what sql server is, but could someone
please tell me how to change my password.
"Dan D." wrote:
[vbcol=seagreen]
> I did try to change the password in sql agent/properties after changing th
e
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties an
d
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
>