question

GozdzielewskiSlawomir-5016 avatar image
0 Votes"
GozdzielewskiSlawomir-5016 asked ErlandSommarskog commented

Problem with SQL Server on docker with Latin1_General_BIN2 collation

I have problem with executing sp_executesql procedure on SQL Server docker version if I set up collation to Latin1_General_BIN2.
Trying to execute exec sp_executesql 'select 1' I get error:
Msg 17750, Level 16, State 0, Procedure sp_executesql, Line 1 [Batch Start Line 0]
Could not load the DLL (server internal), or one of the DLLs it references. Reason: 126(The specified module could not be found.).

Host OS: Ubuntu 16.04
Docker version: 19.03.6
SQL Server image: mcr.microsoft.com/mssql/server:2019-latest 356de8c1fd95

I had the same issue on 2017 sql server images.

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

I was able to reproduce this on Ubuntu 20.04. This have to be construed as a bug in the product. If this is a blocking issue for you and you need a fix, you will have to open a support case.

If you only want let Microsoft know, the place to report it is https://feedback.azure.com/forums/908035-sql-server.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @GozdzielewskiSlawomir-5016,

If you want to open a case for this issue, please go to this link https://support.microsoft.com/en-us/assistedsupportproducts


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GozdzielewskiSlawomir-5016 avatar image
0 Votes"
GozdzielewskiSlawomir-5016 answered Cathyji-msft commented

Thank you for the answer. We will open a case.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Good. If possible, let us know the outcome!

0 Votes 0 ·

Hi @GozdzielewskiSlawomir-5016,

Thanks for your reply. Waiting for your good news.

0 Votes 0 ·
GozdzielewskiSlawomir-5016 avatar image
0 Votes"
GozdzielewskiSlawomir-5016 answered ErlandSommarskog commented

I'm back with info.
We have opened the case, the outcome is that to have this collation (and some other with similar problem) you have to restart docker container after you create it.



docker run -e ACCEPT_EULA=Y -e SA_PASSWORD="Password1" -e MSSQL_AGENT_ENABLED="True" -e MSSQL_COLLATION="Latin1_General_BIN2" -p 41433:1433 --hostname sqltest --name sql9 -d mcr.microsoft.com/mssql/server:2019-latest

docker restart -t 60 sqltest

After restart everything works fine.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Boy! That was simple! Why didn't we think of this?

Thanks for reporting back!

0 Votes 0 ·