none
(Sumber: milist SQL Server) Mirroring SQL Server 2008 R2 RRS feed

  • Pertanyaan

  • Dear All Master,

    1. Saya coba mirroring dengan 1 machine (1 PC) dengan 2 instance (1 Principal dan 1 Mirror) itu sudah berhasil jalan Mirror-nya. 
    2. Tapi kalau mirroring dengan 2 machine (2PC) masing-masing 1 principal dan 1 mirror itu tidak bisa jalan dan menimbulkan message "cannot be reached or does not exist mirroring Error : 1418".
    3. Padahal Port TCP nya sudah Enable, Windows Firewall nya sudah Off, Versi SQL nya sudah sama, Recovery Model sudah Full dan Log On As nya sudah NT Authority\NetworkService.

    Mohon pencerahannya. Terima kasih :)


    Best Regards,
    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Rabu, 27 Februari 2013 09.02
    Moderator

Jawaban

Semua Balasan

  • Mirroring yang point 2 yang mas maksud harus berada dalam 1 buah lingkungan domain sehingga user yg digunakan menggunakan user domain.

    Jika tidak berada dalam lingkungan domain dapat juga menggunakan Certificate dimana step by step nya dapat dilihat disini :

    http://msdn.microsoft.com/en-us/library/ms191140.aspx

    Semoga membantu.

    Dijawab oleh Suherman


    Best Regards,
    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Rabu, 27 Februari 2013 09.03
    Moderator
  • Terima kasih Mas Herman,

    Sekarang kalau saya lakukan query ini : 

    ALTER DATABASE NAME

    SET PARTNER =’TCP://MACHINENAME:5023′ 

    Message Error nya = The partner server instance name must be distinct from the server instance that manages the database. The ALTER DATABASE SET PARTNER command failed.

    Itu maksud nya apa yah mas, Mohon pencerahanya. :)

    Terima kasih.


    Best Regards,
    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Rabu, 27 Februari 2013 09.04
    Moderator
  • Error tersebut biasanya terjadi karena adanya masalah permission. Apakah setup Mirroring yang dilakukan ini menggunakan certificate atau di lingkungan domain ?

    Dijawab oleh Suherman


    Best Regards,
    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Rabu, 27 Februari 2013 09.04
    Moderator
  • Setup Mirroing ini menggunakan Certificate, berikut step by step nya :

    1. DROP ENDPOINT [NAME] (Done, dijalankan di principal dan mirror). 
    2. CREATE ENDPOINT [Mirroring] 
      AS TCP (LISTENER_PORT = 5023)
      FOR DATA_MIRRORING (ROLE = PARTNER, ENCRYPTION=DISABLED) (Done, dijalankan di principal dan mirror).
    3. ALTER ENDPOINT [Mirroring]
      STATE = STARTED 
      AS TCP (LISTENER_PORT = 5023)
      FOR database_mirroring (ROLE = PARTNER);
      GO (Done, dijalankan di principal dan mirror)
    4. ALTER DATABASE NAME
      SET PARTNER =’TCP://MACHINENAME:5023′ (Error = The partner server instance name must be distinct from the server instance that manages the database. The ALTER DATABASE SET PARTNER command failed. , dijalankan di principal dan mirror)

    Mungkin itu mas saat lakukan certificatenya, Mohon pencerahannya mas :D.

    Terima kasih


    Best Regards,
    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Rabu, 27 Februari 2013 09.05
    Moderator
  • Masih ada 2 langkah awal yang kurang mas. di Configure dulu Inbound dan OutBound Connection nya. baru lakukan pembuatan mirroring.

    Dijawab oleh Suherman


    Best Regards,
    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Rabu, 27 Februari 2013 09.05
    Moderator
  • Saat melakukan Inbound dan Outbound selalu gagalnya di tahap ini :

    ALTER ENDPOINT Endpoint_Mirroring

       STATE = STARTED

       AS TCP (

          LISTENER_PORT=7024

          , LISTENER_IP = ALL

       ) 

       FOR DATABASE_MIRRORING ( 

          AUTHENTICATION = CERTIFICATE HOST_A_cert

          , ENCRYPTION = REQUIRED ALGORITHM AES

          , ROLE = ALL

       );

    GO

    Message Error nya Cannot find the object "Endpoint_Mirroring" because it does not exist or you do not have permissions.

    Terima kasih.


    Best Regards,
    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Kamis, 28 Februari 2013 07.23
    Moderator
  • Sepertinya endpoint yg bernama "Enpoint_Mirroring" tampaknya tidak ditemukan.

    Ikuti langkah2 di link http://msdn.microsoft.com/en-us/library/ms191140.aspx sepertinya sudah cukup mas

     

    Dijawab oleh Suherman


    Best Regards,
    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Kamis, 28 Februari 2013 07.23
    Moderator