Share via

SQL 2016 Troubleshooting: A severe error occurred on the current command

Issue

The SQL Server Error log fails with the below error:

A severe error occurred on the current command.  The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)

https://1.bp.blogspot.com/-juXrHpWDCbY/WPZNFiswjoI/AAAAAAAAH9c/4ZUS6-S6DyMGgxHwnjS3rwZKqX4dy1FrwCLcB/s640/Untitled.jpg

Solution

We can do the following solutions:

  1. Solution 1: Repair the SSMS Tools of SQL Server 2016.
  2. Solution 2: Repair the SQL Server Instance.
  3. Solution 3: Create alias under SQL Server network configuration.

Please note:

Solution 3 will be more appropriate when we see the below error in Windows Event Viewer along with the above-mentioned error.

Severity: 16 Error:-1, OS: -1 [Microsoft][ODBC Driver 13 for SQL Server]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

Reference: