Not able to connect to sqlserver database instance

Question

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

Dave Watts · Answer

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.

https://learn.microsoft.com/en-us/sql/relational-databases/security/choose-an-authentication-mode?view=sql-server-ver16#connecting-through-sql-server-authentication

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