Sudo docker exec -it honeywell /opt/mssql-tools/bin/sqlcmd - S 172.18.0.8 -U sa -P Xkp7VmE6YHVDM Log: awslogs etwlogs fluentd gelf json-file logentries splunk syslog Network: ics l2bridge l2tunnel nat null overlay transparent Perhaps that is the problem in this Docker context? I've not yet seen any documentation online, from any source, that explains how to enable the 'sa' account in a Docker container. Elsewhere I read that the 'sa' account is disabled by default for SQL Server. Incidentally, I have yet to find any MS documentation online that explains the "ContainerAdministrator" account and why it requires no password. The second time around with "docker run" I put the password in quotes -e "sa_password=SecurePassword". I have also tried a "docker rm" of the container, to start fresh. When I enter the password interactively, it still does not work. I tried omitting the "-P SecurePassord" portion, so that it would interactively request the password. However, the following command fails with "Login failed for user 'sa'":ĭocker exec -it sql1 sqlcmd -S localhost -U sa -P SecurePassword The above gives me access as "User Manager\ContainerAdministrator". On my Windows 10 Pro (v 1803) I created my container from a powershell prompt:ĭocker run -d -p 1433:1433 -name sql1 -e sa_password=SecurePassword -e ACCEPT_EULA=Y microsoft/mssql-server-windows-developer:2017-latest
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |