Error 22022 when running SQLservices under different accou..

Hi,

I am following the recommendations from Microsoft to set up the MSSqlserver
and SQLAgent service to run under different domain user accounts. This I am
doing, as recommended, via Enterprise manager. The platforms are Windows
server 2003 and SQL Server 2000, SP3.

However, when trying to run a job I get the error 22022 "SQL Server Agent
not currently running", even though the service IS running. Also, in the SQL
Agent error log I get the message "The data portion of event 17052 from
MSSQL$Servername is missing".

If I make the account for the MSSQLSERVER service a member of the
administrators group it all sseem to work fine. This makes me believe that
some necessary permission or setting in the registry is not being set up
correctly by Enterprise Manager when changing the MSSQLSErver service
account.

The same problem was originally posted under the subject "SP3 causes
SqlAgent jobs not run" by Michaela Judasova, but no valid solution was
provided, as far as I can see. So please, Michaela ,or someone else with an
answer, help me out on this one!

By the way, now when everyone is getting so concerned with security these
days, it´s very annoying to find that following the Microsoft own
recommendations to enhance security by setting upp the services to run under
different unprivileged accounts results in hours of unneccesary work. I
suppose the only reason why this bug slipped out is that they don´t
implement their own recommendations. Otherwise I think they would have
discovered this. And this is not the first time. I´ve had a similar (but not
the same) problem before running SQL Server 7 under unprivileged accounts
after loading a new SP.

Thanks
Per Williamson

If you are using the SQL Enterprise Manager (SEM) to change the service
startup accounts to use a non-admin account, then all should work fine. But
if you suspect that SEM is not setting some relevant file permissions or
registry permissiosn etc for your non-admin account, then you may want to
review this KB article for a complete list of permissions/rights which are
required for your Windows account:

How to change the SQL Server or SQL Server Agent Service account without
using SQL Enterprise Manager in SQL Server 2000 (283811)
http://support.microsoft.com/default.aspx?scid=KB;EN-US;283811

Thanks,
Ananth Padmanabham
Microsoft SQL Support

This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
--------------------
| From: "Per Williamson"
| Newsgroups: microsoft.public.sqlserver.setup
| Subject: Error 22022 when running SQLservices under different accounts
| Lines: 37
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
| Message-ID:
| Date: Wed, 15 Sep 2004 07:41:55 GMT
| NNTP-Posting-Host: 217.208.161.155
| X-Complaints-To: abuse DeleteThis @telia.com
| X-Trace: newsc.telia.net 1095234115 217.208.161.155 (Wed, 15 Sep 2004
09:41:55 CEST)
| NNTP-Posting-Date: Wed, 15 Sep 2004 09:41:55 CEST
| Organization: Telia Internet
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA0
1.phx.gbl!TK2MSFTNGP08.phx.gbl!news-out.cwix.com!news-out!pullfeed!newsfeed.
cwix.com!newsfeed.icl.net!newsfeed.freenet.de!news.tu-darmstadt.de!frankfurt
1.telia.de!news-stoc.telia.net!news-stoa.telia.net!telia.net!masternews.teli
a.net.!newsc.telia.net.POSTED!not-for-mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.setup:66481
| X-Tomcat-NG: microsoft.public.sqlserver.setup
|
| Hi,
|
| I am following the recommendations from Microsoft to set up the
MSSqlserver
| and SQLAgent service to run under different domain user accounts. This I
am
| doing, as recommended, via Enterprise manager. The platforms are Windows
| server 2003 and SQL Server 2000, SP3.
|
| However, when trying to run a job I get the error 22022 "SQL Server Agent
| not currently running", even though the service IS running. Also, in the
SQL
| Agent error log I get the message "The data portion of event 17052 from
| MSSQL$Servername is missing".
|
| If I make the account for the MSSQLSERVER service a member of the
| administrators group it all sseem to work fine. This makes me believe that
| some necessary permission or setting in the registry is not being set up
| correctly by Enterprise Manager when changing the MSSQLSErver service
| account.
|
| The same problem was originally posted under the subject "SP3 causes
| SqlAgent jobs not run" by Michaela Judasova, but no valid solution was
| provided, as far as I can see. So please, Michaela ,or someone else with
an
| answer, help me out on this one!
|
| By the way, now when everyone is getting so concerned with security these
| days, it´s very annoying to find that following the Microsoft own
| recommendations to enhance security by setting upp the services to run
under
| different unprivileged accounts results in hours of unneccesary work. I
| suppose the only reason why this bug slipped out is that they don´t
| implement their own recommendations. Otherwise I think they would have
| discovered this. And this is not the first time. I´ve had a similar (but
not
| the same) problem before running SQL Server 7 under unprivileged accounts
| after loading a new SP.
|
| Thanks
| Per Williamson
|
|
|