Last post Jun 02, 2015 07:34 AM by PatriceSc
Jun 02, 2015 06:13 AM|noth50|LINK
I have a web-app project by C# and SQL Server 2008 R2.
I transferred project to a VPS that runs Win2008 R2 and set all setting for IIS7. The Project runs and I can see the HTML pages but problem begin when in Login page or Register Page has no connection to SQL Server and nothing happened.
Jun 02, 2015 07:34 AM|PatriceSc|LINK
No, you should have an exception. Make sure you are not ignoring that (have you tried the Windows log ?) Currently you are using "integrated security" so my guess is that the account used for the web application is not allowed to access to SQL Server and/or
to the database.
If using the default account, it should be webserver$ (see
http://www.iis.net/learn/manage/configuring-security/application-pool-identities and scroll down to "Accessing the Network")