Cant connect to MSSQL 05 Database

Gallery version (not just "2"): Gallery 2.2
PHP version (e.g. 5.1.6): 5.1.3
PHPInfo Link (see FAQ):
Webserver (e.g. Apache 1.3.33): IIS 6
Database (e.g. MySql 5.0.32): MS SQL 2005
Activated toolkits (e.g. NetPbm, GD):
Operating system (e.g. Linux): Windows Server 2003
Browser (e.g. Firefox 2.0): Internet Explorer 7

I am having trouble connectiing to my database. I have IIS running on a server called Hercules and the SQL server is called CHAOS. Under the hostname under step 5 do I just put CHAOS or does something else have to be added? Here is the error:

Host=PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=CHAOS;DATABASE=gallery2;UID=eric;PWD=card12
version=2.8
PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=CHAOS;DATABASE=gallery2: No connection established