How do I load Powershell module for SqlClone? Get...?

Robb_Keller

I'm trying to run a Powershell script to create a clone on my local machine.  I filled out the example Powershell script, but I think I need to load an assembly or something for this, something like [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null for SQL Server.  I'm getting a 'Connect-SQLClone' is not recognized as the name of a comdlet...

I have locally installed the SQL Clone agent and the Red Gate Data Masking stuff.  How do I run Powershell scripts locally?  Or, what needs to be loaded in the environment to run the script.  Otherwise, maybe I have the wrong server for where the clones are stored.

Thanks,
Robb

owen.hall

Hi Robb,

There's an installer available from your SQL Clone server UI that will install the PowerShell cmdlets you need. You can download it from:

http://your-sql-clone-server:14145/settings/powershell

If you run the installer, close any open PowerShell windows, then open one up again, the cmdlets should be available.

Hope that helps!

Owen

Robb_Keller

Perfec.  Thanks for the quick response!

Robb

Robb_Keller

Owen, or anyone.

Hey, one more time...  I'm trying to run the script to load Powershell commands and I'm an administrator on the VM.  I also ran explorer as an administroator and even disabled Enhanced Security Configuration, but still get 'Access denied, the user is not a member of the permitted Windows security group' message when I try to open the web interface for /settings/powershell.

Any ideas??
Thanks,
Robb

Mark R

Hi - do you have permissions enabled in SQL Clone?

Robb_Keller

Thanks Mark,
Turns out that Powershell needed to be set to unrestricted from remote access.  That and putting the websites in the trusted zone fixed everything.
Thanks for the help though,
Robb