SQL Server Performance

MSSql2000 - Always prompt for Username and Password

Discussion in 'General DBA Questions' started by vikie4u, Jan 11, 2010.

  1. vikie4u New Member

    Dear Experts,Whenever we are using the 'Mixed Mode Authentication' to login to MSSql 2000 server there is a check box 'Always prompt for Username and Password' ( we can find the setting under 'Edit SQL Server Registration properties') which will prompt for username and password when the user is loging in to the server. Is there any way to find whether this setting is enabled or not in windows registry or using some sql query.I want to administer the sql server progrmatically.Please Suggest.Regards,Vikram
  2. Adriaan New Member

    The 'Always prompt' option only relates to the current installation of Enterprise Manager, and it is probably also limited to the current user profile in Windows.
    If you do not select the option, then if you open Enterprise Manager and access this registered instance of SQL Server, your session will be connected using the credentials selected here (SQL login or Windows authentication).
  3. satya Moderator

    Welcome to the forums.
    What kind of administration you want to perform programmatically?

Share This Page