Apologies for cross posting wasn't sure which group does this belong.

Hi,
I have just moved SQL Server 2005 to a new domain and am getting an error
with Error code 0X8007042B while trying to restart SQL Server agent. The
message in Errorlog says

SQLServerAgent couldn't be started (reason SQLServer Agent must be able to
conenct to SQLServer as SysAdmin but "(Unknown)" is not a member of Sysadmin
role.

The account under which SQLServer agent is set to run indeed a member of
the Sysadmin role. I have also tried to run SQLServer Agent under the bulitIn\Administrator
as well as domain\Administrator user and get the same error. I also get the
same error while trying to run the SQL Server agent under local System or
network services user. The SQL Server service is currently running under
Domain\Administrator account.

I am using Windows 2003 SP 1 and SQL Server 2005 EE SP 1.

I saw some references on the web about running into this error while starting
SQL Server instance but nothing about SQL Server agent. Can someone please
help?

Any helps gratefully acknowledged.

Cheers

Annon
Is this start account a member of the local administrators group?

What security authentication is the SQL instance configured to use? Is it
Windows or Mixed?




"Annon" <Annon (AT) gmail_ (DOT) com> wrote

Annon
Is this start account a member of the local administrators group?

What security authentication is the SQL instance configured to use? Is it
Windows or Mixed?




"Annon" <Annon (AT) gmail_ (DOT) com> wrote

Hi,
This start account is indeed a member of local administrator group.

SQL Server is configured to run under mixed mode.

Tnx

Hi,
This start account is indeed a member of local administrator group.

SQL Server is configured to run under mixed mode.

Tnx

Hmmm, strange , have you got the same after restarting windows?


"Annon" <Annon (AT) gmail_ (DOT) com> wrote

Hmmm, strange , have you got the same after restarting windows?


"Annon" <Annon (AT) gmail_ (DOT) com> wrote

Hello Uri,
The machine was shut down when it was moved to new location.
I started to get this error after I turned on the machine and noticed that
SQL Server Agent was not running and when I tried to restart it.

Hello Uri,
The machine was shut down when it was moved to new location.
I started to get this error after I turned on the machine and noticed that
SQL Server Agent was not running and when I tried to restart it.

I won't be able to reboot the machine until later, I will try to reboot in
about 6 hours time and see if this solves the problem.

Cheers