sp_executesql is not working when sql server is running in a container

Question

sp_executesql is not working when sql server is running in a container

Yeturu Jagadeesh Reddy 0

sp_executesql is not working when sql server is running in a container. The issue only happens when I specify collation as Latin1_General_BIN

docker command:

docker run -d -p 1433:1433 -e 'ACCEPT_EULA=Y' -e "MSSQL_SA_PASSWORD=$db_password" -e "MSSQL_COLLATION=Latin1_General_BIN" --name database mcr.microsoft.com/mssql/server:latest

reproduce query:


declare @sql nvarchar(MAX) = 'select @@version'
exec sp_executesql @sql

Yeturu Jagadeesh Reddy 0 Reputation points

2025-04-28T04:28:00.7966667+00:00

This is the error that I recieve when I execute the above query

Msg 17750, Level 16, State 0, Procedure sp_executesql, Line 1`` ``Could not load the DLL (server internal), or one of the DLLs it references. Reason: 126(The specified module could not be found.).
Dan Guzman 9,376 Reputation points

2025-04-29T14:04:11.3933333+00:00

This looks like a bug with the binary collation and latest image. I also see the same error with the 2022-CU18-ubuntu-22.04 image tag.

Your answer

Yeturu Jagadeesh Reddy 0 Reputation points

2025-04-28T04:28:00.7966667+00:00

This is the error that I recieve when I execute the above query

Msg 17750, Level 16, State 0, Procedure sp_executesql, Line 1`` ``Could not load the DLL (server internal), or one of the DLLs it references. Reason: 126(The specified module could not be found.).
Dan Guzman 9,376 Reputation points

2025-04-29T14:04:11.3933333+00:00

This looks like a bug with the binary collation and latest image. I also see the same error with the 2022-CU18-ubuntu-22.04 image tag.

Share via

sp_executesql is not working when sql server is running in a container

Your answer