| 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 |
Report Portal
