Post reply

authentication mode

  • April 5, 2007 at 10:46 am

    #62289

    Hi

    how to find which logins in sql server is through windows authentication or sql server authentication through a query.

    Thanks

  • April 5, 2007 at 11:16 am

    #698874

    Try this for SQL Server 2000:

     

    select name, case when isntgroup = 1 then 'Group' when isntuser = 1 then 'Windows Auth' when isntname = 0 then 'SQL Login' end as Type from master.dbo.syslogins

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • April 5, 2007 at 12:15 pm

    #698892

    Thanks Kathy.  Can a windows authentication login or sql login can access server via group membership . If so how to give windows authentication login  or sql login  via group membership .

  • April 5, 2007 at 12:21 pm

    #698893

    You can give a Windows authentication login access to the SQL Server through a group.  So, let's say you have a Windows group called App_Users.  You add the Windows accounts to that group.  Then add the group App_Users to SQL Server.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply