security setting in SQL Server

• sharmavc

  SSC Enthusiast

  Points: 101

  More actions

  December 2, 2005 at 10:10 pm

  #92670

  Hi Folks,

   

  I need to restrict access to SQL Server users only, for this I have changed security status as zero through DMO and also removed all windows user logins. Now, issue is that SQL Server should ask USER ID & Password of the user to acces the data. Quary analyser is OK as it asks every time, but in Enterprise Manager, it does not promt USERID & Password unles the option is cheked. I could not find any way to handle this through DMO. Unles this option is checked enterprise manager does not prompt for userID & password. I need to know how to do this through DMO and if the option is not checked then make it checked through DMO programming model.

   

  Sharma VC

• peterhe

  SSChampion

  Points: 11469

  More actions

  December 8, 2005 at 7:54 am

  #608417

  I don't know how to do it by DMO. One solution to your problem is that you can deny the login permission to all the windows accounts.

  sp_denylogin @LoginName='Windows NT user or group'

  you can call the sp for each windows group.