No SQL Server PowerShell snapin installed despite installing SQL Server No SQL Server PowerShell snapin installed despite installing SQL Server powershell powershell

No SQL Server PowerShell snapin installed despite installing SQL Server


In SQL Server 2012 the PowerShell functionality delivered by the product came in the form of a PowerShell module, so therefore you no longer need to work with the snapins.

To consume the SQL Server PowerShell module, you simply need to do this:

Import-Module "sqlps"

Or if you are using PowerShell v3+ then you just need to reference a member of that module and it'll be automatically loaded in.