SQL Server service account password change



OK. I've read all kinds of stuff on the internet about changing the SQL
Server Service and SQL Server Agent Service account passwords. They all
say "use Enterprise Manager" because it performs additional tasks that
you would otherwise have to perform manually. I can dig that.

My problem is that I can't figure out *how* to change the password(s)
using EM. I have no problem seeing how to switch to a completely
different account: just type in the account and password and stop and
restart the service. But how do I change *just the password* in EM?
Maybe I'm confused. Does EM actually change the service account's
password in the domain, or do I need to do that elsewhere before I
change the password in EM?

On top of this, I'm doing this in a clustered environment, and I'm
pretty new to SQL Server clustering. Can someone please set me
straight?

Thanks,
Aaron

.



Relevant Pages

  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Problems with WebParts
    ... The connection string specifies a local SQL Server Express instance using a ... database location within the applications App_Data directory. ... server account must have read and write access to the applications directory. ... logged-in user needs the dbcreator privilege in the appropriate SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)