Access Permissions with Basic SQL Server
Posted on 2007-07-31
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.