SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

trying to set-up and consume a web service within SP using azure hosted services. I have written really simple code which compiles and deploys as a package. Followed this excellent walkthough...

When i try to add the external content type within SP i get the following message.

"Error loading URL ... this normally happens when URL does not point to a valid discovery document, service description, or XSD schema"

You can see the service here...

Anyone ran into this?


share|improve this question
Have you taken a look at the lab from Donovan Folette?… Do you get any error when you create the external content type in SharePoint Designer? – GavinB Jul 26 '12 at 3:34

Thanks for the reply Gavin and the link. Its taken a few days of head scratching but I eventually got the bottom of things...

The problem was the collation of the database (in my case SQL Azure) I had been using a DB created in SQL Azure which used Latin1_General_CI_AS, could not get it to work so decided to create a new DB using SQL_Latin1_General_CP1_CI_AS after reading a post on-line about the pitfalls of collation with SQL Azure.

Not sure why it has to be this collation or what can be done if your external DB is different to SQL_Latin1_General_CP1_CI_AS though...

Hope this helps someone.



share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.