How to Display the SSO Database Information
You can view SSO database information by using the MMC Snap-In or the command line (ssomanage) utility.
To display the SSO database information using the MMC Snap-In
On the Start menu, click All Programs, click Microsoft Enterprise Single Sign-On, and then click SSO Administration.
In the scope pane of the ENTSSO MMC Snap-In, expand the Enterprise Single Sign-On node.
Right-click System, and then click Properties.
Click the tabs on the System Properties dialog box to view SSO database information.
To display the SSO database information using the command line
On the Start menu, click Run, and then type cmd.
At the command line prompt, go to the Enterprise Single Sign-On installation directory. The default installation directory is <drive>:\Program Files\Common Files\Enterprise Single Sign-On.
Type ssomanage –displaydb.
Note
On a system that supports User Account Control (UAC), you may need to run the tool with Administrative privileges.
To display the SSO database the SSO Server is connected to using the command line
On the Start menu, click Run, and then type cmd.
At the command line prompt, go to the Enterprise Single Sign-On installation directory. The default installation directory is <drive>:\Program Files\Common Files\Enterprise Single Sign-On.
Type ssomanage –showdb.
Note
On a system that supports User Account Control (UAC), you may need to run the tool with Administrative privileges.
The following table describes the values displayed by these procedures.
| Property | Value |
|---|---|
| SQL Server | <SQL Server name> |
| Single Sign-On database | <SQL Server database name> |
| Single Sign-On Secret Server name | <Single Sign-On Server name> |
| Single Sign-On Administrators account | Domain\account name |
| Single Sign-On Affiliate Administrators account | Domain\account name |
| Size of audit table for deleted applications (number of audit entries) | 1,000 (default) |
| Size of audit table for deleted user mappings (number of audit entries) | 1,000 (default) |
| Size of audit table for external credential lookups (number of audit entries) | 1,000 (default) |
| Ticket timeout (in minutes) | 2 (default) This value can be an integer from1 through 525,600 |
| Credential cache timeout (in minutes) | 60 (default) |
| Single Sign-On Status | Enabled/disabled |
| Tickets allowed | Yes/no (default) |
| Validate tickets | Yes (default)/no |