SQL SVR 2K only allows Administrators thru Win Auth

[joleary]

I have a Windows 2K Server, running SQL 2K, installed with Mixed Mode Authentication.

Altho
- I am a recognized user on the domain (for which the W2K Server is the domian server),
- I can see shared folders on the W2K Server without having to provide an additional user/pwd
- yet, I cannot get access to any SQL 2K databases unless I am a member of the Administrator group on the W2K server.

Can anyone tell me why?

I don't want to have to be an Admin on that server, nor will I want other DB users to be Admin.

Thanks for any consideration.

[joleary]

Apparently each domain user or group has to be added to the Security/Logins section of the SQL 2K Server.

Since you're reading this, thanks for having a look.