How to install SqlServerCmdletSnapin100 and SqlServerProviderSnapin100 – guide

How to Install Missing PowerShell Snap ins when you get

Add-PSSnapin : No spans-ins have been registered for Windows Powershell Version

Check if PSSnapin are already installed

get-PSSnapin –registered

If empty, then follow the process below.

Open up the following sites and download the following

https://www.microsoft.com/en-us/download/details.aspx?id=16978

Make sure you are downloading 64bit version for 64-bit powershell version

Microsoft® System CLR Types for SQL Server® 2008 R2

X64 Package (SQLSysClrTypes.msi)

Microsoft® Windows PowerShell Extensions for SQL Server® 2008 R2

X64 Package (PowerShellTools.msi)

Microsoft® SQL Server® 2008 R2 Shared Management Objects

X64 Package (SharedManagementObjects.msi)

Once installed

Check this location for files

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\Redist

Or here

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\

You need to find the following files

Microsoft.SqlServer.Management.PSProvider.dll

Microsoft.SqlServer.Management.PSSnapins.dll

 

Very important for 64bit version use 64 bit version of framework.

Issue the following to check which version of framework your powershell is running

 

PS S:\> [environment]::version

 

Major  Minor  Build  Revision

—–  —–  —–  ——–

4      0      30319  42000

 

You need to point to v4 of framework or version v2 depends on your result and to a correct bit version!

The below is for .Net 2.0 Version

For 32bit use

set-alias installutil C:\Windows\Microsoft.NET\Framework\v2.0.50727\InstallUtil

for 64 bit use

set-alias installutil C:\Windows\Microsoft.NET\Framework64\v2.0.50727\InstallUtil

In this case my version of .net is 4 so I need to use the following

set-alias installutil C:\Windows\Microsoft.NET\Framework64\v4.0.30319\InstallUtil

then to the following

installutil -i “c:\Program Files\Microsoft SQL Server\100\Tools\Binn\Redist\Microsoft.SqlServer.Management.PSProvider.dll”

installutil -i “c:\Program Files\Microsoft SQL Server\100\Tools\Binn\Redist\Microsoft.SqlServer.Management.PSSnapins.dll”

 

If it does not install for any reason then make sure that your installutil point to the correct 32/64 bit version and to the correct framework. If this is not correct your installation will fail

Then issue the following

Add-PSSnapin SqlServerCmdletSnapin100

Add-PSSnapin SqlServerProviderSnapin100

And check

get-PSSnapin –registered

Name        : SqlServerCmdletSnapin100

PSVersion   : 2.0

Description : This is a PowerShell snap-in that includes various SQL Server cmdlets.

 

Name        : SqlServerProviderSnapin100

PSVersion   : 2.0

Description : SQL Server Provider

Any issues please let me know 🙂

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s