A problem with Microsoft SQL Server 2000 startup account

Hi,
I have a Microsoft Windows 2000 Advanced Server SP4 Active Directory machine
and another similar machine joined to the domain. On the other machine I have
Microsoft SQL Server 2000 SP3 set up and it uses the domain startup account
for both the main and the agent service. First time when I was changing the
startup account from local account to the domain account it had Domain Admins
privileges. When I then changed the group for the account to the Domain Users
the agent service suddenly became unable to log into the SQL Server using the
'sa' account - it was telling all the time that the login for the user 'sa'
failed, although I checked and rechecked the credentials and they were right.
What could have gone wrong here?
Many thanks,
Oskar
EM, right-click Agent, properties, right-most tab. Here you find the account agent uses. Make sure
this account exists in SQL Server with sysadmin privileges.
Also, search Books Online for below to read more about the service accounts:
"level token"
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:4705F64D-2678-4E1F-A7FF-922A331E1118@.microsoft.com...
> Hi,
> I have a Microsoft Windows 2000 Advanced Server SP4 Active Directory machine
> and another similar machine joined to the domain. On the other machine I have
> Microsoft SQL Server 2000 SP3 set up and it uses the domain startup account
> for both the main and the agent service. First time when I was changing the
> startup account from local account to the domain account it had Domain Admins
> privileges. When I then changed the group for the account to the Domain Users
> the agent service suddenly became unable to log into the SQL Server using the
> 'sa' account - it was telling all the time that the login for the user 'sa'
> failed, although I checked and rechecked the credentials and they were right.
> What could have gone wrong here?
> --
> Many thanks,
> Oskar
>