Interactive Reporting 9.3.1 - Server-side ODBC setup for Windows Authent.
622827Sep 15 2010 — edited Sep 21 2010Help. I am having a problem with Interactive Reporting connections to SQL server through the Web Client.
In our environment, we have the Hyperion BI 9.3.1 suite. We develop IR documents (BQY's) on our local machine using Studio and using locally setup ODBC connections to SQL Server, using Windows NT authentication. Everything works perfectly fine, locally.
When we upload the BQY and the OCE, and properly associate them to each other in Workspace, we then proceed to open them using the Web Client. The file opens fine, and when I hit process to run the query, I am prompted to login. When I login (using my NT Authenticated login), I receive the following error message: "Error Logging on as Windows User: Win32 Error code: 1385 Logon failure: the user has not been granted the requested logon type at this computer."
The ODBC that was setup on the server was setup to use NT Authentication (as opposed to SQL server). The DAS connections are setup properly. My question is - how do you setup a connection to a SQL server using NT authentication and have the user authenticate through the Web Client. We don't want to grant users access to the server directly.
If you can't answer this question, can you tell me how you have setup your connections on the server through DAS and how you properly maintained security controls?
Thanks - Mike