We help IT Professionals succeed at work.

How do I Mirror two SQL 2005 Databses

mrawli
mrawli used Ask the Experts™
on
Hi Experts,

I am trying to mirror a SQL 2005 database to another SQL 2005 server offsite, I have configured the security wizard which completes fine but when I go to start mirroring the attached error is displayed.

I've checked netstat -an |find /i "listening" and found that the 5022 port is open and have opened the relevant port on the firewalls at each site so I'm not sure why its not working.

Thanks


 SQL Mirror Error
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
The problem is that the Mirror database is not restored with the
NORECOVERY option.
also check the links below
http://msdn2.microsoft.com/en-us/library/aa337361.aspx and
http://msdn2.microsoft.com/en-us/library/ms189127.aspx
Have you checked the logs from your firewall? This looks like something is still blocked to me.

Commented:
Does the sql server agent account from primary have access setup on the mirrored server?