Post reply

How to disable windows authentication on sql server

  • July 31, 2008 at 1:38 am

    #122785

    Hi all,

    I would like to know if its possible to remove windows authentication mode of logging into sql server altogether.

    Thanks

    Nirmal

  • July 31, 2008 at 3:37 am

    #851107

    No, that's not possible. I think the main reason why not, is the fact the the service account(s) can only be windows accounts and they need access to the server.

    [font="Verdana"]Markus Bohse[/font]

  • July 31, 2008 at 3:52 am

    #851116

    If I am not wrong, you can prevent windows admin to access sql server by disabling builtin admin in sql server.

    Cheers,

    DKG

  • July 31, 2008 at 5:26 am

    #851172

    from server config point of view you only have the options of

    mixed mode

    windows

    From the logins point of view you could remove builtin\administrators and any other windows groups\users, etc and this would remove the ability to login to sql server using windows accounts

    i wouldnt remove the NTAUTHORITY acoount though as i'm sure thats required

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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