|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Domain administrator password change
Hi folks. Sorry if this one's a bit basic, but I'm a SQL 2000 novice.
I've just taken over responsability for some servers and I need to change the domain administrator password. I was wondering if changing this will have any adverse affects on SQL. The SQL server is a domain controller. Only the SQLSERVERAGENT service uses the administrator account. Will I have any problems "internal" to SQL after the password is changed? Thanks for any tips. Show quoteHide quote :) Hi,
After the change you need to change the password for SQLServer Agent with new password. How to change the startup account:- 1. Control Panel - Admin tools -- Services 2. Double click above the SQLSERVERAGENT service 3. In the Log on tab, change the OS user name and enter the password, Click ok and restart the service. Thanks Hari SQL Server MVP Show quoteHide quote "David Pounds" <david.pou***@hohohohohohahahahahah.bum> wrote in message news:Oaib5H5VFHA.132@TK2MSFTNGP14.phx.gbl... > Hi folks. Sorry if this one's a bit basic, but I'm a SQL 2000 novice. > > I've just taken over responsability for some servers and I need to change > the domain administrator password. > > I was wondering if changing this will have any adverse affects on SQL. > The SQL server is a domain controller. Only the SQLSERVERAGENT service > uses the administrator account. > > Will I have any problems "internal" to SQL after the password is changed? > > Thanks for any tips. > > :) Nice one - thought that was it but always good to check.
Thank you. Hari Prasad wrote: Show quoteHide quote > Hi, > > After the change you need to change the password for SQLServer Agent with > new password. > > How to change the startup account:- > > 1. Control Panel - Admin tools -- Services > 2. Double click above the SQLSERVERAGENT service > 3. In the Log on tab, change the OS user name and enter the password, Click > ok and restart the service. > > Thanks > Hari > SQL Server MVP > > "David Pounds" <david.pou***@hohohohohohahahahahah.bum> wrote in message > news:Oaib5H5VFHA.132@TK2MSFTNGP14.phx.gbl... > >>Hi folks. Sorry if this one's a bit basic, but I'm a SQL 2000 novice. >> >>I've just taken over responsability for some servers and I need to change >>the domain administrator password. >> >>I was wondering if changing this will have any adverse affects on SQL. >>The SQL server is a domain controller. Only the SQLSERVERAGENT service >>uses the administrator account. >> >>Will I have any problems "internal" to SQL after the password is changed? >> >>Thanks for any tips. >> >>:) > > >
Other interesting topics
Major Performace problem
Why the update process take so much time?? execure store procedure from Query Analizer sqlservr.exe using high I/O Combine 3 Queries into One stored procedure open table Commenets on Running Citrix on SQL Server? Anyone doing this? SQL Agent Autostart Can Triggers Help Me out |
|||||||||||||||||||||||