Hi,
I have a quick instalation of Workflow Manager (10.5). At Workflow Manager Adminsitrator, when I try to publish it, I'm faced with the error:
Cannot connect to the Workflow Manager Database using the given connection string, failed to find a default Database as well. (Error message = IDispatch error #2294, hr = -2147218698)
This error occurs just when I enable the capability LOI, so the WMServer is created with success, but LOI.
Here is the json logged when I try to publish it:
<SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"serviceName"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"IPPWorkflow"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"type"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"WMServer"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"description"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Connection to 192.168.106.226_WORKFLOW"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"capabilities"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"properties"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"filePath"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"outputDir"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"C:\\apps\\ArcGIS\\arcgisserver\\directories\\arcgisoutput"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"virtualOutputDir"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"/rest/directories/arcgisoutput"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"manualTransactions"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"0"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"connectionString"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"ENCRYPTED_PASSWORD=<my encrypted pw>;SERVER=192.168.106.226;INSTANCE=sde:sqlserver:192.168.106.226;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=192.168.106.226;DATABASE=WMANAGER;USER=gisadmin;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"repositoryName"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"192_168_106_226_gisadmin"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"description"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Connection to 192.168.106.226_WORKFLOW"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"antialiasingMode"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"None"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"textAntialiasingMode"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Force"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"minScale"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"0"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"maxScale"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"0"</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"clusterName"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"default"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"maxIdleTime"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1800</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"isolationLevel"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"HIGH"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"loadBalancing"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"ROUND_ROBIN"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"configuredState"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"STARTED"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"minInstancesPerNode"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"maxInstancesPerNode"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"maxWaitTime"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">60</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"maxUsageTime"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">600</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"maxStartupTime"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">300</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"instancesPerContainer"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"keepAliveInterval"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1800</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"recycleStartTime"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"00:00"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"recycleInterval"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"24"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"extensions"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"provider"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"ArcObjects"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"portalProperties"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"isHosted"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="keyword token">false</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"portalItems"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"itemID"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"ae5a4508beb04faeb13aa28d6991f0c5"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"type"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"WMServer"</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>Please guys, any idea to solve this?
Alex