1) Change the datareport application to use a SQL Server login.
2) Change the Citrix Service to log on as a domain account, and grant that domain account access to whatever the Datareport application needs on the database.
I am not certain if 2 will work, but 1 should. Keep in mind that using ODBC you have to make sure that two places are set to SQL authentication, because if either uses Windows authentication, it will override the username/password that you supply in your connection string.
All applications uses same DSN which is created using windows authentication(not possible to change into sqlserver login) and i tried for this utility application(same DSN used) in dataenvironment connection using sqlserver connection with username and password by uncheck the trusted connection.But still problem persists.Still any hopes are there?
It is beginning to look a bit dim. I am betting that the Citrix process can not use the user's credentials for any purpose outside it's own realm (thus it goes to the database as user 'Null'). I think that is called "Impersonation", and there was a bit of a scary way to do it in AD, but it has been a couple years since I read that article.