I've just created a login for the NT AUTHORITY\SYSTEM account and granted access to the msdb database to this login.

The SQL Server Agent is now running fine.

Carl

Yes.  I meant to include the fact that the BUILTIN\Administrators account had been removed.

I have just done a quick google search and spotted it is likely to be this problem.

Why...

Sorry Brian,

the message I saw is from the application log in event viewer of the SQL Server

Brian,

The only message in the SQL Server Event Log was a login failure message for my domain account.

Hi Brian,

I was thinking of trying the Global account directly, but as you can see from my previous email, it works fine now.

It must have been due to the domain...

Looks like I might have been slightly too eager in my attempt to login.

I have tried it again today and it works fine.

I think the domain hadn't synchronised when i...

I'll have a look at the articles thanks.

Congratulations on receiving your MVP Frank, you've helped me out a number of times.

Thanks for all your replys guys.

Regards

Carl

Thanks for the reply Darrell

Mark,

I have recently read about SQL Server 2005 Standard Edition supporting Clustering, but from what I read it only covers 2 nodes in the Cluster.  I would also prefer to...

Jerod,

Thanks for the reply.

We would be looking to possibly cluster and purchase USER CALS.

In terms of CALs v Processor licences.  It works out cheaper to buy 3 Server licences and...

I take it even though I can no longer see the dependencies that there are no other problems associated with this?

I have tested by dropping the table on a test...

Thanks for that.

Is there any quick way to check DTS apckages or will I have to check each package maunally?

To answer your original question.

I don't know a way of setting the recovery model of multiple databases.

If I were you I would try and find out which databases are the...

The settings of 10% autogrowth are fine.  This way your database will grow by 170 MB at a time which I assume should be fairly infrequently.

Have you got autoshrink set...