[google-cloud-sql-discuss] Re: CloudSQL SqlServer user not able to access database

I managed to enable the connectivity for the app user ....and now they are able to connect and access  the database using SSMS  ...however now we seem to have another issue when the application is trying to connect .....here is what I see in the db logs

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

On Thursday, September 17, 2020 at 6:57:44 PM UTC-4 Elliott (Google Cloud Platform Support) wrote:

Hello,

When did this behavior begin? Were you able to connect to it before? Has anything changed?

On Wednesday, September 16, 2020 at 8:53:57 PM UTC-4 nara.ram...@ditoweb.com wrote:

 hav an application running on Compute Engine which was created with a specific userid thats used to access database services.  Earlier the database was on SQLServer Express edition hosted on the same CE.  migrated the express edition database to CloudSQL SqlServer 2017 standard edition.  

In addition to the default "sqlserver" user created by CloudSQL,  created a new user with the same credentials as the user used by the application. 

able to connect from the VM using Microsoft SQL Server Management Studio to the CloudSQL instance and can see the System Databases and the new DB that was crated. However when opening the new DB keep getting the following error message

"The database ******* is not accessible. (ObjectExplorer)"

we definitely need to t get connectivity to the database with the user  that the app uses since the app user can't be modified at the application level

--
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/b0c968e6-bf90-4e52-916c-c882b1a66de8n%40googlegroups.com.