I have a SQL server 2000 SP3a running on server 2003 Enterprise Edition and I have one problem.

The only way the users can get the SQL server service manager on their workstations to connect to the SQL server is if they are part of a admin account (domain/Administrators etc)

How can I let a regular user connect to the SQl server without adding the users to a admin account.

I have tried adding their logons to the SQL server itself but still it won't let me have them connect.

Now the software we're gonna be using will not require as I believe the software will interact with the database itself. MSDE which is what I was playing with at the moment and having the user access rights problems with.



THanks for your help on this, I've never handled any SQL server things before.