On the installer page after clicking on Finish I get this error "Unable to connect to the database, please check the settings below"

My database settings are the following:
Database Type: Microsoft SQL Server
Database Name: Helpspot
Database User: Myuser
Database Password: mypass
Database Host: "Sqlserver1"

the database is created in visible in Enterprise Manager
Any Ideas?

Hi Matt,

I think the problem may be with the host name. PHP expects it to be either an IP or a hostname resolvable to an IP (db.mydomain.com). Also if you're using a non standard port you must specify that with a comma. So "db.mydomain.com,755".

Let me know if that works.

drop the http:// part, that's not supposed to be there

Hi Ian,
I tried Sqlserver1.mydomain.net, and this did not work I got the same error. Just to make sure I checked my php.ini and extensions mssql, imapi, and graph are properly listed without the ";" Also I have Yes for the following
Configuration path writable:
Yes
PHP version higher than 4.3:
Yes
PHP IMAP extension installed:
Yes
PHP XML extension installed:
Yes
PHP GD extension installed:
Yes

I also tried Sqlserver1.mydomain.net without the http://

What version of Windows are you on?

Windows XP SP2 iis verison is 5.1

It could be that you're missing some of the proper files. Some quick research indicates that on Win2K you need to move ntwdblib.dll into the PHP extension directory. This file is apparently located in with the Enterprise Manager dll's. This may also be the case with XP.

The PHP maual for the MSSQL library has notes on this as well as user provided notes farther down which may be helpful in getting it installed.

http://us2.php.net/mssql

You must have read my mind. I just did that copied ntwdblib.dll from the sqlserver to the local install and this did the trick.
Thanks

Excellent! Another installation issue I now know the answer for. Thanks for posting it up here for others to learn from.