Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2007
    Location
    India
    Posts
    21

    Unanswered: Removing Windows Authentication

    We have our project installed in client place.

    Operating system Windows 2003
    Databases on SQL Server 2005

    I have backup jobs running daily(owner <servername>\Administrator)
    I have mirrored using certificates
    SQL services logon as <servername>\Administrator


    We want to disable the SQL Server windows authentication login.

    I have a plan to remove below logins:

    <servername>\Administrator
    Builtin\Administrator
    <servername>\SQLServer2005MSFTEUser$<servername>$M SSQLSERVER
    <servername>\SQLServer2005MSSQLUser$<servername>$M SSQLSERVER
    <servername>\SQLServer2005SQLAgentUser$<servername >$MSSQLSERVER


    Please help me in finding what side effects I will face if i do this.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    As far as I know some of these accounts cannot be disabled. If you succed in disabling <servername>\administrator the SQL services will stop running as it's the one used at the moment. Disabling some of the others can cause a lot of troubles.

    See: How to disable the Local Administrator account in Windows
    Security Watch: Why You Should Disable the Administrator Account
    Setting Up Windows Service Accounts

    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •