SQL Server 2008 Features Require PowerShell

(extracted from ReadmeSQL2008.htm)

SQL Server 2008 Setup installs PowerShell 1.0, which is used by the following SQL Server 2008 PowerShell features: the sqlps.exe utility; SQL Server Management Studio Object Explorer right-click menus that launch SQL Server PowerShell scripts; and creating or running scheduled SQL Server Agent PowerShell job steps. If PowerShell is uninstalled after Setup completes, these features will not function. PowerShell can be uninstalled by Windows users, and uninstalling PowerShell may be required by some Windows operating system upgrades. If PowerShell has been uninstalled and you wish to use the SQL Server PowerShell features, you must either:

  • Manually download and reinstall PowerShell 1.0 from the Microsoft Download Center. Download instructions are on the Windows Server 2003 Web site.
  • If you are running Windows Server 2008, PowerShell 1.0 exists in the operating system but is disabled by default. You can re-enable PowerShell from Windows Server 2008.

Note: You can’t use Powershell CTP V2 with SQL Server 2008. On Windows Servers 2008, you can install Powershell v1 after installing SQL Server 2008 CTP Feb2008.

Other Microsoft Applications using Powershell:

1. Microsoft Exchange

2. Microsoft System Virtual Machine Manager Center


About maxt2posh

I’m from Puerto Rico, have been working with computers since 1979. Throughout many years, I have worked with SQL Server Technologies, provided support to Windows Servers/Client machines, Microsoft Virtualization Technologies, and build some Visual Studio solutions. I’m a Microsoft PowerShell MVP since 2009 and MVP SAPIEN Technologies since 2010. I speak in most of the SQLSaturday, IT Pro and .NET camps events around the Florida’s State. Also founder of the Florida PowerShell User Group which meeting every 3rd Tuesday evening of the month.
This entry was posted in PowerShell. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s