asked
Can I set up database mirroring between 2 machines that are in a local workgoup?
I've been testing database mirroring in the same machine, and all was working fine. So now I'm going a little step further and trying to set this up in different machines (actually I'm using virtual PC and still testing on the same machine, but I think its ok) The problem is I'm having the following error: > Error: 1418 – Microsoft SQL Server – The server network address "TCP//VIRTUAL2:5022" can not be > reached or does not exist. Check the network address name and that the ports for the local and > remote end points are operational. Is this caused for not having both machines in the same domain? or this should be possible even if the machines are in a local work group?
Skip mirroring for the moment, can you get the two machines to communicate with each other? Can you connect from one SQL Server instance to the other? I'd get that resolved first because that sounds like where you're hitting an issue. Then you can go to work on mirroring.
that I can do, I have other instances installed and they are able to do transactional replication. Anyway it seems I found the solution for my question here
http://www.kendalvandyke.com/2011/12/database-mirroring-in-windows-workgroup.html looks like a big work around...but i'll try it. If anyone know a simpler way, please tell me :) edit: I had trouble understanding the explanation in the last link... but I've found this solution that worked for me
http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx it's way more extensive/complex but it well explained and it worked just fine in the end :)
Yes it is possible by using certificates in workgroup check this link out
http://www.sqlpass.org/LearningCenter/TechnicalArticles/tabid/78/articleType/ArticleView/articleId/176/Default.aspx
