New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to connect on Ubuntu 16.04 to SQL in container #2150

Open
dbafromthecold opened this Issue Aug 4, 2018 · 4 comments

Comments

Projects
None yet
4 participants
@dbafromthecold

dbafromthecold commented Aug 4, 2018

  • SQL Operations Studio Version: 0.31.4

Steps to Reproduce:
docker run -d -p 15789:1433 --env SA_PASSWORD=Testing1122 --env ACCEPT_EULA=Y microsoft/mssql-server-linux

Error when connecting to 127.0.0.1,15789 in SQL Ops Studio:-

System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 31 - Encryption(ssl/tls) handshake failed)

I can connect to the instance using mssql-cli

@dbafromthecold

This comment has been minimized.

dbafromthecold commented Aug 4, 2018

I've tried setting encrypt in the connection to false but the same error is generated

@dbafromthecold dbafromthecold changed the title from Unable to connect on Ubuntu to SQL in container to Unable to connect on Ubuntu 16.04 to SQL in container Aug 4, 2018

@kburtram kburtram added this to the August Public Preview milestone Aug 4, 2018

@dbafromthecold

This comment has been minimized.

dbafromthecold commented Aug 5, 2018

Update - this was resolved by running

sudo update-ca-certificates --fresh

Many thanks to Kevin Cunnane!

@kevcunnane

This comment has been minimized.

Member

kevcunnane commented Aug 6, 2018

@kburtram and @yualan the issue causing this is dotnet/corefx#29942 and its fix is due to be shipped in .Net Core 2.1.3. We might want to reach out and see what the target release date is. In the meantime, if we can document as a known issue for our next release and include the workaround that should help unblock customers.

@kburtram

This comment has been minimized.

Member

kburtram commented Aug 7, 2018

@yualan let's make a note of this issue in the release blog.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment