NHibernate deployment on IIS7 problem

Question

Hello, This might be quite common but I'm having an issue with nhibernate on iis7 my webservice works fine on visual studio 2008 default webserver but not on iis7.

I've tried moving the httpmodule config section into the webserver/module section and I've also tried leaving the module config inside system.web/httpModules and switching the app pool to classic .Net AppPool

but on both occasion I'm getting an sql login error, it's as if it no longer sees my connection string. The error is like below:

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'IIS APPPOOL\Classic .NET AppPool'

Can anyone help me out on this please? Many thanks!

Answer 1

Ok found the answer..

http://stackoverflow.com/questions/2404377/nhibernate-on-iis-7-sqlclientpermissionexception

basically I was using integrated security in connection string, once I changed it to an sql login that worked. phew!

Answer 2

I think it's not nhibernate problem

Try this Login failed for user ‘IIS APPPOOL\’