[google-cloud-sql-discuss] Re: I am able to login using sqlworkbench however unable to login using sql management studio.

Hi Sajjad,

After further investigation, I do not believe you will be able to connect to Cloud SQL from Microsoft SQL Management Studio.

Apparently this tool does not allow native communication with MySQL servers. Some of the articles point to install an ODBC in the server but this would not be possible in Cloud SQL since it is a managed instance [1][2][3].

Sincerely,

Carlos

On Wednesday, October 5, 2016 at 9:34:01 AM UTC-4, Carlos (Cloud Platform Support) wrote:

Hi Sajjad

On the GCP infrastructure you must make sure you used one of the connection methods described in these articles [1][2]. One of the common methods is to whitelist  the source IP address of the machine where the SQL client is installed [1] [3].

If you are running all the client connections from the same IP and you have whitelisted the address, then the issue is probably related to the configuration of your clients. You might find useful this video [4] that shows the streams necessary to connect to a Cloud SQL server from a PHP application or phpMyAdmin.  I also found a 3rd party article that might help you to configure your WordPress connection [5].

I am not very familiar on how Microsoft SQL management studio works but it is possible that it tries to connect using proprietary authentication methods [6].

Let me know if this helps.

Sincerely,

Carlos

On Friday, September 30, 2016 at 4:23:07 PM UTC-4, Sajjad Sarwar wrote:

I am able to login using sqlworkbench however unable to login using sql management studio. Also wanted to use the google sql in WordPress config but it's not connecting.

can anybody help me out in this regard?

--
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/fd3da436-b4c4-423d-a823-8a9cef4964e7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.