I am trying to connection a database instance which is gcp , i have the correct credentials but I am getting error on CF admin dsn , I can connect this db instance using sqlserver studio using the login credentials(ip, db username , db password) but not able to connect it from cf admin which is also in gcp.
Connection verification failed for data source: testDB
java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sqlserver'.
The root cause was that: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sqlserver'.
What is your ColdFusion version and update level?
What datasource settings do you use, comparable to mine below (remember to use * characters for the password)
This is a pretty common problem with Microsoft SQL Server. It accepts two different forms of authentication: Windows Authentication by default and native SQL logins optionally. You can't disable Windows Authentication, but you do have to enable native SQL logins in all the cases I remember. I suspect that this is also how it works in GCP as long as you're not using Cloud SQL. Here's instructions from Microsoft on the different authentication options in SQL Server. You want "mixed-mode" to use native SQL logins.
Dave Watts, Eidolon LLC