How To Use Powershell In Windows Server 2008 R2

Enable PowerShell on Windows Server 2008 R2 Core Edition

Past: | Updated: 2011-12-19 | Comments (3) | Related: More > PowerShell

Problem

As we all know, Microsoft has announced support to run SQL Server on Windows Server 2008 R2 Server Cadre Edition which is GUI-less Os. In this tip I will explicate the step past step process to install and enable PowerShell on a Windows 2008 R2 Server Core. PowerShell is basic prerequisite to install SQL Server on Windows Server 2008 R2 Server Core Edition. Check out this tip to get started with the PowerShell installation.

Solution

Based on the current build of Microsoft SQL Server 2012, it does not install or enable Windows PowerShell. Still Windows PowerShell 2.0 is an installation prerequisite. If SQL Server setup reports that Windows PowerShell 2.0 is not nowadays, y'all tin can install or enable it by below instructions on Windows Server 2008 R2 Server Core Edition.

Steps to enable PowerShell

Step 1 - Type "powershell" at the control prompt to notice out if PowerShell is enabled or not. If PowerShell is enabled it will road you lot to the PS root directory. If PowerShell is not installed/enabled then Windows volition not recognized this command.

CheckingPSenableORnot

Equally you can see in above screenshot, PowerShell is not enabled on this machine so our next footstep volition be to enable it.

Step 2 - Run the "sconfig.cmd" command on your command prompt and press enter. Once you will press enter, it will open up all of the options of system configuration as shown in the image below. The "sconfig.cmd" command is the Server Configuration Tool to configure and manage several common aspects of the Windows Server 2008 R2 Server Cadre installation. You must be a member of the Administrators group to utilize the tool.

sconfig cmd

You will exist prompted to enter the number for the application which you desire to configure. In our circumstances we volition choose "four (Configure Remote Management)" in order to enable PowerShell.

Step 3 - In one case y'all have pressed "4" then press enter to see all of the options under the "Configure Remote Management" interface.

Option4forPS

As yous can see there are 5 options to cull from. The second choice is for PowerShell. Choose option 2 in order to "Enable Windows PowerShell".

Footstep iv - After you blazon "2" and press enter, the PowerShell configuration volition start and the configuration process will await similar the below screenshot.

Option2forEnablingPS

Step 5 - One time PowerShell has been successfully enabled, a separate control prompt screen will be pop-upward and closed after the process reaches 100% completion. This is the deployment of features using the Dism.exe (Deployment Image Servicing and Management) tool. DISM enumerates, installs, uninstalls, configures and updates the features and packages in Windows images. See the screenshot beneath.

inProcess final

Pace 6 - Later on all of the processes accept completed, a restart window will appear and ask you to restart the machine in order for all of the changes to be committed. Click the "Yes" button to restart the car.

Restart

Step 7 - In one case the has been rebooted, type "powershell" on the control prompt. This time it volition take few seconds to load then route you to a PS control prompt. You can run the "Get-Host" cmdlet to check the PowerShell version as shown in the screenshot beneath.

CheckPSconfigured

Next Steps

At this indicate in fourth dimension, you can go on with your SQL Server installation. You tin also enable PowerShell remoting which is a great characteristic of PowerShell ii.0 to manage your servers remotely from your local motorcar.
Continue learning about PowerShell.

Popular Manufactures

About the author

MSSQLTips author Manvendra Singh Manvendra Singh has over 5 years of experience with SQL Server and has focused on Database Mirroring, Replication, Log Aircraft, etc.