sql server reporting services: I have a SQL server in which I installed Reporting Services. The Server also
hosts a couple of websites that are accessed over SSL like
'https://www.projectsite.com'. I have SQL reporting in the IIS root website.
How can I set up reporting services on each of these websites so that the
reports can be accessed like 'https://www.projectsite/com/reports'? Are
there some references discussing hosting SQL reporting? Thank you

Dan

Hi Dan,

It is by design that Reporting Services can only be installed to the
Default Web Site. However, some users have worked around this issue by
referring to the following article:

http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk

Please note that the method is not officially supported.

To enable SSL, please refer to the following article:

http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
/sslsetup.asp

Third-Party Link Disclaimer
===========
This response contains a reference to a third-party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.

Sincerely,

William Wang
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

This posting is provided "AS IS" with no warranties, and confers no rights.

I moved the Reports and ReportServer virtual directories from default to
'https:/www.projects.com' using the 'All Tasks/Save Configuration to file'
and creating the virtual directory using the configuration files. I also
made changes to the RSWebApplication.config file in ReportManager folder and
RSReportServer.config file in the ReportServer folder to reference the new
location 'https://www.projects.com'. I setup SSL to work the same as other
working virtual directories (and take care to spell the new location exactly
as I spelled it on the certificate for the server). In the
RSReportServer.config file I changed the <Add Key="SecureConnectionLevel"
value from 0 to 2. Now it works. Hope this information may be of use to
others. Dan

[quoted text, click to view]

I'm glad to hear that you've moved the virtual directories in a simpler
way. The virtual directories created by using the configuration files
should be same as the virtual directories mentioned in
http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk,
and we should still need to ensure that aspnet_client is in the root of the
new site.

Thanks for sharing this with us.

Sincerely,

William Wang
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

This posting is provided "AS IS" with no warranties, and confers no rights.

Another question: How to change the report folder. I created on in the
report manager and can't find the new report folder. I need to associate the
new folder to the reports folder in a .NET application using VS.NET.

Thanks.


[quoted text, click to view]

Hi Dan,

After you create a folder via Report Manager, can you see the folder there?
If not, is there any error message? If you can see the folder in Report
Manager, things are working correctly. In Reporting Services, the folders
you work with are virtual folders that are accessed over the Web. Neither
the folders nor their contents actually exist in a file system. Instead,
they exist in a report server, but they appear as folders and items when
you access the report server through a browser or a Web-enabled
application. To associate the folder, use the full path name of the folder,
e.g. /SampleReports.

Let me know if there is anything unclear.

Sincerely,

William Wang
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.