Inspiring

Answered

CF admin DB Connection to Local SQL Express Fails

Forum|Forum|4 years ago
December 8, 2021
3 replies
1538 views

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.

Correct answer Priyank Shrivastava.

Hi,

Please enable SQL Authentication and create a username and password.

Charlie Arehart

Community Expert

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)

J

JamesMoll777

Participant

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

Community Expert

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)

Priyank Shrivastava.

Correct answer

Community Manager

Hi,

Please enable SQL Authentication and create a username and password.

Thanks, Priyank Shrivastava

S

seasonedwebAuthor

Inspiring

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.

D

Dave Watts

Community Expert

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

S

seasonedwebAuthor

Inspiring

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.

D

Dave Watts

Community Expert

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded