I am using windows server 2008 R2. Update It appears that the powershell is in fact accepting input, except at a glacial speed. I left the window open while I was writing this post initially, and then grabbed a coffee. Upon my return I found that what I have tried to copy/paste and type was now in the powershell command line. Dec 19, 2011 - As we all know, Microsoft has announced support to run SQL Server on Windows Server 2008 R2 Server Core Edition which is GUI-less OS.
By: Last Updated: 2011-12-19 Related Tips: Problem As we all know, Microsoft has announced support to run SQL Server on Windows Server 2008 R2 Server Core Edition which is GUI-less OS. In this tip I will explain the step by 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. However Windows PowerShell 2.0 is an installation prerequisite. If SQL Server setup reports that Windows PowerShell 2.0 is not present, you 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 command prompt to find out if PowerShell is enabled or not. If PowerShell is enabled it will route you to the PS root directory.
If PowerShell is not installed/enabled then Windows will not recognized this command. As you can see in above screenshot, PowerShell is not enabled on this machine so our next step will 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 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 Core installation. You must be a member of the Administrators group to use the tool. Post a comment or let the author know this tip helped. All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (.).Name.Email Email me updates.
![Powershell Powershell](http://vsysad-1498.kxcdn.com/wp-content/uploads/2015/01/20150101004551.jpg)
NOTE. If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting. Signup for our newsletter I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the and understand I may unsubscribe at any time.