All MIBs › CONTROLLER-MIB › sqlServerService
sqlServerService
Module: CONTROLLER-MIB
OID (symbolic): CONTROLLER-MIB::sqlServerService
OID (numeric): 1.3.6.1.4.1.31218.4.2
Node type: OBJECT-TYPE
Type: INTEGER
Access: read-only
Description: Indicates the status of SQL Server service (1) Running, service is running (2) Stopped, service is stopped or crashed (3) Disabled, service is disabled by configuration.
What is sqlServerService?
A read-only enumerated value reporting whether the controller's SQL Server service, which backs the controller's database, is running, stopped, or disabled. Since the database likely stores user accounts, session logs, or configuration data, a stopped SQL service can break authentication or logging even while the network itself keeps passing traffic. If users suddenly can't log into the captive portal and sqlServerService shows "stopped," the admin would restart the database service before investigating other causes.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.31218.4.2 snmpwalk -v2c -c public <target> CONTROLLER-MIB::sqlServerService
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.31218.4.2.1 snmpget -v2c -c public <target> CONTROLLER-MIB::sqlServerService.1
Start monitoring Ucopia Communications Wi-Fi/hotspot access controller appliance with a free 30-day trial of IPNetwork Monitor. Create custom SNMP monitor using the CONTROLLER-MIB::sqlServerService OID value, configure state conditions and alerts, and monitor any Ucopia Communications Wi-Fi/hotspot access controller appliance from a single console.
OID Breakdown
Upper-level ancestors (6 from the standard OID tree / other modules)
| Numeric OID | Name | Module |
|---|---|---|
| 1 | iso | LANART-AGENT |
| 1.3 | org | AirPair-MIB |
| 1.3.6 | dod | AirPair-MIB |
| 1.3.6.1 | internet | AirPair-MIB |
| 1.3.6.1.4 | private | AirPair-MIB |
| 1.3.6.1.4.1 | enterprises | AirPair-MIB |
| Numeric OID | Name | Module |
|---|---|---|
| 1.3.6.1.4.1.31218 | ucopia | CONTROLLER-MIB |
| 1.3.6.1.4.1.31218.4 | serviceStatus | CONTROLLER-MIB |
| 1.3.6.1.4.1.31218.4.2 | sqlServerService | CONTROLLER-MIB |