Coming from the AD administrator's role, sounds to me like it may be SQL related. In previous posts, it's been shown that power-cycling the server fixes the issue. To verify...

Thanks Shawn, I appreciate the explanation and will give it a go today. Btw, can this be done using the GUI as well?

Christopher has hit the nail on the head! I just need a link to instructions on how to set this up for an Active Directory group. Thanks.

Thanks all. The boxes are all Dell PE2950s with 4 CPUs & 4 GB RAM running Win2K3 & MS SQL2000 & 2005. We've come to the conclusion that we will...

I ran:

sp_configure 'show advanced options', 1

RECONFIGURE

GO

exec sp_configure 'awe enabled'

Which gave me:

awe enabled

Min: 0

Max:1

Config_value: 1

Run_value: 1

So, yes it is. Thanks.

I figured it out. i had a corrupted installation of SQL Server. I could not uninstall it as it complained that the uninstall file was missing so I re-installed, uninstalled...