Step-by-step procedure for Installing SQL Server 2012 on Windows Server 2008 R2 Server Core : PART 3

  • Article

In Step-by-step procedure for Installing SQL Server 2012 on Windows Server 2008 R2 Server Core : PART 2, we covered details about Add the machine to a domain, Add an administrator and Rename the Server. You can achieve all these specified tasks in a more simpler manner. Check the following for more details:

  1. At the command prompt, type the following command, and then press ENTER: sconfig
    • Capture
  2. This opens up the Server Configuration within the command prompt. You can choose between one of the options specified there:
    1. Domain/Workgroup
    2. Computer Name
    3. Add Local Administrator
    4. Configure Remote Management
      1. Allow MMC Remote Management
      2. Enable Windows PowerShell
      3. All Server Manager Remote Management
      4. Show Windows Firewall Settings
    5. Windows Update Settings
    6. Download and Install updates
    7. Remote Desktop
    8. Network Settings
    9. Date/Time Settings
    10. Log Off User
    11. Restart Server
    12. Shutdown Server
    13. Exit to Command Line
  3. For example, if you want to enable Server Manager Remote Management, do the following:
    1. At the command prompt, type 4 to select the Configure Remote Management option, and then press ENTER.
    2. Capture1
    3. At the command prompt, type 3 to select the Allow Server Manager Remote Management option, and then press ENTER.
    4. Connect to the remote server by using Server Manager.

We can use the same Server Configuration to view/update the Domain, Computer name, and also add a user to the Local Administrator Group.

Updating the above settings, we are now in a position to manage the Server Core machine remotely. In my next Part, I will include details about the following:

  • Installing SQL Server 2012 on Server Core
  • Configuring and managing SQL Server 2012 on a Server Core operating system.