2 thoughts on “SQL Server Alias management with PowerShell and WMI – Update for SQL Server 2012”

1. Love the script, by the way.
   Small tweak needed – using Server 2008r2 and SQL 2008r2 64 bit, was getting “Invalid namespace” errors when connectint calls “$s.connect()”. I think you need to try calling connect in your try/catch waterfall to figure out SQL version. e.g.

   try {
   $s = New-Object System.Management.ManagementScope(“\\.\root\microsoft\sqlserver\computermanagement11”, $cnnOpt)
   $s.connect()
   } catch {
   try {
   $s = New-Object System.Management.ManagementScope(“\\.\root\microsoft\sqlserver\computermanagement10”, $cnnOpt)
   $s.connect()
   } catch {
   $s = New-Object System.Management.ManagementScope(“\\.\root\microsoft\sqlserver\computermanagement”, $cnnOpt)
   $s.connect()
   }
   }

   Reply ↓

2. I can confirm on a server with SQL2005 and SQL2008R2, the changes mentioned by Gavin Jones are required to get success, but the addition of the $s.Connect in each of the blocks (two try and one catch) does the trick quite nicely.

   Reply ↓

This site uses Akismet to reduce spam. Learn how your comment data is processed.