Post reply

How to lock SQL Enterprise Manager

  • June 23, 2005 at 11:24 pm

    #93402

    I want to Lock SQL Enterprise manager from other user those who are having Administrator rights. Please help.

  • June 23, 2005 at 11:47 pm

    #568182

    Do you mean you want to prevent giving them access ?! Why can't you just delete them from the roles that they are members of or delete the individual users if that's what it is ?!







    **ASCII stupid question, get a stupid ANSI !!!**

  • June 24, 2005 at 12:38 am

    #568185

    1.Right click on Instance and click on 'edit sql server registration properties'

    2.Click on button 'use sql server authentication'

    3.check box 'Always prompt for username and password.

    4.click on Ok button

    Next time you open EM it will ask for password.

    Rgds

    Binu John

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply