BookmarkSubscribeRSS Feed
techie
Fluorite | Level 6

Hi Team,

We are not aware of the SharedServices Password and in dire need to retrieve the same. Please could any one help in this case.

Please note :: We have already referred the below doc but in here it states the dbmsowner password retrieval.

How-to-manually-update-the-SharedServices-dbmsowners-password-in-PostgreSQL.pdf (aii-3.com)

2 REPLIES 2
ronf_sas
SAS Employee

Hi,

SAS Technical Support can help you if you do not know the SharedServices password.  Please open a track.

 

 

IR_SAS
Calcite | Level 5

This document can help you.

How to manually update the SharedServices dbmsowners password in PostgreSQL

 

For when the SAS administrator’s nightmare comes true, the SAS Passwords (for SAS platform) were lost, changed without record or while updating password, mistyped and now a new set of SAS “update Password” needs to run via SAS Deployment Manager. Problem, that process requires knowing the SharedServices password before update Password utility could be successfully run.

 

Follow these steps:

 

1. Edit <SASROOT>\SAS\Config\Lev1\WebInfrastructurePlatformDataServer\data\pg_hba.conf and change md5 to trust for "host all all all" (note 1st line is un-commented)

 

# TYPE DATABASE USER ADDRESS METHOD

 

# IPv4 local connections:

 

 

host all all all trust
# IPv6 local connections:
#host all all ::1/128 md5

# Allow replication connections from localhost, by a user with the # replication privilege.

 

 

#host replication dbmsowner all md5

 

#host replication dbmsowner ::1/128 md5

 

2. Reload the pg_hba.conf

 

cd /SASHome/SASWebInfrastructurePlatformDataServer/9.4/bin

 

./pg_ctl.sh -D config/Lev1/WebInfrastructurePlatformDataServer/data reload

 

3. Now change the password with psql

 

cd <SASHome>/SASWebInfrastructurePlatformDataServer/9.4/bin

 

./psql.exe -d SharedServices -U dbmsowner -p 9432

 

ALTER ROLE dbmsowner with PASSWORD 'newpassword';

 

1. Input above line to postgres cli, press enter then enter the new password.

 

\q (to quit)

 

Change the pg_hba.conf back and reload (steps 1 and 2).

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1123 views
  • 2 likes
  • 3 in conversation