Just Published! Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

Server patch upgrade failed

Server patch upgrade failed

Version

7.x.

 

Issue

Server patch upgrade failed.

 

Symptoms

Upgrade log shows the following error message:

 

UPGRADEDB: Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Unable to complete login process due to delay in opening server connection.

 

UPGRADEDB: A critical database script (migrate.sql) needed to install Bit9 Server failed.

 

Cause

Database permission and/or network connection to the SQL server.

 

Solution

  • On the Bit9 server, go to %Program Files%\Bit9\Parity Server folder and open the shepherd.dsn on a notepad. Check the user account set there. If it's set to Windows Authentication, then the user account logged in is having a problem connecting to SQL. If it's set to a SQL account, then it's that SA account that has a problem connecting to SQL. Required permissions are listed on solution 'Bit9 service account permissions'.
  • Please note that 7.2 enforces that all required permission are present, so this account may have worked in the past but not for 7.2 if any permission is missing.
  • If all of those permissions are set, check the network connection between the Bit9 server and the SQL server.
  • Please check too that the SQL Server service is running. If it’s on a 2-tier set up, please check that the SQL Server Browser service is also running.
Labels (1)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎01-16-2015
Views:
672
Contributors