asked on

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.

ASKER CERTIFIED SOLUTION

Hemantgiri S. Goswami

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

heatfan07

ASKER

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.