Connection verification failed for data source

[tnsenthil]

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.

[Dave Watts · Accepted solution]

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

[tnsenthil]

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 🙂