Cannot connect to database error

We have a new application, running on Windows Server 2003, SQL Server
2000-SP3, application in PHP. We sporadically get the message cannot connect
to database'. Sometimes it seems to go away when we restart the database,
but that is not a sure thing to fix it. Am wondering if sp3a will be the
magic bullet? Or is there something else that I should be looking at?
Thank you for your assistance.
Sue
The difference between SP3 and SP3a is in the setup so applying it won't
make any difference.
Check the SQL Server errorlog (exec master..xp_readerrorlog) and check for
any messages in there, my thinking is may be you are running out of
concurrent connections due licence restriction.
Also, when the problem happens, run sp_who2 to check for blocking.
Tony.
Tony Rogerson
SQL Server MVP
http://www.sqlserverfaq.com?mbr=21
(Create your own groups, Forum, FAQ's and a ton more)
|||Do you have any specific error msg? (DBNETLIB Error?)
Sasan Saidi, MSc in cs
Senior DBA
Brascan Business Services
"I saw it work in a cartoon once so I am pretty sure I can do it."
"Sue" wrote:

> We have a new application, running on Windows Server 2003, SQL Server
> 2000-SP3, application in PHP. We sporadically get the message cannot connect
> to database'. Sometimes it seems to go away when we restart the database,
> but that is not a sure thing to fix it. Am wondering if sp3a will be the
> magic bullet? Or is there something else that I should be looking at?
> Thank you for your assistance.
> Sue