Posts

Showing posts from June, 2015

PowerShell SQL Snapins

Ran into an issue with SQL snapins not registering in PS x86 (needed to run ADMT related scripts). The following resolved the issue.


Start PowerShell x86 (important - run as Administrator) execute the following sequence:
cd "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn"
$framework=$([System.Runtime.InteropServices.RuntimeEnvironment]::GetRuntimeDirectory())
Set-Alias installutil "$($framework)installutil.exe"

installutil Microsoft.SqlServer.Management.PSSnapins.dll
installutil Microsoft.SqlServer.Management.PSProvider.dll

Add-PSSnapin SqlServerCmdletSnapin100
Add-PSSnapin SqlServerProviderSnapin100



To verify that snapins registered correctly examine the output of the following command:
get-pssnapin -registered