Situation

Yesterday, my database server was restarted because of OS update but SQL Server instance could not start. I tried to find out errors in the ERRORLOG file of SQL Server. Error messages as below

2016-12-15 11:20:28.42 Server Warning: Support for the VIA protocol is deprecated and will be removed in a future version of Microsoft SQL Server. If possible, use a different network protocol and disable VIA.
2016-12-15 11:20:28.48 spid11s Clearing tempdb database.
2016-12-15 11:20:28.84 Server A self-generated certificate was successfully loaded for encryption.
2016-12-15 11:20:28.84 Server Error: 26055, Severity: 16, State: 1.
2016-12-15 11:20:28.84 Server The SQL Server failed to initialize VIA support library [QLVipl.dll]. This normally indicates the VIA support library does not exist or is corrupted. Please repair or disable the VIA network protocol. Error: 0x7e.
2016-12-15 11:20:28.84 Server Error: 17182, Severity: 16, State: 1.
2016-12-15 11:20:28.84 Server TDSSNIClient initialization failed with error 0x7e, status code 0x60. Reason: Unable to initialize the VIA listener. The specified module could not be found.

2016-12-15 11:20:28.84 Server Error: 17182, Severity: 16, State: 1.
2016-12-15 11:20:28.84 Server TDSSNIClient initialization failed with error 0x7e, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. The specified module could not be found.

2016-12-15 11:20:28.84 Server Error: 17826, Severity: 18, State: 3.
2016-12-15 11:20:28.84 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2016-12-15 11:20:28.84 Server Error: 17120, Severity: 16, State: 1.
2016-12-15 11:20:28.84 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

I focused on the error “Server TDSSNIClient initialization failed with error 0x7e, status code 0x60. Reason: Unable to initialize the VIA listener”.

It seemed the SQL Server tried to initialize the VIA (Virtual Interface Adapter) protocol but it could not and it caused SQL Server service was not started.

Solution

In case of my issue, I don’t need VIA protocol so I tried to disable this protocol.

  1. Open SQL Server Configuration Manager
  2. Go to Protocol…
  3. Disable VIA protocol

To understand more detail about VIA, click here.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s