can't connect sql instance

[Tim]

Hi everyone,

There is problem connect to sql instance, I did early action in gcp...

create sql instance

restore personal instance to sql

use service credential to login

In the result to connect to db there is error, I don't well know the current service. Let me know who can help me to this matter, thank.

Connecting to database with SQL user [sqlserver].********************************************************************************

Python 2 is deprecated. Upgrade to Python 3 as soon as possible.

See https://cloud.google.com/python/docs/python2-sunset

To suppress this warning, create an empty ~/.cloudshell/no-python-warning file.

The command will automatically proceed in  seconds or on any key.

********************************************************************************

Password:

Traceback (most recent call last):

  File "/usr/lib/python2.7/runpy.py", line 174, in _run_module_as_main

    "__main__", fname, loader, pkg_name)

  File "/usr/lib/python2.7/runpy.py", line 72, in _run_code

    exec code in run_globals

  File "/usr/local/lib/python2.7/dist-packages/mssqlcli/main.py", line 117, in <module>

    main()

  File "/usr/local/lib/python2.7/dist-packages/mssqlcli/main.py", line 110, in main

    run_cli_with(mssqlcli_options)

  File "/usr/local/lib/python2.7/dist-packages/mssqlcli/main.py", line 43, in run_cli_with

    from mssqlcli.mssql_cli import MssqlCli

  File "/usr/local/lib/python2.7/dist-packages/mssqlcli/mssql_cli.py", line 18, in <module>

    from prompt_toolkit.shortcuts import PromptSession, CompleteStyle

ImportError: cannot import name PromptSession

[David (Cloud Platform Support)]

Hello,

Are you using the Cloud Shell? 

Because if you are, there is a known Issue while connecting from it possibly related to the python runtime or environment variable. Could you please try connecting from a Compute Engine instance? For now, I would recommend you to follow this Issue Tracker link as our Cloud Shell engineering team is aware of this issue and currently investigating it.

[Danial Ameen]

i am also facing the same problem for create sql instance

restore personal instance to sql

use service credential to login for my  store best ninjasmerchstore .. thanks for the solution...

On Tuesday, March 10, 2020 at 5:49:08 PM UTC+5, Tim wrote:

Hi everyone,

There is problem connect to sql instance, I did early action in gcp...

create sql instance

restore personal instance to sql

use service credential to login

In the result to connect to db there is error, I don't well know the current service. Let me know who can help me to this matter, thank.

Connecting to database with SQL user [sqlserver].********************************************************************************

Python 2 is deprecated. Upgrade to Python 3 as soon as possible.

See https://cloud.google.com/python/docs/python2-sunset here

[Katayoon (Cloud Platform Support)]

Hi Danial,

If you are receiving the same issue reported in the public issue tracker, I recommend to star the ticket for further updates on it.