English

Problem: sdemon -o info -I users does not report current connections

Description

The command 'sdemon -o info -I users' does not show any connections when users are connected to ArcSDE.

Cause

This problem is specific to SQL Server 2005 and is caused by not assigning the SDE user the 'VIEW SERVER STATE' permission.

Solution or Workaround

  1. Open SQL Server Management Studio and select the SQL Server instance.
  2. Right-click the instance and select Properties.
  3. On the left, select 'Permissions' and scroll to and select 'SDE' user on the right.
  4. Under 'Explicit Permissions for SDE:', scroll to the bottom and click the Grant checkbox for 'View server state.'
  5. Click OK.

Related Information