Jump to content


Recommended Posts

hi MrBigTed, thanks for the thanks :)

i'm not following exactly what you are saying, are you saying you've already setup azure ad connect and are also hybrid azure ad joined ?

Share this post


Link to post
Share on other sites

Hello,

When deploying self service portals, i got such error when running PS script.

Unable to export ConfigMgr SQL Server Identification Certificate: Unable to find tpye [X509Certificate].

But i got certificate etc.
 

Untitled.png

Edited by Eduards

Share this post


Link to post
Share on other sites

what command line did you use to install the portals ? if you specified -SqlInstanceName MSSQLSERVER then this error is expected...

if you are using the default instance then leave out that switch

Share this post


Link to post
Share on other sites

On 4/8/2020 at 9:29 AM, Eduards said:

Hello,

When deploying self service portals, i got such error when running PS script.

Unable to export ConfigMgr SQL Server Identification Certificate: Unable to find tpye [X509Certificate].

But i got certificate etc.
 

Untitled.png

I was able to fix the problem by editing the installer script. Just added a session variable to avoid the proxy.

https://social.technet.microsoft.com/Forums/en-US/1ff999c3-f8d2-4dd2-bd17-df9fc79b8ec2/1910-setting-up-mbam-issues?forum=ConfigMgrCBGeneral

 

function Get-CertificateFromSqlServer
{
    param(
        [Parameter(Mandatory=$true)]
        [string]$sqlServer
    )

    $option = New-PSSessionOption -ProxyAccessType NoProxyServer ### added fix for WinRm error

    [array]$encodedCerts = Invoke-Command -ComputerName $sqlServer -ScriptBlock { 
        Get-ChildItem -Path Cert:\LocalMachine\My | Where-Object { ($_.FriendlyName -eq "ConfigMgr SQL Server Identification Certificate") -and ($_.NotBefore -lt (Get-Date)) -and ($_.NotAfter -gt (Get-Date)) } | ForEach-Object {
            $bytes = $_.Export("cert"); 
            [Convert]::ToBase64String($bytes) 
        }
    } -SessionOption $option ### added fix for WinRm error

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.