Access Permissions with Basic SQL Server

Hello experts!  I have the "free" version of Microsoft SQL Server installed on a Windows 2003 Server.  I am having some trouble with access permissions.  I have set up the permissions to use Windows NT Authentication and I would like to keep that setting if possible.

The problem that I'm having with the access permissions is that the users on my network who connect to the SQL Server have to be members of the Local Administrators group on the Windows server that SQL Server is running on.  I have searched for some command line options using osql or whatever works with this setup of SQL  to remedy this, but I can't find anything.  

These users need to be able to DESIGN databases (we are using SQL as a backend for MS Access), so they do need pretty much full access to the SQL Server component of the server, but I don't want to make them local admins of the server.  They need to be able to do whatever is necessary with SQL Server and then just have full access rights to their databases hosted on the server, but not to everything on the server.

Please let me know if you have any suggestions.  References to SQL command line code that will remedy this will be highly regarded.
LVL 3
heatfan07Asked:
Who is Participating?
 
Hemantgiri S. GoswamiModerator - MSDN ForumsCommented:
Hi,

Please see if the sql server is a part of domain, if so, add/map that users/group to your sql server and assign proper privilege to them using 'fixed server role' / 'fixed db role' refer them in books online for more details.

HTH
Hemantgiri S. Goswami
MS SQL Server MVP

0
 
heatfan07Author Commented:
Where do I find the "fixed server role" access permissions?  Just to be clear, I am using the free version of SQL Server (MSDE) and do not have any additional add-ons or admin tools installed.  The only thing i've found so far is some command line tools to grant access, but those don't work so far.  

I am trying to avoid giving the DB designers full access to the overall physical server, if possible.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.