Unable to mirror a database in mode sync full
Hello,
I'm trying to mirror a database which is hosted by a SQL Server 2008 R2 on another SQL Server 2008 R2 which is not in a domain. The database is set in full mode and I'm trying to mirror it on this new server but it returns an error at the end.
I've backup the database on the source server as well as the logs and imported them on the new server in NO RECOVERY mode.
The connection between the servers seems to be just fine, there isn't any firewall between them but I still got this error message after the wizard ends and I don't understand why :
*Alter Failed for Database 'Test'. An exception occured while executing a Transact-SQL statement or batch. The network address TCP://10.0.2.40:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational"
Any ideas ?
Kind Regards,
David
PS : There is no witness server. Is it mandatory to have one?
I'm trying to mirror a database which is hosted by a SQL Server 2008 R2 on another SQL Server 2008 R2 which is not in a domain. The database is set in full mode and I'm trying to mirror it on this new server but it returns an error at the end.
I've backup the database on the source server as well as the logs and imported them on the new server in NO RECOVERY mode.
The connection between the servers seems to be just fine, there isn't any firewall between them but I still got this error message after the wizard ends and I don't understand why :
*Alter Failed for Database 'Test'. An exception occured while executing a Transact-SQL statement or batch. The network address TCP://10.0.2.40:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational"
Any ideas ?
Kind Regards,
David
PS : There is no witness server. Is it mandatory to have one?
ASKER
Hi Daniel_PL and thanks for your message.
Everything was set as you mentioned. Only the Named/Pipes is not activated on one of the servers and the VIA on both of them. Could that be the reason of my problem?
Kind Regards,
David
Everything was set as you mentioned. Only the Named/Pipes is not activated on one of the servers and the VIA on both of them. Could that be the reason of my problem?
Kind Regards,
David
ASKER
Hello again, I've activated the named Pipes, restarted the services and still the same problem...
any ideas are welcome )
David
any ideas are welcome )
David
No, don't use named pipes. TCP/IP is best protocol for this.
You can't use GUI because of no integrated security, you need t-sql. Try this approach:
http://msdn.microsoft.com/en-us/library/ms191140.aspx
About mirroring:
http://www.devproconnections.com/article/sql-server/Database-Mirroring-in-SQL-Server-2008-and-SQL-Server-2008-R2/1.aspx
You can't use GUI because of no integrated security, you need t-sql. Try this approach:
http://msdn.microsoft.com/en-us/library/ms191140.aspx
About mirroring:
http://www.devproconnections.com/article/sql-server/Database-Mirroring-in-SQL-Server-2008-and-SQL-Server-2008-R2/1.aspx
ASKER
Daniel_PL, thanks for your message.
I was a bit worried to try your solution, so I tried to create another SQL server in same VLAN, same domain, same sa account, and guess what, the error is the same.... Did I missed something? Is it mandatory to do that T-SQL security each time we want to do a mirroring sync???
Kind Regards,
David
I was a bit worried to try your solution, so I tried to create another SQL server in same VLAN, same domain, same sa account, and guess what, the error is the same.... Did I missed something? Is it mandatory to do that T-SQL security each time we want to do a mirroring sync???
Kind Regards,
David
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Daniel_PL and thanks for your support. I think our problem is really special. I guess that all the problem becomes from our log backup. It might be corrupted or wrong and it makes all that problems with the connection. So, I'll try to find a way to rebuild the logs.
At least, your procedure to do it is really clear and I give you the points for sure.
Thanks again for your help.
Kind Regards,
David
At least, your procedure to do it is really clear and I give you the points for sure.
Thanks again for your help.
Kind Regards,
David
While connecting outside domain you need to use sql authentication with sql account so mixed authentication need to be enabled.