Workflow Soluiton

 View Only
  • 1.  DBTool Hanging

    Posted Oct 01, 2009 04:21 PM
    I'm trying to get Workflow 6.5 installed for a disaster recovery test.  However, every time the Ensemble database attempts to install, it hangs after/during the check if the database exists.  I have once been offered the option to run the scripts in the SQL folder, but that's nearly 300 scripts, which is ludicrous, never mind trying to document that.  Here's the configuration:
    Workflow version:  6.5
    OS:  Windows Server 2003 SP2
    DB:  SQL 2005 Express SP3
    I do have to remote desktop into the machine and am connecting with /console.
    I am an administrator on the box and am in the sysadmins group for the SQL Server instance. 
    The instance is just named with the server name, not with "\SQLEXPRESS" at the end.
    Here's what the DBTool window looks like when I start it:
     DBtool.jpg

    Help!


  • 2.  RE: DBTool Hanging

    Posted Oct 05, 2009 10:35 AM
    If you're trying to connect to a SQL Express instance, you have to append '\SQLEXPRESS' to the instance name. You can test this by using the test button on the page.


  • 3.  RE: DBTool Hanging

    Posted Oct 08, 2009 12:04 PM
    I had posted that I had installed the SQL instance without the \SQLExpress bit, so my connection did in fact work just fine.

    So, in an attempt to better mimic the available documentation, I have uninstalled everything from the box (Workflow and SQL2005) and reinstall SQL2005.  It's now there as (local)\SQLExpress.

    I've now encountered a fun new problem with the install.  The installer now hangs when "setting the Process Manager role" as shown in the screen shot.  Any ideas?

    Process Manager Role.jpg