Since last few days, I was planning to set up a new VM to run SQL Server 2012 RC0 on a server core machine. As SQL Server 2012 RC0 can be installed on a Server Core machine, I build a server core machine to test this new feature. The new VM had Windows Server 2008 Enterprise Server Core (Evaluation) edition installed on it, followed by the Service Pack 1.
In the past, I had used Core Configurator to configure my server core machines; however, this time I thought of using Sconfig.cmd. I am new to this tool, so thought of learning about it while configuring my own machine. To start this utility, type sconfig.cmd and press Enter. As I was new to this utility, I logged in with the Local Administrator account to configure this server.
Once you start the Sconfig utility, you will get the following screen with all the available options. As you can see from the below screen-shot, most of the options are self-explanatory and some has sub-menu for additional configuration. We will start with changing the server’s default name, press 2 to continue:
As we have configured the server name, its time to configure the Network Settings for this machine. Press 8 to configure the Network Settings. In this case, I am using a static IP Address along with the Subnet Mask, Default gateway. Once the IP address is set you will get the following screen:
Next we are going to configure the Date & Time setting for this server, for this, select the option 9 to continue. You will get the same familiar screen to set the date, time and timezone for the server. Click on OK to continue further:
As shown in the above screenshot, I have configured Windows PowerShell and Remote Server Management, which will help in managing this server remotely. Since all the necessary configuration are done, its time to add the server to the domain. To add the server to the domain, we have to select the option 1. Provide the domain name and authorized user account and the server is added to the domain. Since we have already rename the computer earlier, we are not going to change the server name once again. Once the server is restarted, log on to the server and verify the same. To restart the server, press 11 and to shut down the server, press 12.
As I am going to install SQL Server 2012 RC0 on this server, so I am going to add the DBA group as a member of the Local Administrator group on this server. To do that, we have to select the option 3 and provide the domain group name as shown below:
Since we have completed all the required configuration, its time to install SQL Server 2012 RC0. More on that later.