When running Hansen8 under IIS it is convenient for developers (or at least me) to do as little as possible to get the environment working. If found (but keep forgetting) that to be the following:
1. Logins: Create a "SQL Server authentication" user and disable the password enforcement policy.
2. Server Roles: "public" only.
3. User Mapping: Assign the user to the Hansen database(s)
But do not forget to enable "SQL Server and Windows Authentication mode" under Server Properties|Security (right-click the server, select properties).
Once you do this you can add/modify the provider in the configuration editor to use this user/password instead of the integrated user (which doesn't work).
