Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 OWC Report

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
rdraker Posted - 08/31/2006 : 13:36:04
I would like to use trusted security to connect to sql source for OWC. The sql database resides on another server. We do not have kerbos. Reporting services uses basic authentication so the user can enter their windows user name and password. Is there anyway to modify the connection string or application to prompt the user to enter their windows user name and password?
2   L A T E S T    R E P L I E S    (Newest First)
admin Posted - 08/31/2006 : 19:28:11
You can use Windows integrated authentication when connection to SQL Server form OWC report. This should not create a double-hop problem because the connection goes directly from the client browser to SQL server.

Also make sure that the anonymous user for TableService.aspx page has the access to the database.

C:\Inetpub\wwwroot\ReportPortal\owc\TableService.aspx
marco Posted - 08/31/2006 : 13:54:43
Hi,

OWC is using msolap and if you change the security on the map msolap in IIS than you can use basic authorisation.

I hope this solved your problem.

Regards, Marco

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page