• I attempted to implement DM on a 3-box workgroup using the GUI wizard, but failed, apparently because the wizard's logic does not work for workgroups. So next I tried to implement Michael Merriil excellent script for non-domain DM. Everything worked fine (endpoints, certificates, etc.) until it came to actually setting up the mirroring. Then it failed again.

    I am wondering if it has to do with the presence of named instances.  For example the primary is called jaguar/sql05dev. The primary box also has another instance jaguar/sqlexpress. The other boxes also have named instances, although only one SQL 2k5 instance exists on each. Anyway, I am suspicious of

    alter database aspnetdb

       set partner = 'TCP://192.168.1.4:5022' as there is no named instance specification.

    How do I specify a named instance with the IP address notation?

    Thanks,

    Jeff