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 hav
e
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 Admin
s
privileges. When I then changed the group for the account to the Domain User
s
the agent service suddenly became unable to log into the SQL Server using th
e
'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,
OskarEM, 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 machi
ne
> and another similar machine joined to the domain. On the other machine I h
ave
> Microsoft SQL Server 2000 SP3 set up and it uses the domain startup accoun
t
> for both the main and the agent service. First time when I was changing th
e
> startup account from local account to the domain account it had Domain Adm
ins
> privileges. When I then changed the group for the account to the Domain Us
ers
> 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 rig
ht.
> What could have gone wrong here?
> --
> Many thanks,
> Oskar
>