We have several services that were originally published against a local file-based database (with ArcMap 10.1). We spent the past week converting the data into an SDE database and we are running under Arcmap 10.2.2. Now it is my turn to convert the services to use the database and get them published to the Arc Server.
All of the internal code just calls one of two methods and those all got changed. In Arcmap I removed all of the folder shares, renamed the gdb local database to hide it, and pointed Arcmap at the SDE server. Then I made that database the default.
Next I rebuilt our DLL, reregistered it to the Desktop, deleted all of the old service toolbox entries and recreated them. I should specify here that almost every one of our services specify schema names in the database for our parameters in the ParameterInfo method.
When I go to publish the services the execute window does not open except for our one service that does not use schema's to define the parameters. The implication is that ArcMap cannot find the schemas in the database. Yes I've tried with our schema names simple (eg. Simple_Polygon) as well as fully qualified (eg. OurServer.DBO.Simple_Polygon) but neither attempt has been successful.
I cannot see any other thing I need to do in order to get ArcMap to see our schemas so that I can publish the service. What am I missing??? I cannot find any ESRI documentation that talks about this aspect of publishing a geoprocessing service.