Dear Wang,

I already tried it but it hasn't helped. 🙁

Thanks,

Csaba

Csaba Mezo

I also feel that something has been changed but I don't know why. And why only the Agent fails and not the SQL Server?

However I have to wait until next...

Hi all,

Allen: I already restarted the server several times. There's SQL SP3 installed as well as Win2000 SP2. I will install the Win2000 SP3 soon but I guess it will...

Hi Allen,

The 'BUILTIN\Administrators' goup has access to the server with System Administrator role.

I also added the server's Administrator user to the server with full access and changed the Agent service...

Dear All,

I also found a very interesting problem on the server. If I go to the server (pcAnywhere), open the LOCAL Enterprise Manager and try to register the LOCAL SQL...

Dear Allen,

Sorry, my statement was misunderstandable. I meant that I wanted to start the Agent under local system account as well as under local admin user. Both solution failed so...

Hi Frank,

It was nice that you tried to help. Here are some further answers:

- 0 connection limit I also don't understand exactly but I think it means no limit....

The SQL Agent service runs under local system account. I also tried to assign the local administrator to it but the result is the same: it still can't be started.

The...

Hi,

I reinstalled the SQL Server + SP3 but nothing has changed. The Agent still can't be started :(((

I have 2 ideas left:

1. Something is wrong with the operating system.

2. There's...

Hi Frank,

In the event log I only find the error message that I wrote in my first posting. Nothing more.

No, there was no change in the config. However currently I...