Forum Discussion

shenhsu's avatar
shenhsu
Copper Contributor
Jul 19, 2023

Is it possible to find out who change the restrict access in SQL Log?

Hello all,   we have newly installed a SQL 2022 Server with database version 16.0.4055.4.   Somehow the restrict access will be automatically changed from MULTI_USER to SINGLE_USER. And therefore...
olafhelper's avatar
olafhelper
Bronze Contributor
Jul 21, 2023
SQL Server started in single-user mode.

shenhsu , by default SQL Server start in multi-user mode. Only an admin change change stettings, so the anser is: It was an admin.

  • shenhsu's avatar
    shenhsu
    Copper Contributor
    Jul 21, 2023

    olafhelper 

     

    Hello Olaf, 

     

    thank you for your reply. 

    I found out that the Database was changed automatically in to single_user modus directly after the installation of DB patches. 

     

    So it is like after installation of a new patch, every service got shutted down and the SQL Server restart in a single user modus with the message "SQL Server wurde im Einzelbenutzermodus gestartet. Diese Meldung dient nur zu Informationszwecken. Es ist keine Benutzeraktion erforderlich. (SQL Server started in single user mode. This message is for informational purposes only. No user action is required.)"

    • Ben_Miller_DBADuck's avatar
      Ben_Miller_DBADuck
      MVP
      Jul 22, 2023
      When installing SQL patches, SQL Server may start in SINGLE user mode to apply patches, but it should not remain in SINGLE user mode after the patches are fully applied.
      • shenhsu's avatar
        shenhsu
        Copper Contributor
        Jul 25, 2023

        Ben_Miller_DBADuck 

         

        Thank you for the information. I noticed sometimes it remains but sometimes not.

        But the main thing is that I know where the problem is. 

        Thank you 🙂 

Resources