Skip to main content

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