Solved! Go to Solution.
Sounds like you are unfamiliar with dynamic workspaces.
The table must exist in a registered dynamic workspace in your Map Server.
Ok, this makes sense. I have registered my sde and I am using the Workspace ID that I created. Now how can I find the dataSourceName property? I would assume it would just be the name of the table on our sql server. But this doesn't seem to be working for me. Do I need to add anything? Maybe the schema (dbo.tableName) or something?
Thanks again for all your help.