Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 21, 2012 05:34 AM by Careed
Feb 21, 2012 04:56 AM|LINK
I created a Web Application that runs on the Visual Studio Development Server. It connects to the SQL Server using Windows Authentication. Then I run it on the IIS(in localhost) and tried using the same connection Strings to connect to database. It gives
System.Data.SqlClient.SqlException: Cannot open database "DATABSENAME" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\DefaultAppPool'.
How shall I change this?
Feb 21, 2012 04:59 AM|LINK
You need to use ASP.NET Impersonation. You can configure this within the IIS Manager using the Authentication icon.
Feb 21, 2012 05:05 AM|LINK
It still does not work
Feb 21, 2012 05:34 AM|LINK
Instead of using Windows Authentication in SQL Server, using Integrated Security instead.