Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  PowerShell setup for SQL Server

Author  Topic  Mark H Starting Member 6 Posts Posted - 2011-05-06 : 11:35:49 I am using Windows XP, sp3 While I was loading SQL Server the 'CheckList' said I didn't have PowerShell. The SQL Server stops and lets me load in PowerShell. Loading in PowerShell instructions say it needs NET Framework 2.0. So I first did this; then I loaded in PowerShell and reran the SQL Server Checklist. The SQL Server Checklist now said I had loaded PowerShell. However, SQL Server installer, after spending hours, ultimately found three errors listed as: Database Engine Services SQL Server Replication Management Tools- Basic Which, of course, doesn't tell me what the problem is. Looking at the logs, the logs say I haven't loaded PowerShell. So I am hoping that if I could get SQL Server to admit PowerShell is there, maybe the three errors would go away. Who knows. So..... I find I should be able to erase PowerShell on Start/Control Panel/Add or Remove Programs. But oddly enough it is not listed on either the Change or Remove Programs or the form Add/Remove Windows Components. This is an indication that either I didn't load PowerShell or something happened during the installation. I also find there are two ways to start PowerShell. One is to click on Start/All Programs, and then click on PowerShell. However,it isn't in the list. One more indication I haven't actually loaded PowerShell. Another way to start it is to do Start/Run and then on the black, old fashioned MSDOS screen type PowerShell. This actually starts PowerShell. At least that is what I think happens because the starting line has a PS at the left margin. So the question is do I or don't I have PowerPoint loaded so SQL Server- when I run SQL Server setup again- will admit in its checklist that PowerShell is available? If something is screwed up with PowerShell so SQL Server setup doesn't recognize it, How do I get rid of PowerShell so I can reload it. Or Can I just reload PowerShell, now that I have .NET Framework 2.0 already loaded and it will correctly load itself so SQL Server will finally admit PowerShell is there for it to use. Keep in mind it is not on the add/remove programs list.