Timeout Expired: error on mssql server and not able to connect to the Database in sap

[chandrababu_katta]

Hi,

     We are running SAP ERP6.0 ehp6 IDES version on Windows Server 2008 R2 and Database as MS SQL Server. We recently getting an error frequently like "Timeout expired: The timeout period elapsed prior to completion of the operation or the server is not responding(Microsoft SQL Server)" while trying to connecting the database using "Windows ms sql dtabase studio".

       Can anyone please help me to fix this issue, we running this instance from last one year but didn't get any of error like this. At this time the SAP Instance was very slow and sometimes we not able to login also to this we try to stop the instance using MMC nad again start the sap instance then its able to login and works fine.., but after few hours like after 24 hrs the same problem occurs and we just try to stop and start.

      Please help me to fix this to avoid the inconvenience.

Thanks in Advance,

Chandrababu Katta

[giri_ayyagari]

Hi chandrababu

Check SQL Server Browser Service is Running,  not in disable state. Make it Enable by right click on it and change "disable" status then start service. you should be able to connect. Post updates.

-Giri

[Matt_Fraser]

The SQL Server Browser service is only required if you are using named instances and/or have more than one instance of SQL Server installed on the same host, or if you are using a non-default UDP port for the SQL Server service. For default/typical SAP installations, the Browser is not required and does not need to be running.

[Matt_Fraser]

Hi Chandrababu,

Are you still having this issue? If so, I would look into your server's memory consumption. If that screenshot is correct, your server has less than 4 GB of memory total, and that is not enough to run an SAP system like ERP 6 EhP6, especially with SAP and SQL Server on the same host.

Regards,

Matt

[Former Member]

Hi,

Check whether SQL Server Service is running?

[chandrababu_katta]

Sandeeep,

        Yes, The SQL Server Service was running..

[srinivasan_vinayagam]

Hi Chanra,

You can apply above fix.

Regards,

V Srinivasan

[Sriram2009]

Hi Katta

1.  Could check the user id privileges? are you logon to MS Sql MMC using local administrator or SIDADM user id?

2. User id DO1 as part of local administrator group to access the MS Sql server?

3. Could you refer the SAP note 1794178 - Network issues suspected on SQL Server systems

BR

SS

[srinivasan_vinayagam]

Chandra,

Check your password is correct or not.

Try to login both like Window authentication and specific account.

Regards,

V Srinivasan

[chandrababu_katta]

Srinivas,

    Thanks for the update and i tried with both modes and we are using correct pwd and unames.

The problem is occuring after few hours the instance ran successfully and any one tried debugging.

Regards,

Chandrababu

[srinivasan_vinayagam]

Hi Chandra,

Hot Fix available. you can apply if required.

FIX: Time-out error when a mirrored database connection is created by the .NET Framework data provid...

http://blogs.msdn.com/b/spike/archive/2008/07/31/timeout-expired-the-timeout-period-elapsed-prior-to...

Regards,

V Srinivasan