Intergrity of forms and windows Auth

i Have an ASP.NET Application with forms authentication which uses sql
reporting for report purpose ,but report server works on windows
authentication ,due to which dialog box is popping up,i need to know a way of
integratinf the two to have a single sign on Process?Rags,
You have two options:
1. Generating the report on the server side of the application by using the
Render SOAP API. The advantage of this approach is that it is more secure
since the user doesn't see the report URL (everything takes place on the
server). The tradeoff is that the interactive features (drilldown,
drillthrough, etc.) will not work with SOAP since their require direct
access to the Report Server by URL. If you decide to take this approach, you
can pass the web app identity to the Report Server and grant a minimum set
of permissions in RS to this account.
2. Replace the RS Windows security with Forms Authentication by writing a
custom security extension. This will allow you to incorporate interactive
features in your reports. In this scenario, the reports will be requested on
the client side of the application (e.g. by using the Report Viewer sample
control). If you decide to take this approach check out the sample security
extension from MS at
(http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.a
sp?frame=true#ufairs_topic3).
So, you have to carefully weight out your requirements for security,
reporting features and your application architecture to determine the best
integration scenario.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Rags Iyer" <RagsIyer@.discussions.microsoft.com> wrote in message
news:0066D811-7499-4FFD-BB70-D97D8051D1F5@.microsoft.com...
> i Have an ASP.NET Application with forms authentication which uses sql
> reporting for report purpose ,but report server works on windows
> authentication ,due to which dialog box is popping up,i need to know a way
of
> integratinf the two to have a single sign on Process?

Integration Services in SSMS

We use Windows Authentication to connect to SQL Server, is there any special permissions required to connect to Integration Services in SSMS?

Whenever I try to browse the servers available with Integration Services (from Object Browser), none of the servers gets listed. If I directly give server name and try to connect to Integeration Services I get the following error. But I'm able to connect to the database engine.

TITLE: Connect to Server

Cannot connect to <servername>.

ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Connect to SSIS Service on machine "<servername>" failed:
Access is denied.

Connect to SSIS Service on machine "<servername>" failed:
Access is denied.

Thanks

Have you searched this forum or the Internet?

A well documented issue exists. Make sure you follow:

http://www.ssistalk.com/2007/04/13/ssis-access-is-denied-when-connection-to-remote-ssis-service/|||I think I went through those threads, forgive me for my ignorance, these steps of DCOM configuration needs to be done on the server where SSIS is running? since the final step says restart Integeration Services, I assume this needs to be done at the server.

Thanks
|||

Karunakaran wrote:

I think I went through those threads, forgive me for my ignorance, these steps of DCOM configuration needs to be done on the server where SSIS is running? since the final step says restart Integeration Services, I assume this needs to be done at the server.

Thanks

Correct. This is all on the server.

Integrating RS with Active Directory

Just like out of the box windows authentication and authorization is supported, has anyone integrated reporting services with Active Directory or at least point me to the correct resource?

Thanks.

Hi there,

Here's a link.

http://blogs.msdn.com/lukaszp/archive/2005/10/10/479273.aspx

cheers,

Andrew

integrated windows authentication

Hello,
In my report application, I had to remove anonymous
authentication and set integrated windows authentication
in IIS manager, in this case,
http://localhost/ReportServer?%2fReport+Project1%
2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-9098-
4b71-8511-c7e08926c50a
works fine, but in the same computer,
http://myserverName/ReportServer?%2fReport+Project1%
2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-9098-
4b71-8511-c7e08926c50a
asks me use id and password when I use myServerName
instead of localhost. Wow can I get windows authentication
works without asking username password?
Thanks,
Jim.Hi Jim,
JIM.H. wrote:
> http://localhost/ReportServer?%2fReport+Project1%
> 2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-9098-
> 4b71-8511-c7e08926c50a
> works fine, but in the same computer,
> http://myserverName/ReportServer?%2fReport+Project1%
> 2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-9098-
> 4b71-8511-c7e08926c50a
> asks me use id and password when I use myServerName
> instead of localhost. Wow can I get windows authentication
> works without asking username password?
I believe that localhost works because it is considered an Intranet site.
You could try adding http://myserverName to your list of Local Intranet
sites (IE, Tools | Internet Options, Security tab, Local Intranet, Sites,
Advanced). That should suppress the dialog and pass your Windows
authentication through automatically.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Thanks Jake,
It works fine when myServerName is in trusted list. Now, I
have another problem, I have a report application:
http://myServerName/ReportServer?%2fReport+Project1%
2fReport1&rs:Command=Render. This is working fine in any
computer. I also have an asp.net application that has this
report embedded as a report viewer, so
http://myServerName/App/WebForm1.aspx works fine and bring
report in myServerName server. However when I do
http://myServerName/App/WebForm1.aspx in any other
computer other than myServerName, report viewer is not
showing in IE.
I am not sure what repoet viewer parameters should be but
I am using ReportPath as /Report Project1/Report1,
ServerUrl as http:// myServerName /reportserver.
What is problem?
Thanks,
Jim.
>--Original Message--
>Hi Jim,
>JIM.H. wrote:
>> http://localhost/ReportServer?%2fReport+Project1%
>> 2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-
9098-
>> 4b71-8511-c7e08926c50a
>> works fine, but in the same computer,
>> http://myserverName/ReportServer?%2fReport+Project1%
>> 2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-
9098-
>> 4b71-8511-c7e08926c50a
>> asks me use id and password when I use myServerName
>> instead of localhost. Wow can I get windows
authentication
>> works without asking username password?
>I believe that localhost works because it is considered
an Intranet site.
>You could try adding http://myserverName to your list of
Local Intranet
>sites (IE, Tools | Internet Options, Security tab, Local
Intranet, Sites,
>Advanced). That should suppress the dialog and pass your
Windows
>authentication through automatically.
>--
>Regards,
>Jake Marx
>MS MVP - Excel
>www.longhead.com
>[please keep replies in the newsgroup - email address
unmonitored]
>.
>