User Profile
shenhsu
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: Is it possible to find out who change the restrict access in SQL Log?
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.)"1.1KViews0likes2CommentsIs 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 it caused a service crash. It happened until now three time periodically but on the server I cant find out which service or task did this job. I tried to find out information unter C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Log The only relevant records I could find are: 2023-07-18 05:33:14.47 Server The maximum number of dedicated administrator connections for this instance is '1' 2023-07-18 05:33:14.51 spid19s SQL Server started in single-user mode. This an informational message only. 2023-07-18 05:33:15.14 Logon Login failed for user 'XXXX'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: <local machine>] But I cant comprehend who did this change. Can someone give me an idea? Thank you.1.1KViews0likes4CommentsTeams stops sending messages (but still able to get messages) after disconnecting from company vpn
Hello everyone, We have an issue in our company. After our cowrkers disconnect their home internet from vpn or due do technical problem shortly a few seconds away from vpn, Teams stops sending messages but can still receive messages from others. To get it work again, we have to restart the program completely. Is there a solution for this problem? Thank you in advance.2.6KViews0likes2Comments
Recent Blog Articles
No content to show