Iis – Unable to restart IIS Website from Other Server

Maybe this isn't the answer to your question, but I have a suggestion. ODBC logging isn't considered the best option for production servers, because when it is enabled, IIS disables the HTTP.sys kernel-mode cache degrading overall server performance. Microsoft doesn't recommend ODBC logging unless your database limits you to this option.

You could use LogParser for moving your IIS logs to the database or query them directly.

Log Parser supports different input formats, including all IIS log file formats. Log Parser also supports multiple output formats, such as text files and database tables. You can use Log Parser to filter entries, to convert log files to other formats, and to perform data mining.

The eventlog ID you've provided (2271) is probably a sign, that there something wrong with your ODBC connection. I would re-check username/password and the database server's name and address.

If you created the database table "manually", verfify if all the columns which are needed are present in that table.

You can set IP restrictions in applicationHost.config in a location tag for your site. If you do that, then it won't cause an appdomain recycle. URL Rewrite at the global level is another option.

Week 12 and week 18 of my video series cover AppDomains and editing apphost.config.

To script it, use appcmd. The best way to do that is to start with Configuration Editor in IIS, make the change you want, then "Generate Script" from the actions pane on the right. The appcmd command will be there.

As for the 2nd question, you'll need to get a handle on your application startup within your project and have that trigger an event. An async call will allow it to start your startup script while allowing the page to continue, otherwise you'll run into a locking issue.