Re: Restore access for sql service accounts

Hi Stephan.

SQL Server grant the need rights when you change the service account, so the
easiest way is to change services to start with the LocalService account an
then, change them again to the service accounts.

Regards


--
Antonio Soto
Solid Quality Learning
http://www.sqlu.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Stephan Hofmann" <StephanHofmann@xxxxxxxxxxxxxxxxxxxxxxxxx> escribió en el
mensaje news:44568C5E-D332-4F77-BB66-02BA8BDD47A7@xxxxxxxxxxxxxxxx
Hello,

due to massive errors on one server having SQL 2005 installed, I was
forced
to reset the group policies to initial settings (installation settings)
using
the gpo fix command of the support tools.

Unfortunately, all service accounts of sql are not running anylonger, I
assume the ahtorisation was reset to an initial value I don't know of.

Is there any tool available or repair functionalty available which will
reset the initial sql server account policies which will be installed
during
SQL 2005 setup?

Yours
Stephan


.

Relevant Pages

  • Re: How to change service accounts on a cluster
    ... you CAN'T use SSMS to change service accounts in 2005. ... to use SQL Configuration Manager to change the service accounts. ... Have 2005 SQL Server cluster... ...
    (microsoft.public.sqlserver.clustering)
  • Re: Changing Windows Domain
    ... are you saying to not start SQL through the Services applet as ... opposed to starting it through Cluster Administrator after completing the ... Make sure the service accounts have the ... >> Windows 2003 Active Directory Domain. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL service accounts
    ... I'm a SQL Server DBA - there is no good reason to make the service accounts domain admin. ... The service accounts do need to be given access to certain registry keys, NTFS file permissions and be given certain user rights on the local machine. ... This is done for you when you change the account using the built-in SQL Server tools rather than using the services mmc. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Changing Windows Domain
    ... Do not start SQL through the Services applet. ... prefer to use the Cluster admin tool. ... Make sure the service accounts have the ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
Loading