June 21, 2012 at 7:32 am
Comments posted to this topic are about the item Stairway to SQL PowerShell Level 2: SQL PowerShell Setup and Config
August 8, 2012 at 9:09 am
Very informative articles. Thank you for sharing!
There is a minor error that threw me for a bit of a loop. In listing 2.3, you mention the code to load the Extended SMO assembly is:
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo.Extended")
This did not work for me. I read a bit further, and noticed in Listing 2.4, the code is this:
[System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SqlServer.SmoExtended”)
Listing 2.3 has an extra period between "Smo" and "Extended". Removing it allowed me to get the desired output.
August 8, 2012 at 9:15 am
Thanks. I will submit a change.
August 13, 2012 at 8:18 am
Great set of articles. I am really enjoying working through them.
Is it just me or are these articles from the future?!?!? Level 2 is dated the 15th Aug 2012 and Level 3 is dated the 29th!
August 14, 2012 at 8:53 am
Someone got their hands on a delorean.
August 15, 2012 at 9:54 am
I think it just means that I am a really good author 🙂
August 16, 2012 at 7:45 am
Hello guys!!! The article is very good. I have little to no understanding on the subject of PowerShell. I would like begining to learn the ropes. However, I can not find the PowerShell folder in my Programs Menu. I have Windows XP SP3 installed, and I am running with a non-administrator user. Can you help me in any way ?
Thanks in advance.
Regards.
Ariel.
August 16, 2012 at 9:03 am
Ariel, if you go to the previous Level in this stairway you will see where you can get PowerShell for WinXP SP3. In the table there it shows that there is no native PowerShell in WinXP, so use the link in the Level 1 to go and get it and install it.
Then you can go to the Level 2 and start to play.
http://www.sqlservercentral.com/articles/Stairway+Series/90381/
August 17, 2012 at 4:23 am
I read the Level 1 part, and I understood that PowerShell does not install nativelly in Windows XP. But my Windows XP box has Microsoft SQL Server 2008 R2 installed. For it to be installed one of the requirements is PowerShell 2.0, so I had to install it first. Could it be that the installer does not put a shortcut to the program in the Menu Folder ? Am I missing something else ?
Thanks for the very fast answer.
Regards.
Ariel.
August 17, 2012 at 5:20 am
Ariel,
It's under Start/All Programs/Accessories/Windows PowerShell
I have SS2008 Express and don't seem to recall that PS 2.0 was needed for the installation.
I installed PS 2.0 using the download shown in the Level 1 article.
August 17, 2012 at 5:54 am
Ben,
Exactly what kind of syntax is this SQLSERVER:\SQL\localhost\default?
I can understand that in place of 'localhost' you can put the computer name and in place of 'default' you can put the instance name. But what exactly is the 'SQLSERVER:\SQL' part? How can it vary?
This even works pointed to a SS 2005 and SS 2000 installation. Neat!
And I discovered the right click by pure chance which is the equivalent of PASTE. Neat!
August 21, 2012 at 2:43 pm
I really appreciated the article. It took me a little bit to get the last few examples to work, but it was only because I was using "localhost" rather than my machine's name/instance. Once I got that sorted, I had success with all of it. I look forward to future steps.
August 21, 2012 at 2:47 pm
SQLSERVER:\SQL is a PSDrive and path.
If you use Get-PSDrive you will see that there is a SQLSERVER: drive and SQL is a path under SQL Server.
You can see which paths you have access to in the drive by using:
cd SQLSERVER:
dir
You will see that SQL is the path for the SQL database engine, and there are more.
August 26, 2012 at 6:59 am
Hi all, I'm having a little bit of a problem with one of the command lines erroring out and I am not sure why. When I try:
"$server = Get-Item SQLSERVER:\SQL\localhost\default"
I get several lines of the same error:
"WARNING: Could not obtain SQL Server Service information. An attempt to connect
to WMI on 'localhost' failed with the following error: An exception occurred
in SMO while trying to manage a service. --> Failed to retrieve data for this"
Any clue why? Any help appreciated. P.S. When I try using the SMO, instead of using the provider, all is fine and dandy.
TIA,
Raphael
August 26, 2012 at 7:11 am
This is due to not having Administrative privileges on the machine you are going against. So on the remote machine you have to be able do administrative things so being in the BUILTIN\Administrators group. And on the local machine, the Powershell window being run in Adminstrator Mode (right click and choose Run As Administrator).
Let me know if that does not help, but I have seen that error message because of these issues.
Viewing 15 posts - 1 through 15 (of 32 total)
You must be logged in to reply to this topic. Login to reply