Local SQL Server 2012 (express) ColdFusion 10 Datasource will not connect?

Hello

There are several methods to do this out there, not one has worked for me. First, configuring SQL Server by

enabling TCIP connections

Setting IP1 & IP2 Address to 127.0.0.1

setting all TCP Ports to 1433 (IP1 through IP7)

Leave all TCP Dynamic Ports blank

enable Named Pipes

restart SQL Server

Then in Studio:

Security tab under the DB you want to connect to

create a new user

give user a user name and login name

default Schema- dbo

Then in CF Admin:

Server: 127.0.0.1

Port: 1433

User Name: login name from above

Connection verification failed for data source: appraiseriLOCAL

java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'Nu-PC\Nu'.

The root cause was that: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'Nu-PC\Nu'.

Any help with this will prevent more hair-pulling.

Thanks