How to install SqlServerCmdletSnapin100 and SqlServerProviderSnapin100 – guide

Help building this site use one of the Free Gifts

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

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



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 🙂

2 thoughts on “How to install SqlServerCmdletSnapin100 and SqlServerProviderSnapin100 – guide

  1. if u use sqlcmd in your scripts on PC without SQL Server installed, u need to install Microsoft® SQL Server® 2008 R2 Native Client and Microsoft® SQL Server® 2008 R2 Command Line Utilities too and probably add sqlcmd to PATH env. variable

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

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