My WCF Data Service worked fine in the VS Web Server, but when I deployed it to IIS (7.5), it stopped working. I was able to view the service page listing all the entities, but when I tried to access the entities in a RESTFUL manner, I wasn’t.
I found out the problem by setting
config.UseVerboseErrors = true;
in
public static void InitializeService(DataServiceConfiguration config)
The problem was I was using windows authentication to connect to my database, after changing to SQL Server Authentication, everything worked fine.
Spent hours in figuring out this…