Hi, I'm newbie with tomcat, Can somebody help me solving my problem? I really apprciate it, cause it has made me frustated
Currently I'm working with BIRT, tomcat and MSSQL I use BIRT to create report as an add-on to our ERP. We tried to using windows authentication as SSO in all the report, so the roles is described in MSSQL security and the report's security just based on security from MSSQL. I'm using JTDS as JDBC Driver because it can integrate Windows Authentication When I design the report, the driver works well, so I could using MSSQL roles as security in my report, for example when I set the "domain\user" can access view "stock", so in the report the user can access the view, when I set the user cannot access or execute the view or stored procedure in MSSQL, so the report cannot retrieve the data. In RCP design all work fine. But when I copy the report to tomcat webapps, the driver doesn't work. The error logs said that it couldn't authenticate the domain\user against the MSSQL. so the connection cannot be open Does anyone can help me for this problem? Thanks in advance Hendrik