How to get 10.0.2 to work on Windows with ISS and SQL Server

I have installed 10.0.2 on Windows with a SQL Server back end. When I went through the install I got to the last screen which shows:

Creating Sugar configuration file (config.php)

Begin rebuilding web.config

Rebuilding UTF-8 document

Rebuilding configuration element

Rebuilding system.webServer element

Rebuilding rewrite element

Rebuilding caching element

Rebuilding staticContent element

web.config is rebuilt

Creating Sugar application tables, audit tables and relationship metadata
Creating the database sugarcrm on 172.20.6.5...done
.......................................................................................................................................................

Creating default Sugar data

     Updating license information...   done
     Creating default users...   done
     Creating default reports...   done
     Creating default scheduler jobs...   done

Populating the database tables with demo data (this may take a little while)

.................................................................................................................................................

The setup of Sugar 10.0.2 is now complete!
Total time: 143.10731101036 seconds.
Approximate memory used: 120144888 bytes.

So that appears to have work however when I try to connect to the logon page in IE 11 I get "Loading ....." and in ie I get an internal server error 500 when looking for page :-

172.20.6.5/.../public

I checked my sugracrm2 folder for a rest folder which does not exist. Should this have been created as part of the installation or have I missed a step ?

Thanks,

Richard

  • For more information my setup was

    SugarCRM
    Confirm Settings     SugarCRM
    Database Configuration
        Database Type     mssql
        Host Name     172.20.6.5
        Database Name     sugarcrm (will be created)
        Database Administrator Username     sa
        Populate Database with Demo Data?     Yes
        Drop Tables     No
    System Credentials
        Sugar Database Username     sa
        Sugar Database User Password     *****
        Sugar Application Admin Name     Admin
        Sugar Admin User Password     *****
    System Environment
        PHP Version     7.3.13
        XML Parsing     OK
        MB Strings Module     OK
        Writable SugarCRM Configuration File (config.php)     OK
        Writeable Custom Directory     OK
        Writable Modules Sub-Directories and Files     OK
        Writable Upload Directory     OK        
        Writable Data Sub-Directories     OK
        Writable Cache Sub-Directories     OK
        PHP Memory Limit     OK (512M)
        ZLIB Compression Module     OK
        ZIP Handling Module     OK
        IMAP Module     OK
        cURL Module     OK
        Upload File Size     OK
        Sprite Support     OK
        PHP allows to use stream (upload://)     OK
        Location of your PHP configuration file (php.ini):     C:\Program Files\PHP\v7.3\php.ini

  • The REST redirection is configured for Apache in .htaccess. For IIS there must be something similar in web.config. Please check this https://support.sugarcrm.com/Documentation/Sugar_Versions/10.0/Ent/Installation_and_Upgrade_Guide/#IIS_Server_Installation_Requirements for other requirements. I suppose the PUT and DELETE verbs must be enabled.

    Try to open the page in Chrome or Edge to see the console output.

    Harald Kuske
    Principal Solution Architect – Professional Services, EMEA
    hkuske@sugarcrm.com
    SugarCRM Deutschland GmbH

  • I had the URL Redirect 2.1 install but when I downgraded fom PHP 7.4 to 7.3 I had fogotten to remove the 7.4 Handler mappings and I had not added PUT and DELETE to the 7.3 handler. - Thanks - that has me working.