Dear All sorry OOT, saya melakukan set mirroring sql 2005. dengan spec
SQL utama - Microsoft SQL Server Developer Edition (9.0.3159) - quad core - win2003 server r2 enterprise ed (SP2) SQL backup - Microsoft SQL Server Developer Edition (9.0.3159) - quad core - win2003 server r2 enterprise ed (SP2) Pada saat step alter database ga SET PARTNER = 'TCP://sql-backup.domain.net:5022' go maka muncul Msg 1418, Level 16, State 1, Line 1 The server network address "TCP://sql-backup.domain.net: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. baik SQL utama maupun SQL Backup saya telnet ada respon. ============ SQL Backup ================ [EMAIL PROTECTED]:~$ telnet 192.168.1.22 5022 Trying 192.168.1.22... Connected to 192.168.1.22. Escape character is '^]'. ============ SQL Utama ================ [EMAIL PROTECTED]:~$ telnet 192.168.1.13 5022 Trying 192.168.1.22... Connected to 192.168.1.22. Escape character is '^]'. Jika saya menggunakan wizard, maka akan muncul error Alter failed for database GA (Microsoft.sqlserver.smo) -> An exceptionoccured while executing a transact-SQL statement or batch. (microsoft.sqlserver.connectioninfo) --> the server network address "tcp://sql-backup.domain.net:5022" can not reached or doest not exist.Check the network address name and that the ports for the local and remote endpoints are operational. (microsoft sql server, error 1418) ---- sebagai informasi tambahan, untuk firewalldi sql 2003 dalam posisi disable. report dari netstat juga port 5022 ada. Ada Saran, dimana saya harus memperbaiki setting saya ? atas saran dan bantuannya, saya ucapkan terimakasih Regards Iwan S
