Database Mirroring

[guyver9114]

Hi all, have any of you SQL guru's used Mirroring in SQL 2005 on a Workgroup not a Domain?

I am having a few issues

I have created certificates, new logon and users for each server, setup endpoints and granted the users connect privledges to the endpoint.

Am I missing anything as I am gong round the bend! Me company needs me to have this setup this week but aren't sending me on the course for another 8 weeks!!!

Many Thanks
G

[Crito]

Originally Posted by guyver9114

Hi all, have any of you SQL guru's used Mirroring in SQL 2005 on a Workgroup not a Domain?

Nope, but not sure why you'd have to use certificates. Windows-based NTLM authentication should still work in a workgroup mode (using local users/groups). You just won't be able to use Kerberos (because MS' implementation relies on AD.)

Would eliminate one layer of complexity for your troubleshooting anyway. If it works with NTLM then you can focus on the certificate side of things. If not, then maybe you didn't prep right: set full recovery model, backup/restore with norecovery option, copy system objects, create endpoint as TCP for database_mirroring, etc...

[guyver9114]

Finally sorted it out the other day, the certificates was saying it was not valid yet, waited 1 hour after creating it and all ok! Loads of fun :9