Unmanaged reports and server logon account

[mdwyer]

We are using CE9 but have a set of unmanaged CR8.5 reports called with a URL.

[URL unfurl="true"]http://bbd5/imaging/Reports/DetailDateRange.rpt[/URL] ?init=actx&prompt0=date(2005,08,01)&prompt1=date(2005,08,31)
&user-kofax.ACSystem=StatMgr&password-kofax.ACSystem=Screen97
(spaces added to provide wrapping)

Do unmanaged reports attempt database access using the CE services' logon account, or the user's network login?

More detail:
These reports use an ODBC connection to a SQL Server database. The ODBC uses the SqlServer driver and is configured to "verify authenticity of the login ID" "With SQL Server authentication using a login ID and password entered by the user." The alternative is "With Windows NT authentication using the network login ID."

If I change the ODBC configuration to "Windows NT authentication using the network login ID," would the URL be processed under CE's Guest account so that the server's logon account is passed to ODBC, or would ODBC still want to authenticate my network login?

Furthermore, if a CE service (Job Server, Page Server?) IS used here, is it possible to create a separate service for unmanaged reports?

 

[eyeswideclosed]

dude unmanaged reports are no longer supported, you are on your own if you still want to do it, according to bo "too bad so sad", that'll be $65k...shutup and take it like a man...

 

[mdwyer]

I've been trying to figure out how to get off Crystal Enterprise even before BO took over. That's why we're still on v9, where unmanaged reports are still supported.

Still, I was hoping for an actual answer to my questions:

Is it possible to create a separate service (Job Server or Page Server) just for unmanaged reports?

Do unmanaged reports actually run under the CE Guest account?

Thanks!

 

[digitaldallas]

RAS runs unmanaged reports and you need a different license for that. Setting up a different service for Job/Page won't work because they take direction from the APS.

 

[mdwyer]

Thanks! I'll try setting the RAS user account to a network-privileged user. I'll have to wait till monday to verify that the user has an account in the sql server db, however.

 

[eyeswideclosed]

hahaha i know what you mean holmes, well the deal is bo doesn't support v9 or before at all anymore, that's how they force you to upgrade, so we had to give them our blood and go through a hellish upgrade to a managed system, took many months and we lost what blood we had left, now my hair is all white...hahaha yours will be too!