[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Access Permissions with Basic SQL Server

Posted on 2007-07-31
Medium Priority
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

Accepted Solution

Hemantgiri S. Goswami earned 1000 total points
ID: 19606767

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


Author Comment

ID: 19609262
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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Unable to change the program that handles the scan event from a network attached Canon/Brother printer/scanner. This means you'll always have to choose which program handles this action, e.g. ControlCenter4 (in the case of a Brother).
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

872 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