Installation of 1.1.1 on MS SQL 2005

[sheel331]

Hello, I am attempting to install Mantis 1.1.1 on my IIS 6/SQL Server 2005 database server, and am having some issues. Once I click on the 'install database' button, I get the following PHP error:

PHP Fatal error: Call to undefined function mssql_get_last_message() in C:\Inetpub\webroot\mantis-1.1.1\mantis\core\adodb\drivers\adodb-mssql.inc.php on line 492

And all of the checks are valid, except for the "Checking PHP support for database type" which throws this error:

BAD
database is not supported by PHP. Check that it has been compiled into your server.

Does anyone know why this is happening? I searched around in my php.ini file and found nothing that helps.

I would greatly appreciate any help, as I don't know much about PHP or SQL server, and my internal resources are pretty limited.

Thanks,
Sheel Shah

[dialexia]

I run into the same problem when testing mantis on my virtual pc....LOL

[cshouts]

I am experiencing the exact same problem while installing Mantis 1.1.1 on Windows Server 2003 SP2 using PHP 5.2.6 zip package, php5isapi.dll, and Microsoft SQL Server 2005. If anyone solves this problem, please let us know!

Update: Resolved the problem by copying php.ini to C:\WINDOWS and adding the installation directory for PHP (in my case, C:\PHP) to the PATH environment variable.

[vzw614]

You shouldn't need to copy php.ini to your windows directory. Just add the path to php (C:\PHP;) to the beginning of your path.

[blueray2048]

Besides that, if anyone use apache the php.ini file could also be specify by use an apache directive

Code: Select all

PHPIniDir "c:/php/" 
  

[dialexia]

Everyone has provided solutions, but not to the original question. The question was how to intall mantis on MSSQL!

[blueray2048]

The error message stated that php_mssql.dll was not load on IIS.

Please check the php.ini file to see if there have a line like extension=php_mssql.dll.
When loading this extension, one issue is that the default library ntwdblib.dll was too old.

Google the web and download a version it's version number said 2000.80.194.0
and follow the steps in here to create login and user account to make mssql function works in php.

It's still not so well written, but should enough to configure php to work with mssql server.



Regards,
Eric,

[vzw614]

I followed this walkthru to install a fresh version of php on a server running Windows Server 2003, SQL Server 2005 and IIS. It worked like a charm. As someone above said after you have php installed and do an inital verification that it works then be sure you enable the MS SQL Server extension in php.ini.

http://www.peterguy.com/php/install_IIS ... SConfigure