SQL SERVER – Unable to Repair – SQL_Telemetry_Repair_Startup_Cpu64 gives error – The Service Cannot Be Started
SQL SERVER Data Tools – SSDT for Visual Studio 2017 Installation Error 0x80070002: Error 0x80070002: Failed to Acquire Payload
I was trying to build a new machine for my demo purposes and wanted to install everything possible related to Data. SQL Server Data Tools (SSDT) is also needed to complete the package. I downloaded it from here.
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
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.
SQL SERVER – Error: 17300 – SQL Server Was Unable to Run a New System Task
They noticed that application jobs are failing with the below error message about running a new system task. Let us learn more about this.
SQL SERVER – Add Node Error – Rule “SQL Server Database Services Feature State” Failed
While deploying SQL Server 2016 cluster in my lab I ran into this problem when I was trying to add a second node to the SQL cluster. Let us learn about Add Node Error and how to solve it in this blog post.
SQL SERVER – Startup Error – Your SQL Server Installation is Either Corrupt or Has Been Tampered With
While playing with my virtual machines, I screwed up something and my SQL service for my named instance was failing to start. Let us learn about a startup error.
When I tried to start via services.msc, here was the error