I have created ASP.Net application that inserts data into a SQL Server Express 2008 database through a web browser. Everything works perfect when I run it through localhost (CTRL F5). However when I try to set it up in IIS I get 500.19 errors. I have created test apps without SQL Server and they work fine. I have created test Apps with SQL Server and I get the same errors.
Asked
Active
Viewed 95 times
0
-
Look in the event log on the server Start > type "Event Viewer" and run it, then expand Windows Logs > Application. Look for errors that give you more detail. – mason Sep 04 '18 at 13:24
-
Possible duplicate of [How do I resolve "HTTP Error 500.19 - Internal Server Error" on IIS7.0](https://stackoverflow.com/questions/929131/how-do-i-resolve-http-error-500-19-internal-server-error-on-iis7-0) – Pranav Singh Sep 04 '18 at 13:26
-
i have seen this however my apps work without SQL Server connection – Scott Smith Sep 04 '18 at 13:35
-
Make sure the user with with Installation is done on IIS has rights for DB operations (CRUD for schema & data) – Pranav Singh Sep 04 '18 at 14:13
-
@PranavSingh You mean "rights", not "writes". "Rights" can be a synonym for "permission", while "writes" typically refers to recording data somewhere. – mason Sep 04 '18 at 14:15
-
Agree Rights not writes, it was autocorrect type – Pranav Singh Sep 04 '18 at 14:18
-
Reveal the whole 500.19 error page please (mask out confidential info like IP or file path). There is a lot of causes, so only the page itself can tell more. – Lex Li Sep 04 '18 at 18:35