FreeTDS: Could not connect to server

[ashamshi]

Hi All!
My question is addressed for those familiar with FreeTDS and its usage with SugarCRM (Windows XP).
I've installed sugarcrm-5.0.0f with bundled SQL Server 2005 Express Edition, PHP 5.2, Apache 2.0.59 on a Windows XP box. I'm trying to configure FreeTDS driver as described in Sugar Community Edition Installation and Administration
Guide. I've done this:
1. Downloaded sugarcrm-MB-mssql.zip
2. Unpacked msvcr71.dll and ntdwblib.dll to windows/system32, apache2/bin directories
3. Copied freetds.conf to c:\ directory.
4. Edited c:\freetds.conf so it looks like this:

[global]
tds version = 7.0
initial block size = 512
swap broken dates = no
swap broken money = no

[host_name]
host = localhost,1433
instance = BITROCKMSSQL
port = 1433
client_charset = UTF-8
tds version = 7.0
dump file = c:\FreeTDS.log
debug flags = 0x4fff

5. Unpacked freedts\Drivers\5.2.x\php_dblib.dll from sugarcrm-MB-mssql.zip to php\ext directory
6. Launched php -f upgrade_mssql.php from command line, it worked ok (dropped and recreated tables)
7. Edited php.ini so it looks like this (excerpt)

....
;extension=php_mssql.dll
extension=php_dblib.dll
....
; Specify client character set.
; If empty or not set the client charset from freetds.comf is used
; This is only used when compiled with FreeTDS
mssql.charset = "utf-8"
...
8. Started Apache
9. When I try to open http://127.0.0.1/sugarcrm/index.php, I get message "Could not connect to server MYHOSTNAME as sa."

So, when I make this changes to php.ini:
....
extension=php_mssql.dll
; extension=php_dblib.dll
....

SugarCRM loads ok, but, I guess, FreeTDS doesn't work this time.

Tried also to make changes to c:\freetds.conf:
...
host = localhost
...
but that didin't help.

What have | done wrong?

[ashamshi]

I turned php error logging on, and what does it say about the error:

"[09-Jul-2008 17:22:30] PHP Warning: mssql_connect() [<a href='function.mssql-connect'>function.mssql-connect</a>]: Unable to connect to server: MYHOSTNAME\BITROCKMSSQL in C:\sugarcrm-5.0.0f\htdocs\sugarcrm\include\database\MssqlManag er.php on line 137

[09-Jul-2008 17:22:30] PHP Warning: mssql_close(): supplied argument is not a valid MS SQL-Link resource in C:\sugarcrm-5.0.0f\htdocs\sugarcrm\include\database\MssqlManag er.php on line 102"

Any ideas?

[ashamshi]

It seems like i resolved this problem.

This lines in php.ini helped:

...
; FreeTDS defaults to 4096
mssql.max_procs = 4096
...

[vdhyani]

Good job ashamshi

Right that in php.ini as the default mssql.max_proc is set to -1

; Specify max number of processes. -1 = library default
; msdlib defaults to 25
; FreeTDS defaults to 4096
;mssql.max_procs = -1

You figured out correctly by setting mssql.max_proc to 4096.

[erop]

This sounds rather strange but even after setting mssql.max_procs = 4096 I still have the same "Could not connect to server EGOR as sa" issue.

P.S. FastStack for Windows with MS SQL server, SugarCE 5.2.0c

[erop]

Another strange thing is that andopes here told me FreeTDS is only for Sugar-on-Linux + MS SQL Server combination. How do you managed to properly enable FreeTDS driver (and what is the most interesting, why?) into WAMP environment as FastStack bundle gives? Idid exactly the same as ashamshi and had no positive results.

[sumanpasupula]

Can anybody tell the DB Driver used in sugarcrm? for all the DB options i.e. mysql, mssql, oracle....