Connection verification failed for data source

Community Beginner ,
Feb 12, 2021 Feb 12, 2021

Copy link to clipboard

Copied

Environment Details:
ColdFusion 2021 Release
Microsoft SQLServer 2019
Microsoft SQLServer Management Studio Version 18.8

Error Message:
"Connection verification failed for data source: TESTDBDSN
java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'admin'."

Hello,

when i add new datasource in coldfusion administration page by selecting Microsoft SQL Server Driver,Im getting above error message.

I have entered only Server Name as "DAGEOP", the CF administrator by defalt adding user name as "admin" and some hidden password. 

Kindly let me know what mistake i have done and how to solve this error.

Below are few details about my installation.

Error1.PNGService Running Status.PNGSqlserverconfigurationmanager setting.PNGsql server and window.PNGtcpip.pngcfservices.PNGServer connection properties.PNG

TOPICS
Database access

Views

75

Likes

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 1 Correct Answer

Adobe Community Professional , Feb 13, 2021 Feb 13, 2021
I seriously doubt "admin" is a valid Windows account or native SQL login. That's just a set of credentials to access the CF Administrator, and has nothing to do with your database. You'll need to create a login in SQL Server that has the rights you want, then either use a native SQL login to get to it, or a Windows account. It's a lot easier to use native SQL logins from CF, but it's not impossible to use a Windows account. I recommend you try a native SQL login first. Ideally, your login should...

Likes

Translate

Translate
Adobe Community Professional ,
Feb 13, 2021 Feb 13, 2021

Copy link to clipboard

Copied

I seriously doubt "admin" is a valid Windows account or native SQL login. That's just a set of credentials to access the CF Administrator, and has nothing to do with your database. You'll need to create a login in SQL Server that has the rights you want, then either use a native SQL login to get to it, or a Windows account. It's a lot easier to use native SQL logins from CF, but it's not impossible to use a Windows account. I recommend you try a native SQL login first. Ideally, your login should have minimal privileges in SQL Server - probably just the ability to create/update/delete/read records. It should not have rights to change the schema or anything crazy like that.

 

https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-lo....

 

Dave Watts, Eidolon LLC

Likes

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 Beginner ,
Feb 13, 2021 Feb 13, 2021

Copy link to clipboard

Copied

LATEST

Thanks again Dave,

As you said, I have created SQL Login and  It is  working now.

After 20 years gap, I have successfully execute my CFQuery Statement 🙂

ok.PNG

Likes

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