SQL server suddenly shut down

[Former Member]

Hi Friends,

We are using ECC 6 EHP 3 in Windows 2008r2 server with MSSQL 2005 .

And its running on 2 clusters .

Yesterday suddenly SAP was disconnected and DISP+WORK is went to gray status.for this we restarted the entire server .Now SAP is connecting and its working fine.

When ever we check for error log in sm21 Initialization DB-Connect Failed, Return Code 000256.

I want to know some information about this error.

At what time we will get this error.

What is the reason for this error .

how to fix this error.

As per my knowledge one of my friend try to change the password for SID user in MSSQL management studio. that time SAP is running.

Can any one help to find the reason for this error and let me know the effect of changing the SID password from SQL management studio while SAP application running time.

Please let me know any farther information required. 

[Former Member]

Hi,

It looks like - DB got disconnected while changing the password of schema owner.

What is the procedure that your friend followed to change the password of schema owner?

Regards,

Nick Loy

[Former Member]

Hi Nicy Loy,

How to confirm...weather DB got disconnected while changing the password of schema owner.

Is there any procedure to check logs in SAP.

[S_Sriram]

Hi Rao

Could you refer the SAP Note

610640 - sp_check_sap_login

BR

SS