SQLPS Module Empty

This forum can be browsed by the general public. Posting is limited to current SAPIEN license holders with active maintenance and does not offer a response time guarantee.
Forum rules
DO NOT POST SUBSCRIPTION NUMBERS, LICENSE KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
User avatar
MrFanciful
Posts: 36
Joined: Wed Aug 21, 2013 3:17 am

SQLPS Module Empty

Post by MrFanciful » Tue Apr 12, 2016 3:59 am

Product, version and build: PowerShell Studio 2016 5.2.119
32 or 64 bit version of product: 64 bit
Operating system: Windows 8.1 Ent
32 or 64 bit OS: 64 bit
PowerShell Version: 5

I'm required to create a script to automate the verifying SQL database backups. It's the first time I've been requiring the SQL module so far and so I don't know if this is a new problem or just one that I didn't notice before.

I have the SQL 2014 SSMS installed. Just the Management Studio, I don't have any other SQL component installed such as the Database Engine.

I have the SQLPS module installed under C:\Program Files\Microsoft SQL Server\120\Tools\PowerShell\Modules as shown in the screen shot and the output of Get-Module -ListAvailable

However in the Object Browser the module appears empty and when I import the module that is there, it doesn't provide any CmdLets.

I've tried installing the PS pack SQL2014 Feaature Pack but that's been unsuccessful too. Ive also looked through all combinations of V2, V4 and V5 and 32bit and 64bit modules.

Any help would be greatly appreciated.
SQL CmdLets.PNG
SQL CmdLets.PNG (34.51 KiB) Viewed 816 times
SQLPS Module.png
SQLPS Module.png (52.94 KiB) Viewed 816 times
Attachments
CachedData 2016.zip
(1001.75 KiB) Downloaded 49 times

User avatar
davidc
Posts: 5913
Joined: Thu Aug 18, 2011 4:56 am

Re: SQLPS Module Empty

Post by davidc » Tue Apr 12, 2016 9:04 am

We are investigating the issue.

Note: As a premium support user you can access the premium support ticketing system via the website menu: Support->Premium Support.

Thank you,

David
David
SAPIEN Technologies, Inc.

User avatar
davidc
Posts: 5913
Joined: Thu Aug 18, 2011 4:56 am

Re: SQLPS Module Empty

Post by davidc » Tue Apr 12, 2016 9:22 am

We are going to email you instructions and a link to a script and that should help generate the necessary cache files. If there are any errors please let us know.

David
David
SAPIEN Technologies, Inc.