[google-cloud-sql-discuss] Token-based server access validation failed with an infrastructure error. Login lacks connect endpoint

 I have Cloud SQL instance(16 vCPUs, Memory 128 GB, SSD storage 300 GB). Db size 110GB.

When I execute a complex query from the cloud windows VM using SQL Server Management Studio(this vm is in the same VPC as SQL Server), it always takes on average 35s. When I execute the same query from the same machine using DBeaver it takes 1.5s on average. Tried connecting with SQL Proxy, nothing changed.

Every time i try to connect the database using SSMS, I see the following error in the sql server logs in SSMS:

Login failed for user '3aec90b46f01d28\3aec90b46f01d28$'. Reason: Token-based server access validation failed with an infrastructure error. Login lacks connect endpoint permission. [CLIENT: 127.0.0.1]

Is there a solution to this? We are close to giving up migrating to Cloud SQL :(

Thanks for all the help in advance.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/4f671158-c3d9-4dde-a2bf-c81f79e3ecafn%40googlegroups.com.