Can not connect to database

[rus]

Hi,

I use the SugarCRM CE Version 5.2b with MSSQL 2005 on Windows Server 2003.
The problem is I often get this error message when I open my application at http://xxx.xxx.xxx.xxx :
"Could not connect to server xxx.xxx.xxx.xxx, 1433 as user."

Right now the only solution I have is to restart the apache and it will be fine again.

Any suggestion will be appreciated.

[letrium]

Hi!

Have you created "user" in MSSQL?
Have you set access to db for this "user"?

[rus]

yup, actually "user" is the db admin.
the thing is, this error is not always show all the time.
sometimes it would take a week without this error, but sometime it show everyday.

[letrium]

It's very strange!

[rus]

even more weird today, I've got this error message,
I open the SQL Profiler on the server to investigate this problem,
and suddenly it worked fine.. hhhmmm...

the other thing is when I query with "sp_who" on the server, there are a lot of connection to my sugarcrm database. It seems sugarCRM(or the PHP) is not closing the connection after the logout. Is there any solutions for this ?

[rus]

I just know there is dbconfigoption - "persistent" option in config.php, if I set this "persistent" option to "false" (default is "true), the db connection will be close as soon as the query ended.
But I don't know would this affecting the sugarcrm performance.
Is there anyone can explain this ?

[roblaus]

We had exactlly the same problem with a customer recently but it was a MSSQL 2005. Since other php applications showed similar errors we tend to believe that this isn't Sugar's fault but a misconfiguration in mssql or apache (it never happened with sqlexpress and the stack installer - coincidence?).

About persistent connections - you need to test it, I am just checking what we do as standard

[rus]

thanks for the information Rob ..
I tested in my development environment with the "persistent" option set to false is better, I never get the error message so far.
previously it showed the error when there are about 25 connection to the database.

[roblaus]

Thx for the feedback, I just checked an we swich persistent connections off as per default. But this is Mysql.

I am sure there is a parameter somewhere (in mssql) how many connections can be kept open and for how long they live if idle.

[jasv]

Hi...

I'm having the same problem... but if i set persistent as false... sugar does not work at all...

i´ve created a new thread with my issue details...: http://www.sugarcrm.com/forums/showt...179#post148179

Anyone can help up us to get this out?
please sugar heros... this is really important...

Thanks in advance... Cheers.