Post reply

windows authentication

  • April 20, 2009 at 2:29 am

    #384396

    Hi

    in sql server the users are windows authenticated and sys administrators.

    How to restrict the users in My server without sysadmin.

    (if need to create group, is it to create in production server)

    how to navigate that plz help me.

    With regards

    Lee

  • April 20, 2009 at 2:46 am

    #980557

    Are you using Domain Accounts for Windows Authentication?

    If yes, remove 'Builtin\Administrators' from security and add each Domain Acocunt with proper permissions.

    And if the users are accessing SQL Server directly from the Database server Machine (as sys administrators), SQL Server Authentication would be a better option after removing the 'Builtin\Administrators' from security.

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

  • November 25, 2009 at 12:21 am

    #1083831

    I have the Active active Clusters and I want to do this.If today I have removed the Buitin/Administrators from security Can I get it Tomorrow.

    Are u sure only the deletion of Builtin/Administrators Group will restrict the windows Admin...Suggest

    Thanks

  • November 25, 2009 at 12:28 am

    #1083835

    Ajay you might probably want to read this link

    http://support.microsoft.com/kb/263712

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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