How to check database schema user expire

[Former Member]

Dears,

We have ECC5 on SQL with ABAP+JAVA Stack.

From Yesterday my java engine is not working and from the logs of server it's indicating that Java engine is not able to connect to DB.

ABAP system is working finr and in MMC all processes is green.

So I am expecting that might be my database schema passwrd has expired.

Please suggest how can I check it,I seached a lot of SQL query but not found to check it.

We have following database users:

DBO

PRO<SID>

SAPPRODB

SAPSERVICEPRO

SAP_PRO_ADMIN

Deepak.

[Former Member]

Hai,

In SQL Server 2005,you can change the password by going SQL Server Management Studio->Security->Logins and in the right hand side,you can see the users.Right click on the scheme user and goto properties and change the password in the General column.Also check the status of the user is locked or not.

If you changing the Scheme User password(SAP<SID>DB),change the same in the configtool->secure store and change in the jdbc/pool/<SID>/Password and check whether it is connecting to DB or not.

Thanks and Regards,