Let me answer my own question and for anyone else who has the same question:
You have to uncomment the 2 SQL Server connection strings, and comment out the 2 SQL Express connection string.
I also discovered the domain was not configured to use ASPNET 2; I had to make a custom request to WH4L to switch it to ASPNET 2.
The documentation for using SQL Server should be cleared up to reflect the above I believe.
Co-Author of UCanUse Products Get it here!