February 12, 2007 at 4:44 am
Hi guys,
I'm not sure if this is the right place to seek help on setting up mirroring with SQL2005. To be frank, I'm fairly new to administering MS SQL2005 and mirroring is a new feature in service pack 1.
I'm no expert, and so did some goggling and referred to the following articles for guidance:
http://msdn2.microsoft.com/en-us/library/ms179306.aspx
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1199004,00.html
I've used the Configure Database mirror Security Wizard and successfully setup for the pricipal, mirror and witness instances.
However, with all that done, the principal server was unable to connect to the mirror server.
I've checked my firewall settings, network configuration and I'm sure all is correct.
I realize this is not a simple matter of inputting sa password and wala~! and figured out that I'm having endpoint security issues where different instances do not have access rights to each others and that scripts that were meant for creating endpoint to one another wasn't working.
Here's my setup details.
Principal : windows 2003 server, sql2005
Mirror : winxp pro, sql2005
witness : winxp pro, sql2005
all these machines are on the same workgroup.
I read that I need to create certificates and some kind of master db encryption key and then endpoints. Would any kind soul point me the right directions and enlightening articles to get this right?
February 12, 2007 at 4:48 am
Just read through the link below. it gives a brief description of setting up database mirroring.
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1199004,00.html
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
March 9, 2007 at 3:22 am
Hi,
Please make sure that the SQL server services are running under the same user account and pwd in both Principal & Mirror server. Then we can set up Mirroring without using certificates in a Workgroup.
Regards,
Ramachandran.G
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply