locked
Always prompt for login name and password RRS feed

  • Question

  • Hi,

    Can anybody tell me if there any system procedure or any way to turn on or turn off the "Always prompt for login name and password" option from Enterprise manager SQL SERVER 2000?

    When you right click on the registered server node and go to "Edit SQL Server registration properties" you will find the option "Always prompt for login name and password". Actually I need to turn it on for 100 SQL Servers so I was wondering if anyone knows if there is any system procedure to do this or not.

    Thanks





    Sajid Wasim
    Wednesday, February 18, 2009 4:06 AM

Answers

  • THat is not a server setting, this is a client setting. It means if you want to save the password locally (and encrypted) or you will need to enter if everytime you are creating a new connection.

    Jens K. Suessmeyer
    • Marked as answer by Sajid Wasim Wednesday, February 18, 2009 4:28 PM
    Wednesday, February 18, 2009 12:49 PM