This solved a couple minor problems but did not address the question of membership by the errant server. This story had begun when to address a problem of membership in my domain by a non-DC server (a consequence of changing ISP), I rebuilt the DC into Windows Server 2008 R2 from 2008. Also, at least in my experience, membership in my computer's local Administrator's group did not grant sysadmin status to my "user" account. Unfortunately, what it means to start in single-user mode is not an intuitive matter. Any member of the computer's local Administrators group can then connect to the instance of SQL Server as a member of the sysadmin fixed server role." "Start the instance of SQL Server in single-user mode by using either the -m or -f options. In an otherwise good article Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out, the author tells us that all we have to do to regain control of our SQL Server is to
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |