Ok, after slaving over this blogging engine that I have been creating for the past week, it has now come to my attention that MS SQL Server DB wont accept a Sql data provider. You have to use OleDb data provider which sucks since its a SQL Server DB.

You would think that they would support the data provider that is optimized for SQL Server. So after I uploaded my project, it started puking. Now I have to go and redo the whole project since I just messed it up when I tried to do a mass find and replace.