Re : Active Directory and SQL Server NT Authentication problem

From: Vijay (vijay_at_ebay.com)
Date: 06/19/03 

Date: Thu, 19 Jun 2003 09:30:23 -0700

I am trying to set up SQL server NT authentication but
having the below problem.

Using Active Directory on windows 2000 server, I have
created a domain user (say 'usera') and a group
(say 'groupa'). I have assigned the 'usera' to 'groupa'.
Then on the sql server, I have added the 'groupa' and
granted permissions to access the database.

I am able to login as 'usera' in the domain and access the
database using NT authentication.

Using active directory, I used the copy user feature and
created a different user 'userb' like 'usera' and added
the user to the 'groupa'. But I am not able to access the
database and getting an error - Test connection failed
because of an error in initializing provider. Login failed
for user 'domain/userb'. What is wrong?

Relevant Pages

  • Re: SQL Express MDF file moved from 1 computer to another - auth f
    ... I try to attach the database which is located in MyDocuments\Visual ... Microsoft SQL Server Management Studio ... now it tells me that authentication has failed for my windows ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Express MDF file moved from 1 computer to another - auth f
    ... I try to attach the database which is located in MyDocuments\Visual ... Microsoft SQL Server Management Studio ... now it tells me that authentication has failed for my windows ...
    (microsoft.public.sqlserver.connect)
  • Re: T-Sql & Active Directory Roles, Identification of original login of impersonated IDs an
    ... We want to be able to control access to data within a table based on a ... role within Active directory. ... All the sites are held in a single database table. ... can grant permissions in SQL Server to Windows groups. ...
    (comp.databases.ms-sqlserver)
  • Re: Trusted connections??
    ... implement role or user based security at the SQL Server. ... If the ASP.Net app controls what the user can request of the database then I ... I implement user authentication at the application and the application ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Security question ..
    ... What I want to prevent is any access to the database accept through our ... application unless you have elevated permissions. ... Authentication, if he is smart enough to create an NT Auth ODBC connection ... passes through to the database or to use SQL Server authentication. ...
    (microsoft.public.sqlserver.server)