• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

CF admin DB Connection to Local SQL Express Fails

Participant ,
Dec 08, 2021 Dec 08, 2021

Copy link to clipboard

Copied

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.600_sqlexpress-2.jpg600_sqlexpress-1.jpg790_sqlexpress-2.jpg

Views

602

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 2 Correct answers

Community Expert , Dec 08, 2021 Dec 08, 2021

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

Votes

Translate

Translate
Adobe Employee , Dec 08, 2021 Dec 08, 2021

Hi,

 

Please enable SQL Authentication and create a username and password. 

 

Votes

Translate

Translate
Community Expert ,
Dec 08, 2021 Dec 08, 2021

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Dec 09, 2021 Dec 09, 2021

Copy link to clipboard

Copied

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.

600_sqlexpress-3.jpg

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Dec 09, 2021 Dec 09, 2021

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Dec 09, 2021 Dec 09, 2021

Copy link to clipboard

Copied

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

 

Dave Watts, Eidolon LLC

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Dec 09, 2021 Dec 09, 2021

Copy link to clipboard

Copied

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

 

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Dec 08, 2021 Dec 08, 2021

Copy link to clipboard

Copied

Hi,

 

Please enable SQL Authentication and create a username and password. 

 

Thanks,
Priyank Shrivastava

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Dec 09, 2021 Dec 09, 2021

Copy link to clipboard

Copied

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.

 

600_sqlexpress-3.jpg

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 14, 2022 Feb 14, 2022

Copy link to clipboard

Copied

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


/Charlie (troubleshooter, carehart.org)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 19, 2022 Apr 19, 2022

Copy link to clipboard

Copied

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!  

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Apr 19, 2022 Apr 19, 2022

Copy link to clipboard

Copied

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. 🙂 


/Charlie (troubleshooter, carehart.org)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 24, 2023 Sep 24, 2023

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Sep 25, 2023 Sep 25, 2023

Copy link to clipboard

Copied

Very good. Glad to help, Victor. Thanks. 


/Charlie (troubleshooter, carehart.org)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 01, 2023 Dec 01, 2023

Copy link to clipboard

Copied

LATEST

Appreciate the tip, Charlie.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation