SQL SERVER – Unable to Start SQL Service Error: 17172 – SNIInitialize() Failed with Error 0x2

While preparing a lab for my upcoming training session, I was trying to play with the cluster. While doing that I was in a situation where I was unable to start SQL Service.

I looked into SQL Server ERRORLOG to see the cause of SQL Startup failure. Here were the last messages logged in the ERRORLOG. If you are new to SQL Server then refer below blog to find the location of the ERRORLOG file. SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location

Read More

SQL SERVER – Error: 17142 – SQL Server Service has Been Paused. No New Connections Will be Allowed

Recently I was looking around in my virtual machine to find a topic to blog. Within a few minutes, I was having an idea. In this blog we would talk about an interesting feature “Pause SQL Server”. As stated via official Microsoft documentation “Pausing the Database Engine service prevents new users from connecting to the Database Engine, but users who are already connected can continue to work until their connections are broken. Use pauses when you want to wait for users to complete the work before you stop the service. This enables them to complete transactions that are in progress”. Let us learn about how to fix the issue when the new connections are not allowed. 

Read More