Results 1 to 2 of 2

Thread: Cannot connect to database during install

  1. #1
    Hilltop is offline Junior Member
    Join Date
    Nov 2008
    Posts
    1

    Default Cannot connect to database during install

    Attempting to install SugarCRM CE 5.1.0b onto a Windows Server 2003 platform using IIS and SQL 2005. However, I am unable to get past the Database verification step. I get the following error messages:

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

    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\MSSQLSERVER

    I have referenced the "Installing Sugar with SQL Server" document without success. Any ideas would be welcomed.

    PHP 5.2.6
    Sugarm CE 5.1.0b
    SQL 2005 w/SP2
    Server 2003 Standard w/SP2
    IIS 6.0

  2. #2
    allenl is offline Sugar Community Member
    Join Date
    Sep 2007
    Posts
    44

    Default Re: Cannot connect to database during install

    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


    http://www.sugarcrm.com/wiki/index.p...ith_SQL_Server

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. connect sugarcrm to another database
    By shahrzad.khorrami in forum Developer Help
    Replies: 3
    Last Post: 2008-06-23, 07:39 AM
  2. step 3 installation problem
    By voitek in forum Installation and Upgrade Help
    Replies: 10
    Last Post: 2007-02-14, 04:35 PM
  3. Replies: 11
    Last Post: 2006-12-20, 09:46 PM
  4. Replies: 0
    Last Post: 2006-07-17, 04:11 PM
  5. Sugar 401 install and remote MySQL database
    By cosjef in forum General Discussion
    Replies: 5
    Last Post: 2006-03-09, 08:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •