Seems like your SQL Server is configured to use Windows Authentication and you're trying to use SQL Server authentication. Configure SQL server to accept both Windows and SQL Server authentication.
ruirib you are a godsend i was using mysql with my forums but seeing how i am running windows server 2003 and can not do database clustering so i switched to ms sql and this post helped alot.