Last post Aug 14, 2013 06:31 AM by somnath2107
Dec 02, 2011 06:43 PM|mj_developer|LINK
I have deployed my ASP.NET 3.5 web application on IIS 7.5 but when I browse it from my Internet Explorer 9 it gives me the following error:
Failed to login to session state SQL server for user 'IIS APPPOOL\SampleWebSite'.
Dec 02, 2011 06:54 PM|Huske|LINK
The problem is that IIS APPPOOL\SampleWebSite is not added to SQL Server's security database. This user is the one that you choose to run your App Pool. Instead of this, you should create a dedicated user that will run your App Pool. Add this user
to your SQL Server instance and assign it database access rights and give it execute privilege for your stored procedures.
Aug 14, 2013 06:31 AM|somnath2107|LINK
I have different scenario.
My IIS running machine and SQL Server 2008 machines are different.
I have also tries setting Persist Security Info =true ,but Still getting error "Login failed for user "userabc""
Please help me.