Sorry for my bad English. I've walked around to find the answer of my problem, but I still can't get it.
I develop PHP 5.2.5 Application, using SQL Server 2005 database, and run in IIS 6.0.
I also use PHP SQL Server 2005 driver provides by microsoft.
My database is placed in another server.
My application is used by almost 30-40 users at the same time.
If the application is used by few users, the application works smoothly.
But, if the application is used by a lot of users (around 30), it suddenly down and show this error..
Expand|Select|Wrap|Line Numbers
- Array ( [0] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => 2 [code] => 2 [2] => [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2]. [message] => [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2]. ) [1] => Array ( [0] => HYT00 [SQLSTATE] => HYT00 [1] => 0 [code] => 0 [2] => [Microsoft][SQL Native Client]Login timeout expired [message] => [Microsoft][SQL Native Client]Login timeout expired ) [2] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => 2 [code] => 2 [2] => [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. [message] => [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ) )
If this happen, I restart the IIS and it backs to normal.
I guess there is something wrong with the max connection that SQL Server 2005 can accept. I assume that because I use the transaction..
Expand|Select|Wrap|Line Numbers
- //start transaction
- ---> process
- //end transaction
I don;t know how to checked whether the database has reach max connection. I've checked the max connection that's allowed and it use default value (unlimited).
The problem makes me headache. The application has lived and I must solved this problem quickly..
Could anyone help me? Thanks before...