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_member184473]

Hello Easwer,

Have you updated the password in the SQL Server Configuration Manager?

Also, check note 1294762 (schema repair).

Regards,

Eduardo Rezende

[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

[S_Sriram]

Hi Rao

Kindly share us the follow info

1. When you are disconnected the SAP session's what is the status of MS Sql DB group on cluster? and what is the status of SAP group in Failover cluster? your both node SAP instance are on?

2. Have you update the windows update & MS Sql Service pack ? could you share service pack details for both nodes & DB?

3. what is the kernel release & level ?

4. Over all free disk space in you DB & SAP usr folder disk?

5. Is this any error message in Failover cluster log ?

BR

SS

[Matt_Fraser]

If by the SID user you mean the schema user (with sid in lowercase), then it shouldn't have mattered if the password changed.  This isn't a Java or dual-stack system, is it?  ABAP-only?  Is your SQL Server authentication set to "Windows-only?"

Is there any more information you can provide from the SM21 system log?  Also, look in the developer traces for the work processes for related errors at the same time.

Regards,

Matt