Post reply

security authentication

  • December 2, 2005 at 10:07 pm

    #68629

     

    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
     

  • December 5, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • December 5, 2005 at 12:19 pm

    #607770

    Are you using Mixed-mode authentication on your SQL Server?

    Cheers,

    david russell

  • December 6, 2005 at 2:51 am

    #607888

    No, I am using SQL Server Authentication Mode only (The security Status set as zero)

    Sharma VC

  • December 6, 2005 at 11:28 am

    #608010

    Sorry, I guess I do not have the answer.  I was only aware of being able to run SQL Server authentication as 1) Windows or 2) Mixed.  I presumed that your status setting of zero was in DMO and was concerned that perhaps SQL Server was not using mixed-mode and that was what was stopping you from the desired results.

    But then I only responded because your query had gone unanswered.  Anybody else have ideas?

    Cheers,

    david russell

Viewing 5 posts - 1 through 4 (of 4 total)

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