[Microsoft][SQL Server Native Client 11.0]Shared Memory Provider: Timeout error [258]

Question

Good day.

I have website on php5.

All query perform with sqlsrv;

When i make query i get error:

[Microsoft][SQL Server Native Client 11.0]Shared Memory Provider: Timeout error [258]

How to fix error?

Answer 1

• This error is probably caused by a very slow connection or SQL query taking a long time.
• It is not an SQL Server problem.

• Try extending the timeout value in your connectionString in PHP.

  See this previous answer

You need to change some setting in your php.ini : upload_max_filesize = 2M ;or whatever size you want

max_execution_time = 60 ; also, higher if you must

Were your PHP.ini is depends on your enviroment

Answer 2

Setting max_execution_time to 0 (unlimited) alone, did not do it for me.

However, increasing the memory limit default from 128MB to 2GB worked:

max_execution_time = 0
memory_limit = 2048M

Answer 3

PHP 5.3.19 to Sql Server 2008 all queries timed out including 'select getdate()' Changing the two params max_execution_time to 0 and memory_limit = 1024M did it for me.