The reason this happens is that the the SQL server has been configured to operate in "Windows Authentication Mode (Windows Authentication)" and doesn't allow the use of SQL accounts. This can be resolved easily enough, by changing the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)" to "Mixed Mode (Windows Authentication and SQL Server Authentication)". The exact way to do this, will wary with your SQL installation, but it should nevertheless be relatively easy.
Have more questions? Submit a request