Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 SSL-Problem with Connection to OWC "HTTPS Secure"		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sefer

Germany
105 Posts
Posted - 07/13/2006 :  07:37:44  Show Profile  Reply with Quote
Hi,

RP 118
SQL Server 2005
Selfsigned SSL-certificate is installed by SQL-Server automatically.

I am not able to connect to a OWC Report over "https secure"(SSL).
If i try to open fom local machine it works, but not over internet.I get a connection error.
Connection over http Secure doesnt work too.

If i delete the certificate, i am able to connect over http secure!

Any hints, how to connect to OWC over "https Secure (SSL)?

thx Sefer

admin

1645 Posts
Posted - 07/13/2006 :  15:51:32  Show Profile  Reply with Quote
Please try Free SSL Trial Certificate from VeriSign:

http://www.verisign.com/
Go to Top of Page

sefer

Germany
105 Posts
Posted - 07/15/2006 :  09:34:03  Show Profile  Reply with Quote
Thank you very much,

the problem is, that the root ca have to be installed in Internet Explorer.
If somebody installs a selfsigned certificate, there is no CA ROOT for IE.

Summary:
1.IIS-->CSR Request
2.VERISIGN-->Copy CSR to versign
3.Get Email from Verisign which includes the Certificate
CERTIFICATE:

-----BEGIN CERTIFICATE-----
MIAGCSqGSIb3DQEHAqCAMIACAQExADALBgkqhkiG9w0BBwGggDCCBWYwggROoAMC
...
VQTYAAAxAAAAAAAAAA==
-----END CERTIFICATE-----

4.Install on CLIENT the ROOT CA
4.1 ROOT CA:[code]
-----BEGIN CERTIFICATE-----
MIICmDCCAgECECCol67bggLewTagTia9h3MwDQYJKoZIhvcNAQECBQAwgYwxCzAJ
....
B8VmR+PZx2k24UgWUZyojDGxJtiHd3tjCdqFgTit4NK429cWOcZrh47xeOI=
-----END CERTIFICATE-----[/code]
4.2[code]
Installation Instructions
For Microsoft Browsers

4.2.1. Click on the “Secure Site Trial Root Certificate” link above.
4.2.2. Save the certificate into a file with a .cer extension.
4.2.3. Open a Microsoft IE Browser.
4.2.4. Go to Tools > Internet Options > Content > Certificates
4.2.5. Click Import. A certificate manager Import Wizard will appear. Click Next.
4.2.6. Browse to the location of the recently stored root (done in step 2). Select ALL files for file type.
4.2.7. Select the certificate and click Open.
4.2.8. Click Next.
4.2.9. Select “Automatically select the certificate store based on the type of the certificate”. Click Ok.
4.2.10. Click Next then Finish.
4.2.11. When prompted and asked if you wish to add the following certificate to the root store, click Yes.[/code]

5.IIS-->INSTALL Certificate from Email (3.)

thats all!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page