I have Jenkins installed locally on my laptop running windows 10. I spin up a Linux container running SQL Server, however when I attempt to run the following:
winpty docker exec -it SQLLinuxnull sudo /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P P@ssword1 -Q 'EXEC sp_configure '\''clr enabled'\'', 1;'
I get:
stdin is not a tty
When I run the docker exec
command from a powershell session it completes without any issues. Trawling this site pulls up answer suggesting that this might be something to do with whatever account is being used in the Linux container requiring the ability to execute sudo and that I should alter the /etc/sudoers
file, the problem being is that I do not have an /etc/sudoers
file, according to uname -a
this is the version of Linux the container is based on (not that its base is the official Microsoft SQL server in Linux image):
# uname -a
Linux f9509a952eae 4.9.49-moby #1 SMP Wed Sep 27 00:36:29 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
Can someone confirm that this is a sudoers related issue.