After adding /var/opt/mssql as a volume and inspecting the path on the container I found out that in my case it was a password that was to simple.

2017-01-23 14:23:27.07 spid17s     Password validation failed. The password does not meet SQL Server password policy requirements because it is too short. The password must be at least 8 characters.

If you use mac, use screen to get to the to the tty

Run screen

screen -AmdS docker ~/Library/Containers/com.docker.docker/Data/com.docker.driver.amd64-linux/tty

Get inside
screen -r

Run your container

docker run --name mssql-container -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=123456' -p 1433:1433  -d microsoft/mssql-server-linux

Check path:
docker inspect CONTAINERID | grep _data

Show error log (container id will be different for you)
cat /var/lib/docker/volumes/CONTAINERID/_data/log/error

from sql-server-samples.

When reading
https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-docker
it states

Volume mapping for Docker-machine on Mac with the SQL Server on Linux image is not supported at this time.

So without volume mapping it works.

from sql-server-samples.

How to solve this?
I would like to use Ms SQL with Meteor on Mac.
Please help me.

from sql-server-samples.

from sql-server-samples.

[@thearabbit] I am assuming that you are trying to run the SQL Server Docker image on Mac.

1. Were you able to follow this article: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-docker to pull and run the mssql-server Docker image on your mac?

2. As far as connecting to MS SQL with Meteor, you could start by using this community project: https://github.com/emgee3/meteor-mssql/ - Not sure if this could be used in a production environment though. There isn't an official Microsoft Meteor connector for mssql currently that I am aware of.

As @jodebrui mentioned we will need more details on what you are trying to do so we can further assist.

Thanks,
Perry

from sql-server-samples.

I run

docker run --name mssql-container -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=123456' -p 1433:1433  -d microsoft/mssql-server-linux

It show

Configuring Microsoft(R) SQL Server(R)...
Microsoft(R) SQL Server(R) setup failed with error code 1. Please check the setup log in /var/opt/mssql/log for more information.

from sql-server-samples.

I get the same error

Microsoft(R) SQL Server(R) setup failed with error code 1. Please check the setup log in /var/opt/mssql/log for more information

from sql-server-samples.

Now it work fine.

from sql-server-samples.

Copyright (C) 2016 Microsoft Corporation. All rights reserved.
on Linux (Ubuntu 16.04.1 LTS)

2017-03-09 20:17:40.13 Server UTC adjustment: 0:00
2017-03-09 20:17:40.14 Server (c) Microsoft Corporation.
2017-03-09 20:17:40.14 Server All rights reserved.
2017-03-09 20:17:40.14 Server Server process ID is 4116.
2017-03-09 20:17:40.14 Server Logging SQL Server messages in file 'C:\var\opt\mssql\log\errorlog'.
2017-03-09 20:17:40.14 Server Registry startup parameters:
-d C:\var\opt\mssql\data\master.mdf
-l C:\var\opt\mssql\data\mastlog.ldf
-e C:\var\opt\mssql\log\errorlog
2017-03-09 20:17:40.17 Server Error: 17113, Severity: 16, State: 1.
2017-03-09 20:17:40.17 Server Error 2(The system cannot find the file specified.) occurred while opening file 'C:\var\opt\mssql\data\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.
2017-03-09 20:17:40.17 Server SQL Server shutdown has been initiated

I am facing this problem when i push the docker image to heroku container registry
it works fine in docker with no issues
please help

from sql-server-samples.

I use Mac, with Docker:

This is an evaluation version. There are [145] days left in the evaluation period.
2017-06-18 23:34:54.64 Server Setup step is copying system data file 'C:\templatedata\master.mdf' to '/var/opt/mssql/data/master.mdf'.
2017-06-18 23:34:56.22 Server Setup step is copying system data file 'C:\templatedata\mastlog.ldf' to '/var/opt/mssql/data/mastlog.ldf'.
2017-06-18 23:34:56.27 Server Setup step is copying system data file 'C:\templatedata\model.mdf' to '/var/opt/mssql/data/model.mdf'.
2017-06-18 23:34:56.37 Server Setup step is copying system data file 'C:\templatedata\modellog.ldf' to '/var/opt/mssql/data/modellog.ldf'.
2017-06-18 23:34:56.48 Server Setup step is copying system data file 'C:\templatedata\msdbdata.mdf' to '/var/opt/mssql/data/msdbdata.mdf'.
2017-06-18 23:34:56.66 Server Setup step is copying system data file 'C:\templatedata\msdblog.ldf' to '/var/opt/mssql/data/msdblog.ldf'.
2017-06-18 23:34:58.93 Server Microsoft SQL Server 2017 (CTP2.1) - 14.0.600.250 (X64)
May 10 2017 12:21:23
Copyright (C) 2017 Microsoft Corporation. All rights reserved.
Developer Edition (64-bit) on Linux (Ubuntu 16.04.2 LTS)
2017-06-18 23:34:58.94 Server UTC adjustment: 0:00
2017-06-18 23:34:58.94 Server (c) Microsoft Corporation.
2017-06-18 23:34:58.94 Server All rights reserved.
2017-06-18 23:34:58.95 Server Server process ID is 4116.
2017-06-18 23:34:58.95 Server Logging SQL Server messages in file '/var/opt/mssql/log/errorlog'.
2017-06-18 23:34:58.95 Server Registry startup parameters:
-d /var/opt/mssql/data/master.mdf
-l /var/opt/mssql/data/mastlog.ldf
-e /var/opt/mssql/log/errorlog
2017-06-18 23:34:58.98 Server Error: 17113, Severity: 16, State: 1.
2017-06-18 23:34:58.98 Server Error 87(The parameter is incorrect.) occurred while opening file '/var/opt/mssql/data/master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.
2017-06-18T23:34:59.201569921Z �s2017-06-18T23:37:28.764444755Z This is an evaluation version. There are [145] days left in the evaluation period.
2017-06-18 23:38:05.98 Server Microsoft SQL Server 2017 (CTP2.1) - 14.0.600.250 (X64)
May 10 2017 12:21:23
Copyright (C) 2017 Microsoft Corporation. All rights reserved.
Developer Edition (64-bit) on Linux (Ubuntu 16.04.2 LTS)
2017-06-18 23:38:05.99 Server UTC adjustment: 0:00
2017-06-18 23:38:05.99 Server (c) Microsoft Corporation.
2017-06-18 23:38:05.99 Server All rights reserved.
2017-06-18 23:38:05.99 Server Server process ID is 4116.
2017-06-18 23:38:06.00 Server Logging SQL Server messages in file '/var/opt/mssql/log/errorlog'.
2017-06-18 23:38:06.00 Server Registry startup parameters:
-d /var/opt/mssql/data/master.mdf
-l /var/opt/mssql/data/mastlog.ldf
-e /var/opt/mssql/log/errorlog
2017-06-18 23:38:06.03 Server Error: 17113, Severity: 16, State: 1.
2017-06-18 23:38:06.03 Server Error 87(The parameter is incorrect.) occurred while opening file '/var/opt/mssql/data/master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.
2017-06-18T23:38:06.303900989Z

Please help me...

from sql-server-samples.

this is still happening in mac the same error any help will be appreciated

Server Error 87(The parameter is incorrect.) occurred while opening file '/var/opt/mssql/data/master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.

from sql-server-samples.

Reproducing this error. Kinda useless error message. I give up.

from sql-server-samples.

got this too

from sql-server-samples.