Java Stack does not start (Login failed for user 'SAP<SID>DB")

[HenryLeung]

Hi,

When I try to start the Java stack, the jstart.exe process will try to start but it would stop.  The following log seems to be pointing to the culprit.

===============

jvm_bootstrap.out

===============

Caused by: com.sap.sql.log.OpenSQLException: Exception of type com.microsoft.sqlserver.jdbc.SQLServerException caught: Login failed for user 'SAPJD1DB'. ClientConnectionId:bfe2f7f5-702f-4bcd-bfb7-aec8e0694d03.

I tried changing the password for SAPJD1DB using the config tool but it is still not starting.  I'm not sure whether I missed a step with the password change or I'm on the completely wrong track.

Any help would be appreciated. Thanks.

Henry

[manumohandas82 · Accepted solution]

Hi Henry ,

Please post the full log file

Thanks ,

Manu

[HenryLeung · Accepted solution]

I've attached the jvm_bootstrap.out file.

Thanks.

jvm_bootstrap.out.zip

[Former Member · Accepted solution]

Hi Henry,

What is the current authentication mode of your MS SQL database?

Please confirm if this is set to Mixed authentication mode.

Regards,

Pradeep

[HenryLeung · Accepted solution]

Hi Pradeep,

That was it.  It was somehow changed to Windows Authentication only.  Everything is working now.  Thanks.

Henry

[manumohandas82]

Hi Henry ,

Please check the following Note

1950926 - System cannot start due to login SQLServerException

and complete the rest of the tasks

Thanks ,

Manu