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

[Guest]

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

[Tomas_Sancio]

I had the same problem connecting to SQL Server Express 2008 in an Amazon EC2 instance but I followed the instructions step-by-step in the following link and was able to connect with CF.

http://www.linglom.com/it-support/enable-remote-connection-on-sql-server-2008-express/