Thursday, September 17, 2020

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

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/c6f589f2-316a-4453-9eee-e2f07f9b66a9n%40googlegroups.com.

No comments:

Post a Comment