Last post Jan 31, 2013 02:33 AM by BOO77
Jan 30, 2013 08:46 AM|BOO77|LINK
The SQL Server login failed with IIS7 (through Internet Explorer) but succeeded with Visual Studio .NET 2008 Web Server.
The ASP.NET page was reachable, then username and password were entered to their text boxes respectively. The button to validate the account on SQL Server on company server was clicked and "Login Failed" error was encountered.
Sometimes, near .Open and sometimes near .ExecuteReader.
Firewall on the development PC has been turned off. UAC is enabled. Full permission (to everyone) is already given for IIS7 binary folders.
What else can be done?
Jan 30, 2013 10:43 AM|HostingASPNet|LINK
It seems as permission issue as you have Admin in VS and Application pool user rights in IIS.
Try to add the applicaion pool user to SQL server users, or use impersonation.
Jan 31, 2013 02:33 AM|BOO77|LINK
I don't know how to add the IIS APPPOOL\(MyAppPoolName) as the SQL Server 2000 Enterprise Manager reported an error, but I saw you mentioned impersonation, and what a magic, a slight modification to the Web.config as follows...
...worked perfectly and it runs now!!!
Thanks a billion, HostingASPNet!