How can we help you today? How can we help you today?

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

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
Robb_Keller
0

Comments

5 comments

Sort by
  • 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
    owen.hall
    0
  • Robb_Keller
    Perfec.  Thanks for the quick response!

    Robb
    Robb_Keller
    0
  • 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
    Robb_Keller
    0
  • Mark R
    Hi - do you have permissions enabled in SQL Clone?
    Mark R
    0
  • 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
    Robb_Keller
    0

Add comment

Please sign in to leave a comment.