SQL user mapping for the AD user

Hi,
Any AD users maybe mapped to a SQL user, so it should be possible to show
this and I also want to login into SQL server through AD user login. I am new
to Active directory SQL integration . Can any body help me out.

Thanks in Advance
Arun

arunyadav_ece (u62124@uwe) writes:
> Any AD users maybe mapped to a SQL user, so it should be possible to
> show this and I also want to login into SQL server through AD user
> login. I am new to Active directory SQL integration . Can any body help
> me out.

Not really sure what you mean here.

In SQL Server there are two types of logins: SQL logins and Windows logins.
SQL logins are private to SQL Server and has nothing to do with Active
Directory.

Windows logins are straightforward. If you are logged into Windows as
DOMAIN\USERNAME which is member of group DOMAIN\GROUP, then you can log
into SQL Server if either DOMAIN\USERNAME or DOMAIN\GROUP as been granted
access to SQL Server.

--
Erland Sommarskog, SQL Server MVP, esquel.DeleteThis@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx