Missing SQL Server PowerShell snap-in despite SQL Server installation

I am using SQL Server 2012 SP1 Developer Edition. Recently, I had to use snapin SQL Server, but PowerShell claims to not have it. I did research on the Internet, but I did not find any working solution. Is there a way to add it to PowerShell?

get-pssnapin -registered conclusion:

Name : CommonSnapIn          PSVersion : 2.0 Description : Common SnapIn
Name : ConfigurationSnapIn   PSVersion : 2.0 Description : Configuration SnapIn
Name : DefinitionSnapIn      PSVersion : 2.0 Description : Definition SnapIn
Name : DynoPortalSnapIn      PSVersion : 2.0 Description : DynoPortal SnapIn
Name : FoldersSnapIn         PSVersion : 2.0 Description : Folders SnapIn
Name : JournalSnapIn         PSVersion : 2.0 Description : Journal SnapIn
Name : MembershipSnapIn      PSVersion : 2.0 Description : Membership SnapIn
Name : MetadataSnapIn        PSVersion : 2.0 Description : Metadata SnapIn
Name : NotificationSnapIn    PSVersion : 2.0 Description : Notification SnapIn
Name : PersistenceSnapIn     PSVersion : 2.0 Description : Foundation Persistence SnapIn
Name : ReportingSnapIn       PSVersion : 2.0 Description : Reporting SnapIn

add-PSSnapin sqlservercmdletsnapin100 conclusion:

PS C:\Users\CRDM and Secure 3> add-PSSnapin sqlservercmdletsnapin100
add-PSSnapin : The Windows PowerShell snap-in 'sqlservercmdletsnapin100' is not installed on this computer.    
At line:1 char:1  
+ add-PSSnapin sqlservercmdletsnapin100  
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~  
+ CategoryInfo          : InvalidArgument: (sqlservercmdletsnapin100:String) [Add-PSSnapin], PSArgumentException  
+ FullyQualifiedErrorId : AddPSSnapInRead,Microsoft.PowerShell.Commands.AddPSSnapinCommand
+4
source share
1 answer

In SQL Server 2012, the PowerShell functionality provided by the product appeared as a PowerShell module, so you no longer need to work with snapins.

To use the SQL Server PowerShell module, you just need to do this:

Import-Module "sqlps"

, PowerShell v3 +, , .

+5

Source: https://habr.com/ru/post/1599117/


All Articles