Access Permissions with Basic SQL Server

Posted on 2007-07-31
Last Modified: 2010-03-19
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.
Question by:heatfan07
    LVL 7

    Accepted Solution


    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.

    Hemantgiri S. Goswami
    MS SQL Server MVP

    LVL 3

    Author Comment

    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.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Join Greg Farro and Ethan Banks from Packet Pushers ( and Greg Ross from Paessler ( for a discussion about smart network …
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how the fundamental information of how to create a table.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now