Seven obstacles of SQL Server Core Installation
SQL Server Windows Core installation does not support Reporting Service
Read next: Five Steps of Remote SQL Server installation using PowerShell
In previous topics I've described what kind of problems you can face during SQL Server core installations and I think to make the picture fully clear I have to cover the preparation steps of installing and configuring Windows Core for SQL Server installation.
As usually I do everything step by step:
Step #1. Setting up Virtual machine in Hyper-VYou can do your exercise in VMWare as well. In My case I have native Hyper-V App on my Windows 8 Pro laptop.
After you install your Hyper-V application and run it you create new virtual machine:
Then mark a checkbox "Store the virtual machine in different location" and specify the location where you want to keep your new VM. You might skip that step, but I prefer to keep everything under mine control and in case I need to do a cleanup I know which folder to delete to get some extra space.
After making the change click "Next"
You need the network for your new windows installation to access Internet to download necessary updates.
After specifying the network click "Next".
It will be completely enough for our exercise. Click "Next" after the change.
You can download Evaluation Windows Server from here: https://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-technical-preview
For this example I've chosen Windows Server 2016 Technical Preview 5.
Note: Do not try to use 64-bit installation on 32-bit workstation. It won't work.
After you specify the file click "Next".
In very few moments your virtual machine will be created.
The very first thing you have to do after that is to create a checkpoint:
Do Right Click on your new VM and choose "Checkpoint"
As a result it will create a new record in "Checkpoint" panel:
Step #2. Windows Core Installation.At first, do right click on your virtual machine click "Start" and then click "Connect"
If your windows image is accepted you have to get following screen:
After a while you get following screen:
And you are done with Windows Core Install!!!
The last thing you have to do: create another checkpoint for your VM
Step #3. Establishing Network connection.If you setup your network adapter and virtual switch correctly that step has to be short and easy for you.
Just run following command to create network resource:
>NET USE L: \\<DServer Name>\<Shared Resource Name> /USER:<User name> /persistent:yes
Than provide password and verify the mapped drive by following command:
You should have result about like that:
1. It is our checkup of the network.
2. We might need to transfer some files, scripts, logs inside and out of that VM box.
At the end, create another checkpoint called "Network Set"
Step #4. Set your new server for remote management.Here you have two options:
First (conventional): Run Windows configuration CMD file:
See a description how to set Windows Core Server in 12 steps: http://pc-addicts.com/12-steps-to-remotely-manage-hyper-v-server-2012-core
Second (guru way): Use PowerShell.
Because the first way is already discovered, we go the second way.
1. In your shared folder Create a file "WinCoreConfig.PS1", copy-pase following PowerShell script into that file and save it. In my case path to this file is: "L:\Temp\WinCore\Scripts\Config_Batch.PS1"
2. Start PowerShell. In CMD window on your newly installed VMrun following command:
You are supposed to get PowerShell blue screen:
3. Run the script from Network Shared folder. In my case command will be like this:
PS C:\> L:\Temp\WinCore\Scripts\Config_Batch.PS1
After command starts you might be disconnected.
Reconnect again and you are supposed to see following screen:
During the restart Windows will apply some changes and updates.
After machine will be up and running connect to it again and run "IPCONFIG" command:
In my case it is: "192.168.1.101"
Now you can disconnect from the Virtual Machine and create another Checkpoint named "After Configuration".
Step #5. Establish Remote Desktop connection.1. Start Remote Desktop on your local computer and connect to "192.168.1.101".
2, Use Username "CoreAdmin" and Password "LocalAdmin2016" (See earlier created file Config_Batch.PS1 for details)
If you did everything right you have to get connected:
Step #6. Establish PowerShell connection.1. On your local computer start PowerShell session.
2. run following set of command in PowerShell (Credits to http://www.howtogeek.com/117192/how-to-run-powershell-commands-on-remote-computers/) ON ONE BY ONE BASIS:
3. If test run successfully, you can try to connect to your VM via PowerShell:
> Enter-PSSession -ComputerName 192.168.1.101 -Credential CoreAdmin
After running that command you will be asked for a password:
The very last line indicates that you are successfully connected to your new VM Windows Core Server via PowerShell.
Step #7.Install SQL Server Engine.At first, go to your VM settings and redirect its DVD Drive to SQL Server installation image file:
Now you can create the lat Checkpoint called "Ready for SQL Server"