You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do?
A.
Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
B.
Check whether your service account has cloudsql.instances.connect permission.
C.
Enable the Cloud SQL Admin API.
D.
Ensure that you are using an external (public) IP address interface.
The answer is C.
If you're missing cloudsql.instances.connect on the attached service account, the error is 403 FORBIDDEN.
If you haven't enabled the Cloud SQL Admin API, the error is 403 ACCESS NOT CONFIGURED.
https://cloud.google.com/sql/docs/mysql/connect-auth-proxy#troubleshooting
C because in docs it says "Make sure to enable the Cloud SQL Admin API. If it is not, you see output like Error 403: Access Not Configured in your Cloud SQL Auth Proxy logs."
B is not correct because this is for a different error: "If you are getting a 403 notAuthorized error, and you are using a service account to authenticate the Cloud SQL Auth Proxy, make sure the service account has the correct permissions."
The "Error 403: Access Not Configured" message typically indicates a permission issue related to the Cloud SQL instance. The correct answer is B
B. Check whether your service account has cloudsql.instances.connect permission.
C.
D is not a recommended way to access a Cloud SQL instance and you wouldn’t get a 403 error connecting via a public IP anyway. A and B could trigger a 403 error, but the text would be “not authorized”. The answer is in Google’s documentation. The link provided by sp57 is spot on.
typo.. its C
Make sure to enable the Cloud SQL Admin API.
If it is not, you see output like Error 403: Access Not Configured in your Cloud SQL Auth proxy logs.
B
403 notAuthorized error, and you are using a service account to authenticate the Cloud SQL Auth proxy, make sure the service account has the correct permissions.
wrong - error is 403 Access not Configured - see 4 bullet pts down at link https://cloud.google.com/sql/docs/mysql/connect-admin-proxy#troubleshooting
C is correct
Correct Answer - B
https://cloud.google.com/sql/docs/mysql/connect-admin-proxy#troubleshooting:~:text=If%20you%20are%20getting,have%20this%20permission.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Pime13
5 months, 3 weeks agoAngieSoccerBall49
11 months agojuliorevk
1 year agoewelaz
1 year agolearnazureportal
1 year, 1 month agoDPonly
1 year, 3 months agoPilot50
1 year, 6 months agodynamic_dba
1 year, 7 months agoSVGoogle89
1 year, 10 months agoSVGoogle89
1 year, 10 months agosp57
1 year, 10 months agoGCP72
1 year, 10 months agopk349
1 year, 10 months agochelbsik
1 year, 10 months agojitu028
1 year, 10 months agorange9005
1 year, 10 months agojuancambb
1 year, 10 months ago