microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.54k stars 898 forks source link

Generate scripts... fails #23713

Open kaysauter opened 1 year ago

kaysauter commented 1 year ago

Steps to Reproduce:

  1. Connection settings: image

  2. First, script out: image

  3. Immediately after this, this window pops up: image

If you click the button "copy" of this window, you'll get a link that leads to a 404 page. → another minor bug.

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - Die Zertifikatkette wurde von einer nicht vertrauenswürdigen Zertifizierungsstelle ausgestellt.) (Microsoft SQL Server, Error: -2146893019)
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver--2146893019-database-engine-error

Same DB, same localhost with SSMS works fine: image

Nota bene the "Encrypt connection" and "Trust server certificate". The latter is an own-signed certificate as this is just a dev server (localhost).

Does this issue occur when all extensions are disabled?: NO. I've started ADS in terminal with --disable-extensions. The script-out functionality seems to be part of an extension, presumably "Database Administration Tool Extension"

Charles-Gagnon commented 1 year ago

Apologies for the delay @kaysauter - while I investigate this I wanted to know if you're seeing the same behavior when using sql auth (username/password). Is that something you're able to try out?

kaysauter commented 1 year ago

I'll check that and will come back to that in the next few days

kaysauter commented 1 year ago

Just was able to check! And yes, the behavior is the same. Error: 0. Cert chain wasn't issued by a trusted cert issuer. Trust server cert is set=true however

kaysauter commented 8 months ago

Is there any news on this? Can I provide any further help on this?