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 |
|
changlinn
Starting Member
2 Posts |
 Posted - 2010-05-09 : 11:29:16
|
| Hi everyone,Got an error 1418, after running the mirroring setup wizard it configures the mirror but get 1418 on starting the mirrorThe servers do have a firewall between them but I have opened up port 1433 and 5022 on the firewall. I can sucessfully connect on these ports between the servers using telnet and the SQL management Studio.Both servers are in the same domain and the SQL service is running as the same domain account that has local administrative access on both servers.I can see some traffic going through between these servers on port 445 and 135 which is smb and rpc respectively, but this is early on in the connection logs, lately just 5022 and 1433.If I do a netstat on both of the servers I can see that the sqlserver pid is listening on 1433 and 5022, if I try and initiate the mirror I can see on the designated Mirror server the tcp status changes from listening to time_wait, but not to established. Then I get the error below, anyone got any ideas where to go from here, this all worked in the lab;TITLE: Database Properties------------------------------An error occurred while starting mirroring.------------------------------ADDITIONAL INFORMATION:Alter failed for Database 'web-app'. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3353.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476------------------------------An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------The server network address "TCP://sql-server2.domain.local: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)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3353&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476 |
|
|
changlinn
Starting Member
2 Posts |
Posted - 2010-05-09 : 12:14:51
|
| ahh sorted it went over my settings and found a simple mistake in the remote servers firewall. |
 |
|
|
|
|
|
Error 1418 SQL DB mirroring