Error 0X8007042B while restarting SQLServer Agent 2005

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@.gmail_.com> wrote in message
news:e689170a63df8c97faf6e02ee4c@.msnews.microsoft. com...
> 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
>
|||Hi,
This start account is indeed a member of local administrator group.
SQL Server is configured to run under mixed mode.
Tnx
[vbcol=seagreen]
> 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@.gmail_.com> wrote in message
> news:e689170a63df8c97faf6e02ee4c@.msnews.microsoft. com...
|||Hmmm, strange , have you got the same after restarting windows?
"Annon" <Annon@.gmail_.com> wrote in message
news:e689170a63e48c97fb24a3ec914@.msnews.microsoft. com...
> 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?
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
|||Hi
It seems like Agent couldn't connect.
Try to change the account to SQL Server authentication for only
troubleshooting.
"Annon" <Annon@.gmail_.com> wrote in message
news:e689170a63e78c97fb3c8a7f156@.msnews.microsoft. com...
> 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.
>
|||> Hi
> It seems like Agent couldn't connect.
> Try to change the account to SQL Server authentication for only
> troubleshooting.
Hi Uri,
SQL Server is already configured to use mixed mode authentication. I also
tried by creating a new user, adding this new user to the Administrator group
and then added this user to serverAdmin/Sysadmin group in SQL Server. I still
get the same error.
Funny thing is I moved two SQL Server machines, one of them is running just
fine without any problem.
The machine in question never had any problems - It was running for last
145 days w/o any problem at all. Fairly strange.
Tnx