topic Re: SAS WIP Service not starting with Fatal: FATAL: role "sas" does not exist in Administration and Deployment

SAS WIP Service not starting with Fatal: FATAL: role "sas" does not exist

shoin — Mon, 07 Aug 2023 17:57:27 GMT

SAS 9.4 TS1M8 on RHEL 9.2 single machine plus clients-OA solution.

Install and validation were successful no issue, a restart via sas.servers ended up SAS WIP not starting, looking at the console log for WIP, it shows as "server started" the WIP logs shows:

[16682] LOG: database system is ready to accept connections
[16706] FATAL: role "sas" does not exist

The only change was post validation the installer ID: sas password was changed. This is an external ID, and post PWD change a new pvt key was generated for the server login.

The response files check out no wrong input. The dbmsowner ID were properly used. I have not found much on Google.

Thank you in advance for any insights.

Re: SAS WIP Service not starting with Fatal: FATAL: role "sas" does not exist

Patrick — Tue, 08 Aug 2023 06:58:28 GMT

If you don't get an answer here contact SAS Tech Support.

Re: SAS WIP Service not starting with Fatal: FATAL: role "sas" does not exist

gwootton — Tue, 08 Aug 2023 14:12:09 GMT

Have you seen this SAS Note?

This message suggests it's trying to log in with the account "sas" instead of "dbmsowner"

https://support.sas.com/kb/52/647.html