IMPORTANT ANNOUNCEMENT: On May 6, 2024, Carbon Black User eXchange (UeX) and Case Management will move to a new platform!
The Community will be in read-only mode starting April 19th, 7:00 AM PDT. Check out the blog post!
You will still be able to use the case portal to create and interact with your support cases until the transition, view more information here!

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:
1022
Contributors