Last post May 28, 2012 09:08 AM by Mammadov Adil
May 18, 2012 08:39 AM|Mammadov Adil|LINK
Hi. I have application in ASP.NET which uses Crystal Reports. Everything works well in Visual Studio. But when I deploy it to IIS crystal report generates "Database Logon Failed". I am using ASP.NET, C#. Identity of My application pool is NetworkService.
I am using ODBC connection and stored procedure in reports. There were some suggstions that "create another application pool for crystal reports". But I don't know how to do this. Do you have any suggestions?
May 24, 2012 11:48 PM|necro_mancer|LINK
please make sure you create a new database user on your database with dbo_owner permission. Next, you need to change your web.config to use this new database user details.
If you host your site on a shared server, you need to contact your current host to obtain the server details.
If this post helps you, please mark it as an answer. Good luck!
May 28, 2012 09:08 AM|Mammadov Adil|LINK
Thank you for your time necro_mancer. I have solved my issue by changing my connection from System DSN to Oracle Server.
If someone else has this problem then consider selecting Oracle Server. It helped me, hop it will helpfull to anyone else too