XY event layer doesn't work with ArcGIS Server 10.1

Question

I have a geoprocessing tool written in Python that contains operations on an XY event layer. It worked perfectly when running from ArcCatalog. When published as geoprocessing service on ArcGIS Server 10.1, however, it never worked. The JSON response when executed as REST service was

"error": {
  "code": 400,
  "message": "Unable to complete operation.",
  "details": [
   "Error executing tool.: ERROR 999999: Error executing function.\nThe XY event source name has not been setup correctly.\nFailed to execute (CopyFeatures).\n\nFailed to execute (NewCuringModelExpPy).\nFailed to execute (New_Curing_Model_ExpPy)."
  ]
 }

I have been struggling with this for days. Has anyone else ever come across this issue before or how was that solved?

Thanks!

Alex

Answer 1

I finally figured it out.

I had to change the database server name in connection properties from server alias to its IP address. Then it worked.

Thanks for all who post answers.