SQL Server must be set to mixed authentication 

-Open The SQL Server Enterprise Manager 

-Start menu > Programs > Microsoft SQL Server > Enterprise Manager) 

-Expand the tree-control until you can your server 

-Right click on the server name and "SQL Server Properties (Configure)" window will open 

-Select the Security tab 

-For "Authentication", select "SQL Server and Windows"