ColdFusion is not connecting datasource with SQL Server 2014

Question

I am trying to connect datasource in coldfusion admin with my local sql server 2014 but it is not connecting . I have tried every method to do this but no success. I have also created new user but it is also not working. I am getting this error

Connection verification failed for data source: mlc_new java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'tester'. The root cause was that: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'tester'.

the datasource details are

datasource name: mlc_new db name: mlc_new sever: DEV-PC\SQLEXPRESS username: tester password : somestring

Answer 1

Some details on SQL Server mixed authentication. To enable do, the following:

1. Connect to DB server (presumably via Windows Authentication
2. Right click for properties on the server icon
3. On the properties dialog go to Security
4. Select "SQL Server and Windows Authentication mode". Save.