Database Mirroring

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

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

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

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...

 

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