Yes, it should not be this hard.  But think about it from our perspective.  We only have your limited problem description to try and identify the issue and correct it, whereas you have access to the actual server.  While I can play 20 questions to try and narrow down the problem, this is a crude way to do troubleshooting at best.  At the same time, think about the complexities of all the possible database configurations and what the testing regime would need to look like just to test the database installation.  This is why in Open Source projects we must rely on the community to help identify issues. 

Even once an issue has been identified, like lack of support for Case Sensitive collations, the correct solution is not always available.  I could easily make the changes to make DNN work in case sensitive environments.  It would take less than a week worth of work to make the actual changes but I would likely break every existing module and DotNetNuke website in the process.  Most modules are not coded and tested to work in a case sensitive environment.  Clearly that is a decision that should not be made lightly.  We have to weigh the benefits to a few users  versus the disruption to the broad community.  This is certainly a candidate for inclusion in the next major breaking release which may well be in the Cambrian timeframe.

Understood Joe

What would be great is if you mention this restriction somewhere nice and clear on the site as I had no idea what the cryptic errors were and a quick google search shows Im not the only one.

Is it listed as part of a "Systems Requirment" anywhere because it really needs to be.

A simple note saying the Sql Server db must be case insensitive.

Now I understand the limitation I can try seek ways around it re: seeking a 3rd party hoster or internal resources..

Also Sebastion you mentioned setting an individual db on the Latin1_General_Bin server to a case insenstive collation but Im still running into issues. Im going to keep digging to see if I come up with anything.

If I do Ill post back in case its useful to ye.

I've read through the posts.  Has anyone figured out what needs to be changed and can let us know?  I am not a programmer, and have limited experience.