Hello, I have two servers with Windows 2008, they're standalone installation, there's no AD. One of them is running IIS (host1) and it's exposed to Internet. There's ASP.NET application with FORMS authentication. Also I own second server with SQL Server 2008 (host2). Recently I've added there Reporting Services (there's no IIS), with integrated authentication, but it could be changed. Can you help and write what do you think about my ideas? 1. I guess that I can use use "report viewer" to put reports into my web site. Do you know about possible problems or limitation? Can use scheduled report to email address with it? Do you see any possible problems with authentication? 2. Is it possible transfer authenticated in FORMS mode user, from my web site on host1 to SSRS on host2. I think that it could problem of "double-hop authentication"? This scenario if possible could be the best solution. 3. Is it possible to add pages to my website, and with web services off SSRS render reports or expose all functionalities? What do you think about that? Do you have any suggestion? Is there any difference for these point between SSRS 2005 and SSRS 2008 Thank you for all suggestions. Regards

Hello, I have two servers with Windows 2008, they're standalone installation, there's no AD. One of them is running IIS (host1) and it's exposed to Internet. There's ASP.NET application with FORMS authentication. Also I own second server with SQL Server 2008 (host2). Recently I've added there Reporting Services (there's no IIS), with integrated authentication, but it could be changed. Can you help and write what do you think about my ideas? 1. I guess that I can use use "report viewer" to put reports into my web site. Do you know about possible problems or limitation? Can use scheduled report to email address with it? Do you see any possible problems with authentication? 2. Is it possible transfer authenticated in FORMS mode user, from my web site on host1 to SSRS on host2. I think that it could problem of "double-hop authentication"? This scenario if possible could be the best solution. 3. Is it possible to add pages to my website, and with web services off SSRS render reports or expose all functionalities? What do you think about that? Do you have any suggestion? Is there any difference for these point between SSRS 2005 and SSRS 2008 Thank you for all suggestions. Regards I use SSRS 2008 on my website to generate pages dynamically. I use Forms Authentication on my website but SSRS 2008 uses Windows. Authentication Alexei Cioina

Hi Tszulczewski, 1. I guess that I can use use "report viewer" to put reports into my web site. Do you know about possible problems or limitation? Can use scheduled report to email address with it? Do you see any possible problems with authentication? Yes. We can use Report Viewer control to render the reports in the web site. The limitation is that we need to pass the credential from the web site to the report server explicit. We are still able to mail the reports using subscription. 2. Is it possible transfer authenticated in FORMS mode user, from my web site on host1 to SSRS on host2. I think that it could problem of "double-hop authentication"? This scenario if possible could be the best solution. There are no direct way to transfer credential from Forms Authentication to Windows Integrated Authentication. In this case, unless we implement customized security authentication for the report server, and in the code, handle the cookie manually to authenticate the report server. 3. Is it possible to add pages to my website, and with web services off SSRS render reports or expose all functionalities? Yes. It is possible. Please see Alexei's site for more information. There are some links for your reference, which will help you to understand this scenario: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/724182a8-e42a-4603-822c-3ff836845cdb http://www.codeproject.com/KB/reporting-services/SQLRSViewer.aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT