During maintenance activity we try to bring down SQL server gracefully without impacting existing transactions and not accepting new connections. One of the best options to accomplish this is to PAUSE SQL Service using SQL Server configuration Manager.
Pausing SQL Service using Server configuration Manager will not allow SQL Server to accept new connections but leave all existing connections as-is until they are closed, DBA can validate when the SQL Server can be shutdown. This minimizes end user impact, none of the transactions needs to be rolled back.
SQL Server service has been paused. No new connections will be allowed. To resume the service, use SQL Computer Manager or the Services application in Control Panel.
Login failed for user ”. (Microsoft SQL Server, Error: 17142)
The option is verified on Stand Alone SQL Server.
Make sure to use SQL Server Configuration Manager rather than using windows services services.msc to pause the service