Sugar CRM Community edition install on IIS7, Windows 2008 and Remote SQL Server 2008

[majdi.d]

Hi,
First post here, sugar install is driving me crazy. After spending a couple of hours fixing some file access rights issues, it is now passing the validation step and i am stuck on the Database Configuration.

The server i am installing the CRM on is let's say 192.168.1.1, and the database server is 192.168.1.2, both have proper fully qualified domain names (windows domains, like server1.company.local and server2.company.local)
i followed the steps described in this article http://www.sugarcrm.com/forums/f115/...008-etc-59701/ after failing to install it using the SQL Server stack.

Our SQL server is 2008 R2 Standard Edition. IIS7, PHP 5.3 and SugarCE 6.4.2
The error message i am getting everytime is "The provided database host, username, and/or password is invalid, and a connection to the database could not be established. Please enter a valid host, username and password
* Required field"
I tried everything, the IP, the server FQDN, leaving the instance empty, switching to another instance of SQLSERVER EXPRESS.... nothing works.
Note that running the following script works and shows results, so i don't think that the SQL Server 2008 client is not installed properly.

Installed PHP Extensions:
php_curl
php_mbstring
php_pdo_sqlsrvr
php_pdo_sqlsrvr_53_nts
php_pdo_sqlsrvr_53_ts
php_soap
php_sqlsrvr
php_sqlsrvr_53_nts
php_sqlsrvr_53_ts
php_tidy
php_wincache

<?php
   $serverName = "192.168.10.2"; 
   $database = "sugarcrm_db";

   // Get UID and PWD from application-specific files. 
   $uid = someusername;
   $pwd = somepassword;

   try {
      $conn = new PDO( "sqlsrv:server=$serverName;Database = $database", $uid, $pwd); 
      $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ); 
   }

   catch( PDOException $e ) {
      die( "Error connecting to SQL Server" ); 
   }

   echo "Connected to SQL Server\n";

   $query = 'select * from contacts'; 
   $stmt = $conn->query( $query ); 
   while ( $row = $stmt->fetch( PDO::FETCH_ASSOC ) ){ 
      print_r( $row ); 
   }

   // Free statement and connection resources. 
   $stmt = null; 
   $conn = null; 
?>

[Angel]

This combination can be a bit finicky at times, but the good news is that you appear to have all the right pieces on your system. Some minor adjustments should help get you going.

Sugar will use the MS provided MS-SQL driver for PHP (php_sqlsvr). Given that you are using IIS, you need to use the non-thread safe one (nts). Your message indicates both are installed, you only need one. Remove the thread safe one and confirm that it is being loaded via phpinfo().

Feel free to disable the PDO one while you are at it as Sugar won't use it (unless you need it for other purposes). Chances are that this change alone will kickstart it for you. If you still have problems, post the output of phpinfo() for us to inspect.

[majdi.d]

This combination can be a bit finicky at times, but the good news is that you appear to have all the right pieces on your system. Some minor adjustments should help get you going.

Sugar will use the MS provided MS-SQL driver for PHP (php_sqlsvr). Given that you are using IIS, you need to use the non-thread safe one (nts). Your message indicates both are installed, you only need one. Remove the thread safe one and confirm that it is being loaded via phpinfo().

Feel free to disable the PDO one while you are at it as Sugar won't use it (unless you need it for other purposes). Chances are that this change alone will kickstart it for you. If you still have problems, post the output of phpinfo() for us to inspect.

just disabling unused dll's made it work. thanks a lot.