ColdFusion is not connecting datasource with SQL Server 2014
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
Some details on SQL Server mixed authentication. To enable do, the following:
- Connect to DB server (presumably via Windows Authentication
- Right click for properties on the server icon
- On the properties dialog go to Security
- Select "SQL Server and Windows Authentication mode". Save.
- Searching for strings with double quotes in SQL Server
- Check if table exists in SQL Server
- The database 'xxx' cannot be opened because it is version 904
- Insert Update trigger how to determine if insert or update
- SQL query to determine whether it is day or evening
- Invalid value specified for connection string attribute
- Reset identity seed after deleting records in SQL Server
- Call a stored procedure with parameter in c#
- Join 3 tables without table 2 and 3 overlapping
- How to run SQL Server Agent Powershell script with output and exit code
- Refer to original value within CASE statement
- alternative to xp_cmdshell bcp?
- Querying data from SQL Server table with Powershell
- How to export data as CSV format from SQL Server using sqlcmd?
- ExecuteScalar() not returning full contents of cell
- SQL Query to select certain number of records with WHERE clause
- How to select 10 rows for a each column value in the 'IN' statement (T-SQL)
- How to execute a .sql file using PowerShell
- "The certificate chain was issued by an authority that is not trusted" when connecting DB in VM Role from Azure website
- Invoke-Sqlcmd doesn't allow TrustServerCertificate
- Can you insert into a replicated SQL Server DB?
- How to set up a Windows Docker Container with SQL Server?
- Remove trailing spaces from fixed length in output file generated by sqlcmd
- How to suppress hyphens in SQLCMD
- Error when adding replication logreader agent with login
- Differences Between Drivers for ODBC Drivers
- Calculate value based on sum of previous calculated values
- Get all the table names that are available in all the <s>schemas</s> databases in SQL Server
- Detect character encoding of file in SQL Server
- What performs better: Bunch of UNION queries vs separate queries?