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
