Microsoft SQL Server Desktop Engine - changing service account as per kb 283811

Author

changing service account as per kb 283811

bill tie

2005-11-08, 4:10 pm

Has anybody been able to change a service account following this article:
http://support.microsoft.com/kb/q283811/

In particular,
- SQL2k0 SP4,
- non-administrative, i.e. plain-vanilla User Group, account,
- MSDE SP4 named instance, or
- named instance,
Thank you.

Andrea Montanari

2005-11-14, 7:23 am

hi bill,
bill tie wrote:
> Has anybody been able to change a service account following this
> article: http://support.microsoft.com/kb/q283811/
>
> In particular,
> - SQL2k0 SP4,
> - non-administrative, i.e. plain-vanilla User Group, account,
> - MSDE SP4 named instance, or
> - named instance,
> Thank you.

283811 has not been updated for changes in sp4... I'm still trying to figure
it out what is missing...
so far I'm still trying troubleshooting it..
I tryed "propagating" file permissions to all sub folders as described, as
long as assigning registry permissions as
HKLM\Software\Micros
oft\MSSQLServer\Setu
p (READ)
HKLM\Software\Micros
oft\MSSQLServer\MSSQ
LServer (FULL CONTROL)
for the account running SQL Server and
HKLM\Software\Micros
oft\MSSQLServer\SQLS
ERVERAGENT (FULL CONTROL)
HKLM\SOFTWARE\Micros
oft\MSSQLServer\Clie
nt\SuperSocketNetLib
\LastConnect
(FULL CONTROL)
HKLM\Software\Descri
ption\Microsoft\Rpc\
UuidTemporaryData (FULL CONTROL)
HKLM\Software\Micros
oft\MSSQLServer\Setu
p (READ)
HKLM\Software\ODBC\O
DBC.INI (FULL CONTROL)
for the account running the Agent...
making those accounts member of the local sysadmins WinNT role

it seems to work, but I'm not completely confident about that...

feedback is welcome :D:D
but I definitevely hope kb article 283811 gets updated
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Sponsored Links