Post reply

Sysadmin Role

  • June 8, 2005 at 2:52 pm

    #109729

    I have just noticed that my local administrator on my server is no longer a member of the sysadmin role in SQL 2000 enterprise manager the sql sa login is the only one that is a member anymore.  Does anyone have any idea of what could have caused this to happen?  The only thing that has been done on SQL is it was upgraded to Service Pack 4 recently.  I appreciate anyones feedback.

    Thanks,

    Clarke

  • June 9, 2005 at 12:27 am

    #564074

    Did you check what all has changed with SP4? It comes with a file (txt or htm) with all the changes.

    I can imagine that because of security reasons this has been changed. There is no need to let the local admin has sa rights in de database server.

  • June 9, 2005 at 5:09 am

    #564143

    I installed SP4 on 3 or 4 servers with no change in the sysadmin role.


    Pat Mong

  • June 9, 2005 at 9:12 am

    #564256

    We did the same as ccc24 with no changes.  Did someone remove BUILTIN\Administrators, maybe?

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

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