Microsoft KB Archive/927975

From BetaArchive Wiki
Knowledge Base


Article ID: 927975

Article Last Modified on 12/6/2006



APPLIES TO

  • ProClarity Analytic Server



SYMPTOMS

In ProClarity Analytics Server (PAS), you cannot connect to the ProClarity Analytics Server Administration Tool. The problem occurs in the following products:

  • PAS 5.2
  • PAS 5.3
  • PAS 6.0


CAUSE

The problem occurs because the administrator role is removed from the Administration Tool.

RESOLUTION

To resolve this problem, restore the administrator role. To do this, use one of the following methods.

Method 1

Reinstall the PAS server, and then create a new database. You can use this method if you do not want to preserve the contents that you created on the previous PAS server. When you reinstall the PAS server, you can create a new database by using a new name. You can also import the existing database from an instance of Microsoft SQL Server.

Notes

  • Before you reinstall the PAS server, make a backup of customizations that you created on the previous PAS server.
  • Make sure that you have a backup of the old database before you delete the database.
  • After you connect to a new database, all the contents of the old database do not appear. For example, the briefing books, the libraries, and the roles in the old database do not appear.

Method 2

Assign a PAS administrator role to the Everyone group by using SQL Server Enterprise Manager.

Note After you assign the PAS administrator role to the Everyone group, all users will have the administrative right in PAS.

To do this, follow these steps:

  1. In SQL Server Enterprise Manager, expand Microsoft SQL Servers, expand SQL Server Group, expand ServerName, and then expand Databases.
  2. Expand the briefing book database, and then click Tables.


Note By default, the briefing book database is one of the following databases:

    • ProClarity_BBS
    • ProClarity_PAS
  1. In the Tables list, right-click Roles, point to Open Table, and then click Return all rows.
  2. Select the GUID in the RoleID field for the administrator role, right-click the GUID, and then click Copy.
  3. Close the Data in Table 'Roles' dialog box.
  4. In the Tables list, right-click Members, point to Open Table, and then click Return all rows.
  5. In the Data in Table 'Members' dialog box, locate the line under the last record in the table.
  6. Right-click the MemberID field, and then click Paste.
  7. Type Everyone in the Caption field, and then type S-1-1-0 in the SID field.
  8. Make sure that the value in the Created By field is ProClarity.
  9. Right-click the RoleID field, and then click Paste.
  10. Make sure that the value in the MemberType field contains UNIVERSAL.
  11. Save the table, and then close the Data in Table 'Members' dialog box.

Method 3

Assign a PAS administrator role to the Everyone group by using SQL Server Management Studio.

Note After you assign the PAS administrator role to the Everyone group, all users will have the administrative right in PAS.

To do this, follow these steps:

  1. In SQL Server Management Studio, expand the name of the server, and then expand Databases.
  2. Expand the briefing book database, and then click Tables.


Note By default, the briefing book database is one of the following databases:

    • ProClarity_BBS
    • ProClarity_PAS
  1. In the Tables list, right-click dbo.Roles, and then click Open Table.
  2. Select the GUID in the RoleID field for the administrator role, right-click the GUID, and then click Copy.
  3. In the Tables list, right-click dbo.Members, and then click Open Table.
  4. Locate the line under the last record in the table.
  5. Right-click the MemberID field, and then click Paste.
  6. Type Everyone in the Caption field, and then type S-1-1-0 in the SID field.
  7. Make sure that the value in the Created By field is ProClarity.
  8. Right-click the RoleID field, and then click Paste.
  9. Make sure that the value in the MemberType field contains UNIVERSAL.
  10. Save the table.


Keywords: kbtshoot kbprb KB927975