Skip to content
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

SQL Server version on Ubuntu (20.04) #786

Open
laingsimon opened this issue Feb 28, 2021 · 0 comments
Open

SQL Server version on Ubuntu (20.04) #786

laingsimon opened this issue Feb 28, 2021 · 0 comments

Comments

@laingsimon
Copy link

laingsimon commented Feb 28, 2021

On the Software pre-installed on Linux build VMs page, it is indicated that SQL Server 2017 15.0.4033 is available on the Ubuntu2004 image.

The update from May 9, 2020 states that SQL server isn't available (yet):

Microsoft SQL Server is not supported on Ubuntu 20.04 yet;

I've tried this image with several variants of the connection string and i'm unable to connect to the database server during a build. This build is using dotnet core to build and then execute tests (which in turn require the database instance to be online).

The connection string is as per the documentation.

Are you able to confirm if the documentation in the 'pre-installed on Linux build VMS' is up to date?

If SQL Server is available then great, in which case could you please advise on why the given connection string fails to connect (see error below). If not could you update the page and advise on what other build VMs are available to use SQL Server & mysql (version 8) at the same time.

Error

Could not open connection with string: Server=(local)\SQL2017;Database=master;User ID=sa;Password=Password12!
  Error Message:
   System.Data.SqlClient.SqlException : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 25 - Connection string is not valid)

Thanks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant