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
source
share