SQL Server Performance

windows accounts and sql server native accounts

Discussion in 'General DBA Questions' started by sandeepsingh_05, Jul 3, 2006.

  1. sandeepsingh_05 New Member

    hi,

    I need to take all the rights away from user accounts from all the servers,except those which are most used by the services.

    now how to know which are windows accounts and which are sql server native accounts?
    sandeepsingh_05, Jul 3, 2006
    #2

  2. Luis Martin Moderator

    You can find that in Windows Services.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Jul 3, 2006
    #2

  3. satya Moderator

    What is the authentication mode used to connect to SQL?
    Run SP_HELPROTECT to see the privileges of each user on the database(s) and also run XP_LOGININFO for more information.


    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
    satya, Jul 7, 2006
    #2

Share This Page