windows authentication for LBI reports

 0 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Donna
Veteran Member
Posts: 110
Veteran Member
    We have a subsidiary that wants to use the ODBC Trusted Connection for their published reports.

    I can set up the ODBC with a SQL Server driver and successfully create a report. When I publish the report, I am not getting the datasource to work. I did not enter the default login information but used the option
    Prompt for UserID and Password
    Error message received:

    The viewer could not process an event. Failed to open the connection. Failed to open the connection. Elements {FC167323-25DD-4480-9899-1014DC097A7B}.rpt [CRSDK00000000] ---- Error code:0 [CRWEB00000119]

    I tried several other settings but was unsuccessful.

    Any suggestions?