bucrogers / dockerfiles-for-windows Goto Github PK

On windows server 2016TP5 after running docker build -t sqlexpress .

1cf51c47c298: Extracting [==================================================>] 72.03 MB/72.03 MB
849b9bdf7071: Download complete
failed to register layer: convert O:BAG:DUD:(A;OICI;0x1200a9;;;S-1-5-83-0)(A;OICI;FA;;;BA)(A;OICI;FA;;;SY)(A;;FA;;;BA)(A;OICIIO;GA;;;CO)(A;OICI;0x1200a9;;;BU)(A;CI;LC;;;BU)(A;CI;DC;;;BU): The security ID structure is invalid.

Hi,

I'm facing issue when I'm building the Dockerfile under sqlexpress folder. Please refer to the following details:

OS:

Windows 10 with Docker Toolbox 1.11.2

Command to build:

docker build -t sqlexpress .

Error:

Step 10 : RUN powershell wget http://download.microsoft.com/download/E/A/E/EAE6F7FC-767A-4038-A954-49B8B05D04EB/Express%2064BIT/SQLEXPR_x64_ENU.exe -OutFile sqlexpr_x64_enu.exe && /install/sqlexpr_x64_enu.exe /q /x:/install/setup && /install/setup/setup.exe /q /ACTION=Install /INSTANCENAME=%sqlinstance% /FEATURES=SQLEngine /UPDATEENABLED=1 /SECURITYMODE=SQL /SAPWD=%sqlsapassword% /SQLSVCACCOUNT="NT AUTHORITY\System" /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /INSTALLSQLDATADIR=%sqldata% /SQLUSERDBLOGDIR=%sqldata% /SQLBACKUPDIR=%sqlbackup% /TCPENABLED=1 /NPENABLED=0 /IACCEPTSQLSERVERLICENSETERMS && powershell ./Set-SqlExpressStaticTcpPort %sqlinstance% && powershell ./Move-dirs-and-stop-service %sqlinstance% %sql% %sqldata% %sqlbackup% && del sqlexpr_x64_enu.exe && rmdir .\setup /s /q
---> Running in f017abc23266
Container command '/bin/sh' not found or does not exist.

Do you have some clues to sort it out this issue?
Thank you.

hi all,
i get this error after pulling postgresql-windows image to windows server 2016.

failed to register layer: re-exec error: exit status 1: output: ProcessBaseLayer C:\ProgramData\docker\windowsfilter\7d5e3af752f5765eb9407c1250824d2a2ba55d3ae1498c4f1907525762190ec
f: Cannot create a file when that file already exists.

Can anyone help?

I have built the SQL image and it works fine and can access it from host machine through SQL studio management.
I understnad that to accessed sql from outside the host machine – for a single instance of the SQL Server container, we need to open port 1433 – from powershell:

if (!(Get-NetFirewallRule | where {$_.Name -eq "SQLServer 1433"})) { New-NetFirewallRule -Name "SQL Server 1433" -DisplayName "SQL Server 1433" -Protocol tcp -LocalPort 1433 -Action Allow -Enabled True}

I ran the command and get the following error

New-NetFirewallRule : There are no more endpoints available from the endpoint

In fact, even running this simple command

Get-NetFirewallProfile

I get the same error

Thanks for your help

try build sqlexpress on osx

using docker private beta

Thank you for such a great starter repository! I was able to stand up a host machine/ build the SQLExpress image (with your fine work here) but one issue I've been plagued with is not showing port 1433 as "listening" in WinServer2016TP5 and I'm curious if you have any resources related to this that are current/work.

I've tried a handful of the usual firewall rule hacking but it appears that I may have a handful of other issues that I'm less aware how to diagnose

1. MS SQL Server Browser Service may not be running. How could I find out/ start this ?
2. TCP/IP channel is disabled under SQL Server. How could I find out/ enable it?
3. any other networking issue?

Any guidance/ resources would be greatly appreciated :)

how to using sqlserver-express image in dockerfile in windows based container

I got this error when run cd sqlexpress; Get-Content .\dockerfile | docker build -t

Full log

PS D:\projects\Dockerfiles-for-windows\sqlexpress> Get-Content .\dockerfile | docker build -t sqlexpress -
Sending build context to Docker daemon  5.12 kB
Step 1 : FROM docker.io/microsoft/dotnet35:windowsservercore
 ---> d9aa93e5e8f8
Step 2 : MAINTAINER Buc Rogers
 ---> Using cache
 ---> 11855ef37d52
Step 3 : ENV sqlinstance SQL
 ---> Using cache
 ---> 84d203a3c073
Step 4 : ENV sqlsapassword thepassword2#
 ---> Using cache
 ---> 73497686ec69
Step 5 : ENV sql c:\\sql
 ---> Using cache
 ---> d35b7f55f37b
Step 6 : ENV sqldata c:\\sql\\data
 ---> Using cache
 ---> b4254af15df4
Step 7 : ENV sqlbackup c:\\sql\\backup
 ---> Using cache
 ---> f3cd6d90753a
Step 8 : COPY . /install
 ---> Using cache
 ---> 52d6db2f4cd0
Step 9 : WORKDIR /install
 ---> Using cache
 ---> 86559bd80011
Step 10 : RUN powershell wget http://download.microsoft.com/download/E/A/E/EAE6F7FC-767A-4038-A954-49B8B05D04EB/Express%2064BIT/SQLEXPR_x64_ENU.exe       -OutFile sqlexpr_x64_enu.exe   && /install/sqlexpr_x64_enu.exe /q /x:/install/setup   && /install/setup/setup.exe /q /ACTION=Install /INSTANCENAME=%sqlinstance% /FEATURES=SQLEngine /UPDATEENABLED=1       /SECURITYMODE=SQL /SAPWD=%sqlsapassword% /SQLSVCACCOUNT="NT AUTHORITY\System"  /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS"       /INSTALLSQLDATADIR=%sqldata% /SQLUSERDBLOGDIR=%sqldata% /SQLBACKUPDIR=%sqlbackup%       /TCPENABLED=1 /NPENABLED=0 /IACCEPTSQLSERVERLICENSETERMS   && powershell ./Set-SqlExpressStaticTcpPort %sqlinstance%   && powershell ./Move-dirs-and-stop-service %sqlinstance% %sql% %sqldata% %sqlbackup%   && del sqlexpr_x64_enu.exe   && rmdir .\setup /s /q
 ---> Running in d6c133256622
oci runtime error: exec: "/bin/sh": stat /bin/sh: no such file or directory

docker version

PS D:\projects\Dockerfiles-for-windows\sqlexpress> docker version
Client:
 Version:      1.12.0-rc2
 API version:  1.24
 Go version:   go1.6.2
 Git commit:   906eacd
 Built:        Fri Jun 17 20:35:33 2016
 OS/Arch:      windows/amd64
 Experimental: true

Server:
 Version:      1.12.0-rc2
 API version:  1.24
 Go version:   go1.6.2
 Git commit:   a7119de
 Built:        Fri Jun 17 22:09:20 2016
 OS/Arch:      linux/amd64
 Experimental: true

I run this command: docker start sql4
and get this error:

Error response from daemon: failed to create endpoint sql4 on network nat: HNS failed with error : Failed to create endpoint
Error: failed to start containers: sql4

i can make new containers and start stop them, but cannot start containers i made before i restartet the server

heelp