Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 OWC Report		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rdraker

2 Posts
Posted - 08/31/2006 :  13:36:04  Show Profile  Reply with Quote
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?

marco

Netherlands
588 Posts
Posted - 08/31/2006 :  13:54:43  Show Profile  Reply with Quote
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
Go to Top of Page

admin

1645 Posts
Posted - 08/31/2006 :  19:28:11  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page