xp_loginconfig and setting "authentication" mode | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

xp_loginconfig and setting "authentication" mode

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 />
What do u mean by "Off-Line" Way ?
If U mean to QA then u can use following
EXEC xp_loginconfig ‘mixed’ – Login Mode
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…
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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>