SQL Server Performance

xp_loginconfig and setting "authentication" mode

Discussion in 'General DBA Questions' started by wabbash, Sep 16, 2004.

  1. wabbash New Member

    hi there,<br /><br />is there any "off-line" way to set up the SQL Server authentication mode? (Mixed, Windows ..)<br /><br />All I get is the "xp_loginconfig" which is only informative, and being an "extended" procedure, I am not able to decypher it ....[<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><br />thanks a lot![<img src='/community/emoticons/emotion-3.gif' alt=':eek:' />)]<br />
  2. sundeip New Member

    What do u mean by "Off-Line" Way ?
    If U mean to QA then u can use following
    EXEC xp_loginconfig 'mixed' - Login Mode
  3. wabbash New Member

    as "off-line" I meant not using the SQLEM ... I want to set it via SP

    As I stated previously, the xp_loginconfig is just informative, cannot be used to change parameters...
  4. satya Moderator

    Not seen such statement using QA and only by the way of using EM or tweaking registry key.
    To see the current level of auditing, use Enterprise Manager or execute master..xp_loginconfig.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page