MacOS - Error: 17113, Severity: 16, State: 1. #160

clouless · 2016-12-08T15:42:11Z

I am running docker 1.12.3 on macOS El Capitan.

Docker can use 9GB Ram of total 16GB.

When I run:

docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=2TY-Q_VN_wnR!1YZS1xd0c_b!7AUb_2rd7hJG!xihdG!8uNCavA!Rw' -p 1433:1433  -v /Users/clouless/docker/mssql/opt:/var/opt/mssql microsoft/mssql-server-linux

It gives me the Error message:

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.

I have mounted the /var/opt/ to my host and when I cat the logfile it says:

cat ~/docker/mssql/opt/log/errorlog

2016-12-08 15:36:52.13 Server      Microsoft SQL Server vNext (CTP1) - 14.0.1.246 (X64)
	Nov  1 2016 23:24:39
	Copyright (c) Microsoft Corporation
	on Linux (Ubuntu 15.10)
2016-12-08 15:36:52.19 Server      UTC adjustment: 0:00
2016-12-08 15:36:52.20 Server      (c) Microsoft Corporation.
2016-12-08 15:36:52.22 Server      All rights reserved.
2016-12-08 15:36:52.24 Server      Server process ID is 4116.
2016-12-08 15:36:52.26 Server      Logging SQL Server messages in file 'C:\var\opt\mssql\log\errorlog'.
2016-12-08 15:36:52.29 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
2016-12-08 15:36:52.35 Server      Command Line Startup Parameters:
	 --setup
	 --sa-password
2016-12-08 15:36:52.52 Server      Error: 17113, Severity: 16, State: 1.
2016-12-08 15:36:52.52 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.
2016-12-08 15:36:52.64 Server      SQL Server shutdown has been initiated

The text was updated successfully, but these errors were encountered:

clouless · 2016-12-08T16:48:16Z

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.

thearabbit · 2017-01-19T04:58:12Z

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

jodebrui · 2017-01-19T16:25:07Z

Hi, could you please give more detail? Which sample are you trying to use? Which version and edition of SQL Server? What are the repro steps? Thanks, Jos From: Yuom Theara [mailto:notifications@github.com] Sent: Wednesday, January 18, 2017 8:58 PM To: Microsoft/sql-server-samples <sql-server-samples@noreply.github.com> Cc: Subscribed <subscribed@noreply.github.com> Subject: Re: [Microsoft/sql-server-samples] MacOS - Error: 17113, Severity: 16, State: 1. (#160) How to solve this? I would like to use Ms SQL with Meteor on Mac. Please help me. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Fissues%2F160%23issuecomment-273682399&data=02%7C01%7Cjodebrui%40microsoft.com%7C8fb4c95e5f6448ef4c4408d44027c7b6%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636203986975419401&sdata=Syf5vb1vb16uiJCcYcFM2X6RGSmkC0uDYd5Bqr4Z0Ao%3D&reserved=0>, or mute the thread<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAMuA9gT9uafzpmfo9SYn60VgspD8ditpks5rTu1mgaJpZM4LH9X6&data=02%7C01%7Cjodebrui%40microsoft.com%7C8fb4c95e5f6448ef4c4408d44027c7b6%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636203986975419401&sdata=vH61PwkfvksR%2FyW8ZqE8bF1DgEqhr6muY9Lo5BBYhD0%3D&reserved=0>.

perrysk-msft · 2017-01-19T18:05:51Z

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

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?
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

thearabbit · 2017-01-20T00:51:56Z

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.

majest · 2017-01-23T14:18:18Z

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

majest · 2017-01-23T14:33:02Z

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

thearabbit · 2017-01-24T00:08:05Z

Now it work fine.

somashekarg · 2017-03-09T20:38:31Z

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

jdev29 · 2017-06-18T23:50:16Z

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...

Deepankar01 · 2017-12-16T06:50:43Z

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.

chrisdone · 2018-02-01T00:45:54Z

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

spriet2000 · 2018-02-16T20:32:45Z

got this too

clouless closed this as completed Dec 8, 2016

Deepankar01 mentioned this issue Dec 16, 2017

Error: 17113, Severity: 16, State: 1 #344

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

MacOS - Error: 17113, Severity: 16, State: 1. #160

MacOS - Error: 17113, Severity: 16, State: 1. #160

clouless commented Dec 8, 2016

clouless commented Dec 8, 2016

thearabbit commented Jan 19, 2017

jodebrui commented Jan 19, 2017 via email

perrysk-msft commented Jan 19, 2017

thearabbit commented Jan 20, 2017

majest commented Jan 23, 2017 •

edited

majest commented Jan 23, 2017 •

edited

thearabbit commented Jan 24, 2017

somashekarg commented Mar 9, 2017

jdev29 commented Jun 18, 2017

Deepankar01 commented Dec 16, 2017 •

edited

chrisdone commented Feb 1, 2018

spriet2000 commented Feb 16, 2018

MacOS - Error: 17113, Severity: 16, State: 1. #160

MacOS - Error: 17113, Severity: 16, State: 1. #160

Comments

clouless commented Dec 8, 2016

clouless commented Dec 8, 2016

thearabbit commented Jan 19, 2017

jodebrui commented Jan 19, 2017 via email

perrysk-msft commented Jan 19, 2017

thearabbit commented Jan 20, 2017

majest commented Jan 23, 2017 • edited

majest commented Jan 23, 2017 • edited

thearabbit commented Jan 24, 2017

somashekarg commented Mar 9, 2017

jdev29 commented Jun 18, 2017

I use Mac, with Docker:

Deepankar01 commented Dec 16, 2017 • edited

chrisdone commented Feb 1, 2018

spriet2000 commented Feb 16, 2018

majest commented Jan 23, 2017 •

edited

majest commented Jan 23, 2017 •

edited

Deepankar01 commented Dec 16, 2017 •

edited