Page 1 of 1
Installation of 1.1.1 on MS SQL 2005
Posted: 16 Apr 2008, 14:50
by 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
Re: Installation of 1.1.1 on MS SQL 2005
Posted: 18 Apr 2008, 18:50
by dialexia
I run into the same problem when testing mantis on my virtual pc....LOL
Re: Installation of 1.1.1 on MS SQL 2005
Posted: 02 May 2008, 16:37
by 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.
Re: Installation of 1.1.1 on MS SQL 2005
Posted: 19 Jun 2008, 13:56
by 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.
Re: Installation of 1.1.1 on MS SQL 2005
Posted: 24 Jun 2008, 15:11
by blueray2048
Besides that, if anyone use apache the php.ini file could also be specify by use an apache directive
Re: Installation of 1.1.1 on MS SQL 2005
Posted: 24 Jun 2008, 17:38
by dialexia
Everyone has provided solutions, but not to the original question. The question was how to intall mantis on MSSQL!
Re: Installation of 1.1.1 on MS SQL 2005
Posted: 24 Jun 2008, 18:02
by 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,
Re: Installation of 1.1.1 on MS SQL 2005
Posted: 25 Jun 2008, 13:41
by 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