Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elanting
Starting Member
1 Post |
 Posted - 2010-06-04 : 05:59:16
|
| Hi all, maybe you can help me out with this;One of our customers has got a sql server 2005 server in our domain and another one at another datacentre (which is on another domain)The local server is connected through windows authentication, the remote mirror server is connected through sql server authentication (both on port 5022)When setting up database mirroring (restoring the db on the mirror location as 'non-operational' etc..) and hitting the start mirror button after configuring, i'm getting an error that the mirror location cannot be found;---------------An error occurred while starting mirroring.Additional information: Alter failed for Database 'database-name' (Microsoft.SqlServer.Smo) (Microsoft.SqlServer.ConnectionInfo) The server network address "TCP://serveraddresip: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. (Microsoft SQL Server, Error:1418)---------------Note:Due to the fact that the domains aren't trusting each other (theres no domain trust set up) the mirror server address being translated through our network.I can connect to the SQL Server instance by using SQL Server Management Studio by logging in with the sql server user (not a windows user)Thanks in advance for helping out with any tips!Regards,E. Lanting |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2010-08-18 : 06:23:00
|
| can you connect from the source to the destination server?try ping or isql--------------------keeping it simple... |
 |
|
|
|
|
|
Mirroring between two domains