Sugar can connect with Sql Server

[jasv]

Hi...

I'm throught a big, big problem....

I'm using SugarCRM 5.1.0.a
MSSQL 2005
Windows Server 2008
Apache/2.2.9
PHP/5.2.6

i´ve detected that sometimes (Very frecuently really)... a message appears: Unable to select database.
Later this message turn into something even worst. it appears

 Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server... 
  

If i refresh the page... it seems get fixed.

I've been searching a lot of info about this.
I read that i must copy the file ntwdblib.dll (version 2000.80.194.0) into system32, php and apache/bin folders... so did i...

Checking out the config.php file I pay attention on persistent option (set as true as default)...

I set it to false... and oh god... now sugar is not working at all... it shows me:

 Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server... 
  

i must set persistent as true so i can make it work. But sometimes it appear again and i must refresh the page.

Please help me (or us, ´cause i know there's a lot of people running throught this out)...

Cheers.

[Paquet]

Was this ever solved? I am also running into the same issue.

[kbrill]

Did you check your MSSQL server logs for errors?