Asset AQABAVIEW\SVR-SQL-03 is unavailable. Verify that it is available and reachable

[Migration User]

Good day

I have an issue when generate Collection-Evaluation-Reporting job, but before i explain this issue i will explain my CCS Tepology as below:

1- I have SVR-CCS-01 as reporting server that have the following Roles DPS and Application servers.
2- I have SVR-CCS-02 as RMS server (Information Server).

everything is OK when i importing assets or run Collection-Evaluation-Reporting job, but some times i have the following Error message when i run Collection-Evaluation-Reporting job as below:
"Asset AQABAVIEW\SVR-SQL-03 is unavailable.  Verify that it is available and reachable."

on the other hand, i guaranteed the following:
1- No firewall exist that prevent the traffic to pass.
2- The Remote Registry and Server services running on the target machine.
3- The CCS Admin has the full privileges on the target machine (Member of Domain Admin Group).
4- The system configured and communicated very well.

So please there is someone help to solve this issue



Best regards

[Migration User]

I had a similar situation for a client wherein they had applied one of the quarterly hotfixes but did not get all of the SQE's upgraded. This caused us to get wildly variable results with a large number of them being "System not reachable." I recommend running the Health and Status Report from the RMS console and verify that all SQE's are at the same CHF as the BV-IS.

[Migration User]

What are you mean about CHF and BV-IS, on another hand I run the Health and Status Report as you asked me and it is as below:

Client Version Summary

Product: bv-Control for Windows - Client Version: 9.0.3 Hot Fix: [None] Schema Versions: BindView Information Server: Local File List: 9.0.14.10000 bvCount.exe 9.0.14.10000 bvCountW2kMisc.dll 9.0.1612.20300 BVNTConsoleInterface.dll 9.0.14.10000 BVNTDB_Access.dll 9.0.1612.20300 BVNTError.dll 9.0.1612.20300 BVNTObjects.dll 9.0.1612.20300 BVNTQuery.dll 9.0.14.10000 BVNTRpc32.dll 9.0.1612.20300 BVNTSetup.dll 9.0.14.10000 BVNTSysObjs.dll 9.0.14.10000 BVNTUninstall.exe 9.0.14.10000 BVPatchManagerUtils.dll 9.0.14.10000 BVQEADUtils.dll 9.0.14.10000 BVQEConfig.exe 9.0.14.10000 BVQESupportSvc.exe 9.0.1612.20300 BVVNTScopes.dll 9.0.1612.20300 CreateScopeFile.exe 9.0.14.10000 CreateScopeFileStub.exe 9.0.14.10000 EcsBase.dll 9.0.14.10000 EcsCommon.dll 9.0.14.10000 NTAASnapin.dll 9.0.14.10000 NTAESnapin.dll 9.0.1612.20300 NTBackEndSnapin.dll 9.0.14.10000 NTCommonUtils.dll 9.0.14.10000 NTDialogPages.dll 9.0.14.10000 NTEnvrStub.exe 9.0.1612.20300 NTFunctions.dll 9.0.14.10000 NTIcons.dll 9.0.1612.20300 NTProductModule.dll 9.0.1612.20300 NTSIQueryDispatcher.dll 9.0.14.10000 NTTIVExtensions.dll 9.0.14.10000 NTUISnapin.dll 9.0.14.10000 NTUIUtils.dll 9.0.14.10000 ProductIcon.exe 9.0.1612.20300 ScopeFileUtility.dll 9.0.14.10000 VirtualDatabase.dll 5.8.0.5 stConvertXML.dll 1.1.3.3850 bvMSSecure.xml

Server Version Summary

Product: bv-Control for Windows - Server Version: 9.0 Hot Fix: [None] Schema Versions: 4.4.0.0 FieldMetaData.mdb 4.4.0.0 BPM.mdb 4.4.0.0 IIS.mdb 4.4.0.0 ActiveDirectoryFieldsMetaData.mdb 4.4.0.0 WSUS.mdb   File List: 9.0.1612.20300 BVNTConsoleInterface.dll 9.0.1612.20300 BVNTObjects.dll 9.0.1612.20300 BVNTQuery.dll 9.0.14.10000 BVNTRpc32.dll 9.0.14.10000 BVNTSysObjs.dll 9.0.1612.20300 CreateScopeFile.exe 9.0.14.10000 CreateScopeFileStub.exe 9.0.14.10000 EcsCommon.dll 9.0.1612.20300 NTBackEndSnapin.dll 9.0.14.10000 NTCommonUtils.dll 9.0.14.10000 NTIcons.dll 9.0.1612.20300 NTSIQueryDispatcher.dll 9.0.14.10000 NTTIVExtensions.dll 9.0.14.10000 VirtualDatabase.dll 1.1.3.3850 bvMSSecure.xml

General Information Server Settings

Minimum Disk Space Settings Minimum Free Disk Space: 100 Below Minimum Free Disk Space Time Out: 20 Skip License Options Skip Servers: No Skip Workstations: No Information Server to MQE Communication Settings Communication Buffer Size: 10485760 Query Poll Interval (in seconds): 1

Enterprise Configuration Service

Machine: SVR-CCS-DC-03 Host Name: SVR-CCS-DC-03.AqabaView.com IP Address: 10.10.20.201 Port: None Configured Major Version: 9 Minor Version: 0

Master Query Engines
Machine	Domain / Workgroup	Status	Security	Major	Minor	Hotfix	Forest	Principal Name	Reporting Mode	QE Information	Scope Refining Agent
SVR-CCS-DC-03	AQABAVIEW	Connected	* Accept queries only if client authenticated (allow to use RPC security)	9	0	None	AqabaView.com	LDAP/SVR-CCS-DC-03.AqabaView.com	Domain	no data	15

This data is from the Bindview Information Server's cache (connection.mdb) of Master Query Engines.

Slave Query Engines
Machine	Domain / Workgroup	Security	Major	Minor	Hot Fix(es)	Forest	Principal Name	QE Information	Data Collection Agent	ActiveAdmin Agent
SVR-CCS-DC-03	AQABAVIEW	* Accept queries only if client authenticated (allow to use RPC security)	9	0	None	AqabaView.com	LDAP/SVR-CCS-DC-03.AqabaView.com	no data	6	6

This data is from Enterprise Configuration Service's list of Slave Query Engines.
The data in the agent count columns was obtained by submitting a query to the Query Engine(s) in this user's connection data base.

Slave Query Engine Assigments
Master Query Engine	Slave Query Engine
SVR-CCS-DC-03
	SVR-CCS-DC-03

This data is from Enterprise Configuration Service's list of Slave Query Engine assignments.

Query Engine Communication Settings
Machine	Protocol Sequence	Host Name	IP Address	Port
SVR-CCS-DC-03	ncacn_ip_tcp	SVR-CCS-DC-03	10.10.20.201	<default>
SVR-CCS-DC-03	ncadg_ipx	SVR-CCS-DC-03	SVR-CCS-DC-03	<default>
SVR-CCS-DC-03	ncacn_spx	SVR-CCS-DC-03	SVR-CCS-DC-03	<default>

This data is from Enterprise Configuration Service's list of Query Engines Communication Settings.

Distribution Rules
Master Query Engine	Rule	Expression Type	Rule Type	Expression	Split Type

This data is from Enterprise Configuration Service's Distribution Rules per Master Query Engine.

Support Services
Machine	Domain	Host Name	IP Address	Port	DNS Domain
SVR-CCS-DC-03	AQABAVIEW	no data	no data	<Default>	no data

This data is from Enterprise Configuration Service's list of Support Services.

Administrative Share Selection

Use Default Administrative Shares: Yes Auto Discover Administrative Shares: No Apply Rule For Naming Administrative Shares: No

This data is from Enterprise Configuration Service's administrative share selection.

Connection Data base(s)
Connection Data Base	Master Query Engines
connDB
	SVR-CCS-DC-03

Default Connection Database

connDB

User Connection Data Base Assignments

User Connection Database AQABAVIEW\Administrator connDB

User Options

Users that use credentials for queries AQABAVIEW\Administrator

Domain / Workgroup Credential Configuration Summary

Credentials for the following domains/workgroups configured in bv-Control for Windows Domain / Workgroup Account AQABAVIEW AQABAVIEW\administrator

So if there is any error in above report please tell me.

[Migration User]

Have you installed Service Pack 1 and the November Hot Fix? If so, you will need to upgrade the ECS and your Query Engines as they are still showing the pre-SP1 level.