From e3871c076569b075ce1d48417b5f097ca3ac54fd Mon Sep 17 00:00:00 2001 From: Gord Thompson Date: Sun, 20 Sep 2020 14:43:33 -0600 Subject: [PATCH] Tweak docker config for mssql Change-Id: Iae6fca41976f9cd7a3870f18eadfbea146d572dd --- README.unittests.rst | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/README.unittests.rst b/README.unittests.rst index 84026007da..03752b7640 100644 --- a/README.unittests.rst +++ b/README.unittests.rst @@ -287,10 +287,9 @@ intended for production use! # configure the database sleep 20 - docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'yourStrong(!)Password' -Q "sp_configure 'contained database authentication', 1; RECONFIGURE; CREATE DATABASE test CONTAINMENT = PARTIAL; ALTER DATABASE test SET ALLOW_SNAPSHOT_ISOLATION ON; ALTER DATABASE test SET READ_COMMITTED_SNAPSHOT ON" + docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'yourStrong(!)Password' -Q "sp_configure 'contained database authentication', 1; RECONFIGURE; CREATE DATABASE test CONTAINMENT = PARTIAL; ALTER DATABASE test SET ALLOW_SNAPSHOT_ISOLATION ON; ALTER DATABASE test SET READ_COMMITTED_SNAPSHOT ON; CREATE LOGIN scott WITH PASSWORD = 'tiger^5HHH'; ALTER SERVER ROLE sysadmin ADD MEMBER scott;" docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'yourStrong(!)Password' -d test -Q "CREATE SCHEMA test_schema" docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'yourStrong(!)Password' -d test -Q "CREATE SCHEMA test_schema_2" - docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'yourStrong(!)Password' -d test -Q "CREATE USER scott WITH PASSWORD = 'tiger^5HHH'; GRANT CONTROL TO scott" # To stop the container. It will also remove it. docker stop mssql -- 2.47.3