At SQL Saturday Melbourne, an otherwise excellent event, my demo failed on me because the DBAtools module failed to load with the following error:
Set-WSManQuickConfig : <f:WSManFault xmlns:f=”http://schemas.microsoft.com/wbem/wsman/1/wsmanfault”
Code=”2150859113″ Machine=”localhost”><f:Message><f:ProviderFault provider=”Config provider”
path=”%systemroot%\system32\WsmSvc.dll”><f:WSManFault
xmlns:f=”http://schemas.microsoft.com/wbem/wsman/1/wsmanfault” Code=”2150859113″
Machine=”<machinename>”><f:Message>WinRM firewall exception will not work since one of the
network connection types on this machine is set to Public. Change the network connection type to either Domain
or Private and try again. </f:Message></f:WSManFault></f:ProviderFault></f:Message></f:WSManFault>
At line:116 char:17
+ Set-WSManQuickConfig -force
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [Set-WSManQuickConfig], InvalidOperationException
+ FullyQualifiedErrorId : WsManError,Microsoft.WSMan.Management.SetWSManQuickConfigCommand
For a piece of code that had run successfully a dozen times this was of course a VERY annoying error, not least because I set it to run in another window and carried on with my talk, so didn’t really have time to either troubleshoot it or re-run it once I was back. I had initially believed the problem was due to an earlier deviation I had made from the order I was going to do things and therefore related to execution policy. But I hadn’t even read the error message properly during the demo because I just wanted to curl up in a corner and cry.
But running it again later I remembered the other change that I had made to my laptop from every other time I had run the code. I had adjusted my network settings from a static IP address to allow me to connect to the university wireless. That was a dumb rookie mistake, and I really had no excuse having not re-run my code in the new environment. My session was right after lunch, so I had all lunchtime to step through my code, and had done so with everything but the particular script that failed. Lesson learnt the hard way I guess. Speakers be warned.
Anyway, the error is obviously related to the change in wireless settings. I was quickly pointed in the correct direction by this post from Matt Wrock who provides the powershell commands needed to set all your network connections to private:
$networkListManager = [Activator]::CreateInstance([Type]::GetTypeFromCLSID([Guid]"{DCB00C01-570F-4A9B-8D69-199FDBA5723B}"))
$connections = $networkListManager.GetNetworkConnections()
# Set network location to Private for all networks
$connections | % {$_.GetNetwork().SetCategory(1)}
As the article referenced above explain the implications and manual process better than I could I won’t add additional junk to the internet, except to say that the failure of the import of the DBA tools module appears to be due to a failure of Set-WSManQuickConfig in the PS-Remoting module. Also not that making your networks private actually has less security associated with it than having them “Public” which is a bit counter intuitive. A “Public” network setting means you are on a public network, don’t trust it so security is high, whereas a private network means you trust the network and are prepared to let traffic do a few extra things – like ps-remoting for instance….ahem.
This is the first session which has been so heavily reliant on demo code, normally I do a lot of speaking from a slide deck. The turnout was really good, but I felt my presentation in general was pretty poor. It’s much easier to deviate from what you planned when you are talking from a slide deck, because the slide deck brings you back to the intended presentation. When you are just typing code into a powershell console and someone asks you a question that takes you away on a tangent it’s harder to come back on topic. In general I think the presentation went a little bit all over the place, which is exactly what people don’t need when they are trying to grasp the fundamentals of using a programming language. The structure I had in place was good, but my execution on the day was poor. So apologies to the audience on the day, but hopefully the core message of the usefullness of powershell still got through. You can run through my demo scripts by downloading them from the SQL Saturday site at: http://www.sqlsaturday.com/582/Sessions/Schedule.aspx