SQL only allows administrators access

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Chris Brighton (anonymous_at_discussions.microsoft.com)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 03:38:09 -0700

I am running SQL on our network to use a program called
BSquared: Connecting Steps. this program stores
information on a database on the server and uses SQL to
access it.

when running the program on an administrators profile
everything works fine, however when i attempt to run the
program on a normal profile i get the following error:

----------------------------------------------------------
Microsoft SQL Server Login |X|
----------------------------------------------------------

Connection failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user 'Domain\user'

                       ------
                       | OK |
                       ------

If anyone knows how i can enable all users access to the
database, without giving everyone administrative
privelages. We cannot comprimise security by giving
everyone access to an administrator account, but we do
need all members of staff to have access to this database.

Thanks in advance.

Chris Brighton

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)