Unable to log in as Partition Administrator (pa) or System Administrator (sa)

From DocWiki

Revision as of 19:33, 15 November 2011 by Ginod (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


Contents

Scenario Setup

Log all administrators out

Database Server

  1. Set PA and SA passwords to some random encrypted text

Problem Statement

Unable to log in to the default partition as pa. The login will fail:

LoginFailed.png


The same is true for the system partition. Remember that the sa user is a system user and can only log in to partitionId=0. The login will fail the same as for pa.

Administrator user eG Database
PA eGActiveDB
SA eGMasterDB

No more administration?

SA and PA are just standalone users defined in eGMasterDB and eGActiveDB, respectively.

The passwords are encrypted once set. If a customer forgets their password, it can be blanked out and reset from within the UI.

Reset SA password:

Run the following against the eGMasterDB:

select * from egpl_user

SaPassQuery.png

  Verify that the SA user's ID is 1. Then run the following query, also against the eGMasterDB:

UPDATE egpl_user WITH (ROWLOCK) SET password = '', case_insensitive_password = '' WHERE user_id = 1;

Reset PA password:

Run the following against the eGActiveDB:

select * from egpl_user

Pa.png

  Verify that the PA user's ID is 1. Then run the following query, also against the eGActiveDB:

UPDATE egpl_user WITH (ROWLOCK) SET password = '', case_insensitive_password = '' WHERE user_id = 1;

Reset Passwords from UI

Log in as SA and PA with blank passwords. Navigate to the Administration console > Users and change the password.

SaPass.png


Resolution

Resetting forgotten PA and SA user (and other standalone user) passwords is simple with a few quick SQL queries and updates.

Rating: 0.0/5 (0 votes cast)

Personal tools