CF admin DB Connection to Local SQL Express Fails

[seasonedweb]

My connection to the local SQL Express fails.

Connection verification failed for data source: alllogins
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Kerberos Authentication is not supported by this SQLServer. The driver attempted Kerberos authentication because the AuthenticationMethod connect option was "auto" and no username/password was specified.

It is registered in SSMS and a system DSN in ODBC Data Source Admin.

It should connect using windows autth? Any Help much appreciated. See images.

[Dave Watts · Accepted solution]

CF can connect via Windows authentication in theory, but I'd strongly recommend you just use SQL Server authentication instead unless you really, really care about security, which in this case doesn't sound that important.

Dave Watts, Eidolon LLC

[seasonedweb]

Dave appreciate your response, and I though it would be a simple matter to change the auth to SQL vs windows but can'y get past this step- see image.

[Dave Watts]

This might sound dumb, but have you stopped and restarted the SQL Server service? Apparently that may be needed too. It seems like I spend half my time just stopping and restarting things.

Dave Watts, Eidolon LLC

[Dave Watts]

Also, whenever there's a "Show details" option it can't hurt to see what's in there.

Dave Watts, Eidolon LLC

[seasonedweb]

David:

Thanks for your help with several of my SQL/CF issues.

Still does not connect after restart. I’m forgetting more than I ever knew now…

But the nature of this message is help in finding someone to take over the reins for a client with whom I have had a long & steady relationship with for at least 10 years.

A little history. I started web dev as a new career at age 48 (1998), having just received an MS degree in “Internet Strategy Management" from a college in Vermont.

I was introduced to Allaire Cold Fusion (2 words at the time) and took off from there.

I was the first “Webmaster” at a news service, a College, and then the City of Newport, RI from where I retired.

I always had my own business on the side & at the height I had 30 clients or more which became a little overwhelming as I had the full-time job & was teaching web design & web dev using CF at 2 colleges, and troubleshooting CF server issues for several clients.

All easy stuff- just barely scratched the surface with CF -students built simple Access DBs & browser-enabled query results- they were fascinated.

I got rid of 20 customers a while back– some were high-profile in the Newport, RI area.

Also built e-learning modules with video, built CF-based testing apps- worked a while for Pfizer as a contractor for their internal websites, including the Viagra Team ;>)

At Newport- all the departments were using Excel spreadsheets- residents’ names/addresses 12 times, no fire dept. alarm db etc.etc. I built their entire internal RDMS with SQL Server/CF. Also a vendor /contactor bidding system that was eventually used by 9 other cities & towns, inc. Providence.

So for this customer, a major appraisal service in RI, I built their internal systems from entry of a new appraisal to invoicing.

I feel now is the time for someone to take over- I am 71 - I really hate to give it up but if I get hit by a turnip truck, he would need to advertise for another CF developer (not many around here) of transition to PHP :>(

The public front end is circa 15 years ago but he insists he’s happy with it (!) so I don’t argue.

If you can help with this I would be grateful. I charge him a $50/hour which I guess by today’s standards is paltry.  Thanks! Norman Breton

[Priyank Shrivastava. · Accepted solution]

Hi,

Please enable SQL Authentication and create a username and password. 

[seasonedweb]

Priyank- appreciate your response, and I though it would be a simple matter to change the auth to SQL vs windows but can'y get past this step- see image.

[Charlie Arehart]

I realize this is from a couple of months ago, but besides the ideas offered here, I'll share for the sake of fugure readers who may find this...

The issue is that the progress/datadirect JDBC driver which CF implements had a change in behavior (in the version of the driver which took effect in CF2021), and now "ntlm" is no longer one of the "auto" options for authentication.

But good news: you can get this password-less ("trusted") connection working by implementing a connectionstring (in the CF Admin DSN "advanced settings") with a value of: 

AuthenticationMethod=ntlm

[JamesMoll777]

Charlie I just want to say how grateful I am for you haha!  I've been doing CF dev off/on since 1999, and here it is 2022, and your answers are still saving me lots of headpounding time lol!  Just installing 2021 for the first time and porting over a dev productivity app we use that's been running on cf2018.  Thanks sooooo much for this tip!  

[Charlie Arehart]

Thanks, so much, James. I love helping, and all the more when folks appreciate it; sadly, not everyone does, which makes a note like this all the sweeter. 🙂 

[victor383754771]

Thanks Charlie!  This post helped me out as well!!!

[Charlie Arehart]

Very good. Glad to help, Victor. Thanks. 

[bjw57208251]

Appreciate the tip, Charlie.