For SQL2008,
- open Management Studio
- Rt click on instance
- go to properties
- select Security
- Under Server Authentication, check SQL Server and Windows Authentication Mode
- hit OK
Restart the server using configuration manager.
For SQL2008,
Restart the server using configuration manager.