[Windows Container] SQL Server

I've been a long time not play with Window Container.Today I just saw an article which introduces the SQL Server Container how to used.Therefore I doing a practice follow by this article.Due to operation system was reset so that I reinstall the Window Container by the way.

1.Install Windows Container

Power Shell execute the following script
Enable-WindowsOptionalFeature -Online -FeatureName Microsoft-Hyper-V -All
Enable-WindowsOptionalFeature -Online -FeatureName containers -All

ps:Window10 required  14393.222 or than this version，To restart after being installed.

2.Install Dock

There are two ways to do that.

1.To reference official site No.2.Install by command.

*2.Install by Dock for Windows (.exe) ps:I used this way.


After installed, Switching Windows Container  

More about Dock for Windows as below.

3.Install SQL Server Container

docker pullmicrosoft/mssql-server-windows

Create container

Create a container naming as SQLTest then set the local path to Container which used for import backup.

docker run -it --name SQLTest -d -p 1433:1433 -e sa_password=kim123 -e ACCEPT_EULA=Y -v D:/Temp/Database/:c:/DB/ microsoft/mssql-server-windows

If you knew the NAT ip range at first.Your set the ip at startup.

 docker run -it --name SQLTest --ip 172.25.171.182 -d -p 1433:1433 -e sa_password=kim123 -e ACCEPT_EULA=Y -v D:/Temp/Database/:c:/DB/ microsoft/mssql-server-windows


ps:The default NAT setting

 docker inspect  nat


If you are like me not have the ability to compute the subnet IP range.You can use the following link.


import backup.bak

docker exec SQLTest SqlCmd -E -S 172.25.171.182 -Q "RESTORE DATABASE [UnderBingo] FROM  DISK = N'C:\db\UnderBingo.bak' WITH  FILE = 1
,  MOVE N'UnderBingo' TO N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\UnderBingo.mdf'
,  MOVE N'UnderBingo_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\UnderBingo_log.ldf'
,  NOUNLOAD,  STATS = 5"


Afer imported, Run SSMS and connecting the SQL Container

Reference 

Popular posts from this blog

VS2017-Build fail-FindDependenciesOfExternallyResolvedReferences

Image
Recently, After installed the newest version of Visual Studio 2017 that occurred some of the following error messages: Software Infomation:Visual Studio 2017 Enterprise 15.7.4  (The problem since 15.6.x) Workaround I asked the help from forums the got temporary workaround as below: Opening file: C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets Finding the red block highlight at below photo then remove it from the file. Reference https://developercommunity.visualstudio.com/content/problem/208668/the-finddependenciesofexternallyresolvedreferences.html
Keep reading

SQL Server pass parameter to Procedure

Today, My colleague mention his work which how to pass the parameter to the procedure. The workaround as below: 1.Declare a custom table type CREATE   TYPE   dbo . USER_TABLE_TYPE  AS   TABLE   (        USER_NO   VARCHAR ( 8 ) ) 2.C# Declare DataTable and SqlParameter      var   table =   new   DataTable();             table.Columns.Add( new   DataColumn( "USER_NO" , System.Type.GetType( "System.String" )));             table.Rows.Add(table.NewRow());             table.Rows[0][ "USER_NO" ] =   "Abc" ;               var   par =   new   SqlParameter             {                 ParameterName =   "userTable" ,                 Value = table,                 SqlDbType = SqlDbType.Structured,                 TypeName =   "dbo.USER_TABLE_TYPE"             }; 3.Declare parameter which type is just created CREATE   PROCEDURE   dbo . GetUsers        @userTable USER_TABLE_TYPE  READONLY
Keep reading

IIS Block IP Setting

Image
We have two Web Server one for internal another for external. Now we consider let two into one. The main site will be opened a limited specific IP range, but some of the other sites will be opened to the public. How to 1.Add Features- IP and Domain Restriction After installed, It will show the icon in the root or subsites. 2.Setting IIS Root access from Allow to Deny. 3.IIS Root against specific IP range to open.e.g.The mask of the example as 255.255.255.0 it means from192.168.2.0~255 can be accessed. 4.Opening to the public by specific sites. Due to IIS Root has setting the deny. All of the sites will inherit this setting. After subsite modify its settings then it will base on a subsite. Therefore, it can be satisfied our request the deny is default but some allow. All of the settings are stored in the IIS config file. %windir%\System32\inetsrv\config\applicationHost.config Above-mentioned, all of the settings processes also can be execute
Keep reading