Unix Technical Forum

Configuring SQL Reporting Services for SSL

This is a discussion on Configuring SQL Reporting Services for SSL within the SQL Server forums, part of the Microsoft SQL Server category; --> I've got an issue that is perhaps a bit different than any other related posting on this topic. I ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-01-2008, 02:41 PM
scottdistefano@gmail.com
 
Posts: n/a
Default Configuring SQL Reporting Services for SSL

I've got an issue that is perhaps a bit different than any other
related posting on this topic.

I have successfully installed and configured SSRS for SQL 2005 and
now
I'm at the step where I need to require SSL. So I opened the
Reporting Services Configuration, then selected Report Server Virtual
Directory. Then I select the checkbox Require Secure Socket Layer
(SSL) connections. At this step I am required to enter the name of
the certificate. Here is the problem: The server in on 2 seemingly
different domains and the certificate was issued to domain A, but the
server name is listed under domain B, but both domains resolve to the
same IP address. Here are the specifics:

A) The cert was named according to this domain pattern:
<server_name>.orgA.domainA.com
B) The computer name in system properties is:
<server_name>.orgB.xx.domainB.com

When I run the report server web interface, I get this error "The
request failed with HTTP status 401: Unauthorized."

So my question is: Why isn't the certificate for Domain A working?
Should I request a certificate under the domain of option B above? Is
there a configuration that is required? Note - I've modified the
file
rsreportserver.config per the installation instructions.

Thanks in advance for your assistance,
-Scott

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 01:16 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com