HI, My requirement is to configure the SQL SSRS through silently (without UI). I need to configure for https. To configure https i need to have the SSL certificate. how to generate the self signed certificate through command line? or how to obtain the certificate from the domain controller in the command line. After obtaining the certificate (self signed / DC cert) how to configure them in the command line.

As per configuring SSRS through command prompt, you can use rs and rsconfig utility, check this: http://msdn.microsoft.com/en-us/library/ms162837.aspx, http://msdn.microsoft.com/en-us/library/bb522796.aspx For more information about creating a SSL certificate for a server, check the Obtaining section in the topic: http://msdn.microsoft.com/en-us/library/ms186362.aspx <Configuring Certificate for Use by SSL> Chaitanya( Twitter | Blogs ) Any documentation bug? Tell us about it at Connect. Please feel free to add any community comments in any of the MSDN/technet articles. This posting is provided "AS IS" with no warranties, and confers no rights.

i dont think that utility will help me. i need to create the certificate. bind it with report server and web service url. I have tried to do the same with powershell script. but i am facing errors if possible plz help. function Config-SSRSSystemConfiguration($sslUrl, $certHash, $sslPort) { Write-Output "Configure SSRS SSL binding" $serverClass = get-wmiobject -namespace "root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\Admin" -class "MSReportServer_ConfigurationSetting" if ($serverClass -eq $null) { throw "Cannot find wmi class" } $lcid = [System.Globalization.CultureInfo]::GetCultureInfo("pt-PT").LCID $result = $serverClass.RemoveURL("ReportServerWebService", $sslUrl, $lcid) if (!($result.HRESULT -eq 0)) { write-error $result.Error } $result = $serverClass.ReserveURL("ReportServerWebService", $sslUrl, $lcid) if (!($result.HRESULT -eq 0)) { write-error $result.Error } $result = $serverClass.RemoveSSLCertificateBindings("ReportServerWebService", $certHash, "0.0.0.0", $sslPort, $lcid) if (!($result.HRESULT -eq 0)) { write-error $result.Error } $result = $serverClass.CreateSSLCertificateBinding("ReportServerWebService", $certHash, "0.0.0.0", $sslPort, $lcid) if (!($result.HRESULT -eq 0)) { write-error $result.Error } $result = $serverClass.RemoveURL("ReportManager", $sslUrl, $lcid) if (!($result.HRESULT -eq 0)) { write-error $result.Error } $result = $serverClass.ReserveURL("ReportManager", $sslUrl, $lcid) if (!($result.HRESULT -eq 0)) { write-error $result.Error } $result = $serverClass.RemoveSSLCertificateBindings("ReportManager", $certHash, "0.0.0.0", $sslPort, $lcid) if (!($result.HRESULT -eq 0)) { write-error $result.Error } $result = $serverClass.CreateSSLCertificateBinding("ReportManager", $certHash, "0.0.0.0", $sslPort, $lcid) if (!($result.HRESULT -eq 0)) { write-error $result.Error } } $cn = $env:computername $getCert = Get-ChildItem -Recurse Cert: | Where-Object {$_.FriendlyName -eq "selfgenerated"} $certHash = $getCert.Thumbprint Config-SSRSSystemConfiguration "https://$($cn):443" $certHash 443 ------------------------------------------------------------------------------------------------------------------- I facing the below errors PS C:\Users> C:\Users\Administrator\Desktop\sslbinding.ps1 Configure SSRS SSL binding Config-SSRSSystemConfiguration : A Secure Sockets Layer (SSL) certificate is not configured on the Web site. At C:\Users\Administrator\Desktop\sslbinding.ps1:55 char:31 + Config-SSRSSystemConfiguration <<<< "https://$($cn):443" $certHash 443 + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Config-SSRSSystemConfiguration Config-SSRSSystemConfiguration : A Secure Sockets Layer (SSL) certificate is not configured on the Web site. At C:\Users\Administrator\Desktop\sslbinding.ps1:55 char:31 + Config-SSRSSystemConfiguration <<<< "https://$($cn):443" $certHash 443 + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Config-SSRSSystemConfiguration