domain admins can connect to sql server but not admins cannot



sbs2003
sql server 2000

Is there a security setting I am missing?

A added the users logins to sql server enterprise, the same way i did
my login and also set the same rights.

When i try to set up the odbc it fails with the sql state: 28000 sql
error:18456 and that their login does not have rights.

I, being a the domain admin, have no problem connection.

.



Relevant Pages

  • Validating an NT ID from SQL Server
    ... and need a way in SQL server to query NT to see ... The web site know their login id, ... >does a lookup in a table to get their rights. ...
    (microsoft.public.sqlserver.security)
  • Re: Validating an NT ID from SQL Server
    ... and need a way in SQL server to query NT to see ... The web site know their login id, ... >>does a lookup in a table to get their rights. ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)