SugarCRM in VMWare

[consultsales]

I am need of assistance. I just installed a VMWare server running windows 2003 standard and also downloaded SugarCRM 5.0 When I run the installer for SugarCRM, I receive the error:

The provided database administrator username and/or password is invalid, and a connection to the database could not be established. Please enter a valid user name and password.localhost\SQLEXPRESS

This local copy of SQL is not the only database I tried connecting to. We have another box with SugarCRM running and connects to the main database server fine. I have tried that connection string and still get the same type of error.

I can create via ODBC/DSN and use the MS SQL Management Studio to connect to our main database and the local copy. But it is just trying to connect to it via the SugarCRM installer where I cannot make the connection. PHP is configured properly as I was able to grab the php.ini file and use it on the other crm copy.

Any help on this would be appreciated. thank you

[Angel]

It wasn't clear from your message, but it sounds like you are saying that you are able to connect to the SQL server from any location, except from within the VMWare session.

Assuming that's correct, it sounds like it might be an issue relating to the manner in which the networking has been configured for the virtual machine.

Are you able to see any of the Windows shares from the host machine while working within the VMWare session?

[consultsales]

I am able to connect through DSN/ODBC and the sql management studio within the VMWare.

Yes I can see the shares. The VMWare server created is part of the domain too.

[Angel]

A couple of things...

Try using "." instead of localhost when referencing the name of the instance. I've seen bizarre things with MSSQL and other software where using "localhost\SQLExpress" doesn't work, but ".\SQLExpress" does. The period is just shorthand for localhost.

Another question...have you confirmed that SQL Authentication is enabled on the SQL server and not just Windows authentication?

[consultsales]

I will go into more detail to help you help me :-)

I have tried localhost\SQLEXPRESS
I have tried <machinename>\SQLEXPRESS
I have tried <maindbname>\<instance>
I have tried <maindbname>\
and just tried the .\SQLEXPRESS

I have also tried different logins: sa, local admin, domain admin and none work.

Both SQL & Windows authentication are turned on for both databases. In theory, I should be able to grab the PHP & Sugar folders of our current CRM box and put them into the Virtual box. I have done that with a different physical box and it has worked.

I am unsure if it is something more that has to be enabled in PHP or Sugar in order for it to detect the databases or if its VMWare issue ie maybe blocking that type of connection from happening? I do not know.

Thank you for your help again.

[Angel]

I suppose one additional troubleshooting step would be to ensure that your current PHP configuration has MSSQL enabled.

Create a file named test.php or the like and add the following to it..

<?php

phpinfo();

?>

Put the test.php file in your htdocs folder and then pull it up with your browser and check the PHP config.

[consultsales]

Yeah it is all on :-)

mssql
MSSQL Support enabled
Active Persistent Links 0
Active Links 0
Library version 7.0

Directive Local Value Master Value
mssql.allow_persistent On On
mssql.batchsize 0 0
mssql.compatability_mode Off Off
mssql.connect_timeout 5 5
mssql.datetimeconvert On On
mssql.max_links Unlimited Unlimited
mssql.max_persistent Unlimited Unlimited
mssql.max_procs Unlimited Unlimited
mssql.min_error_severity 10 10
mssql.min_message_severity 10 10
mssql.secure_connection Off Off
mssql.textlimit Server default Server default
mssql.textsize Server default Server default
mssql.timeout 60 60

[allenl]

1. test whether the mssql_connect() is work or not by writing a php file like
<?
$sqlconnect = mssql_connect('192.168.128.128\SQLEXPRESS,1433', 'sa', lala);

$sqldb=mssql_select_db("ProcessTestDB",$sqlconnect );
$sqlquery="SELECT * FROM Table_Names;";
$results= mssql_query($sqlquery);
while ($row=mssql_fetch_array($results)){
echo $row['id'].' - '.$row['name']."<br>\n";
}
mssql_close($sqlconnect);

2. if mssql_connect is not ok, then

copy ntwdblib.dll from php to apache\bin
copy php_mssql.dll from php\ext to apache\bin

3. Replace SQLEXPRESS with SQLEXPRESS,1433 during installation