SQL Server 2008 and CI

[eluser]Dan Bowling[/eluser]
CI works fine with SQL server (2005 and 2008 in my experience). Does your SQL server error log show an error for the user? If it does, you'll have you answer in that error text. If not, then maybe check the following:

* Is SQL Server set up as a firewall exception
* Can you log in with that username/password remotely with the Management Studio?
* Are you sure you're using the MSSQL database driver?