Security Problem - Permission denied

From: Jim (Jim_at_discussions.microsoft.com)
Date: 02/25/05 

Date: Fri, 25 Feb 2005 06:49:06 -0800

We recently installed SQL Server 2000 and have upsized our Access back end
database to SQL Server. I have added all of our users to SQL Servers logins
and assigned them to the proper roles. We are still using that same Access
2000 front end. My problem is that anyone who tries to run the system gets a
permission denied error on any table they attempt to access unless I add them
to the "System Administratiors" server role. Clearly, I do not want to have
to add everyone to that role. SQL Server security seemed pretty straight
forward to me and I can't figure out what I missed. I would greatly
appreciate any help that anyone has to offer.

Thanks in advance,
Jim

Relevant Pages

  • Quick Question on SQL Server 2005 Express
    ... The SQL Server database will be located on it's own server. ... test the system, I installed SQL Server 2005 Express onto the server, got ... says that Express won't look at network drives, ...
    (microsoft.public.sqlserver.setup)
  • Re: $5 for Bug Tracking/Software Project Management Software
    ... But I have some troubles to use the product, I installed SQL Server 2005 and ... Impossible to create any database:( ... I have no experience with SQL Server ... Axosoft are selling a 5 user version of OnTime for just ...
    (borland.public.delphi.non-technical)
  • Cant open tables in Enterprise Manager
    ... I have SQL Server 2000 Developer Edition and Windows XP ... I installed SQL Server 2000 as the ... database table into a SQL Server 2000 database table ...
    (microsoft.public.sqlserver.setup)
  • Re: Changing Data Storage Location to Network Drive
    ... Keep a copy of your database files on a remote machine in your network? ... Or keep the client tools on the current server and move your database engine and files to another server? ... >I installed SQL Server on my PC and have created a few databases which>have ... I would like to leave SQL Server installed on my PC, ...
    (microsoft.public.sqlserver.setup)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)