Post reply

Database mirroring issue

  • July 19, 2016 at 12:19 am

    #320036

    Hi All ,

    I set up mirroring from 2 different servers . Server A as principal and Server B as Mirror ( No witness)

    I can connect to server B from server A using SQL Management Studio and I can also telnet ..

    The weird thing is it shows up an error “The server network address "TCP://B:5023" 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 idea how to troubleshoot this issue ?

    Many thankss

  • July 19, 2016 at 4:17 am

    #1890802

    Endpoints are started? Can you telnet on the endpoint port? Name resolution work correctly?

  • July 19, 2016 at 5:21 am

    #1890813

    Thanks for the reply ..

    I created endpoint with state STARTED .. i did telnet with this command from server B :

    TELNET SERVERA 5022

    And also i did telnet from Server A :

    TELNET SERVERB 5033

    BOTH look OK to me

  • July 19, 2016 at 6:03 am

    #1890822

    WhiteLotus (7/19/2016)

    And also i did telnet from Server A :

    TELNET SERVERB 5033

    5033, or 5023?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 19, 2016 at 6:00 pm

    #1890973

    Oops sorry ..Should be 5023

  • July 19, 2016 at 6:36 pm

    #1890976

    Btw I just notice something when I run a query to see the permission level

    SELECT EP.name, SP.STATE,

    CONVERT(nvarchar(38), suser_name(SP.grantor_principal_id))

    AS GRANTOR,

    SP.TYPE AS PERMISSION,

    CONVERT(nvarchar(46),suser_name(SP.grantee_principal_id))

    AS GRANTEE

    FROM sys.server_permissions SP , sys.endpoints EP

    WHERE SP.major_id = EP.endpoint_id

    ORDER BY Permission,grantor, grantee;

    GO

    The result is only 4 records ( I don’t see the permission for Endpoint that I created , Is it normal ? )

    nameSTATEGRANTORPERMISSIONGRANTEE

    TSQL Local MachineGsaCO public

    TSQL Named PipesGsaCO public

    TSQL Default TCPGsaCO public

    TSQL Default VIAGsaCO public

  • July 20, 2016 at 1:42 am

    #1891012

    No, you should see the endpoint for mirroring. There was no errors during creating endpoint? Are you sure that something is listening on endpoint port? Do you have multiple instances on this servers?

  • July 20, 2016 at 6:33 pm

    #1891194

    Thanks for the reply , yesterday I just created 1 user which is SQLMIRROR and when I created Mirroring I grant permission for that user ( as service account ).

    So in SQL server services I changed Log on SQL server and SQL server agent as SQLMIRROR ( applied to both servers)

    Also I added that user to master database ( applied to both servers)

    When I check the permission level I can see the endpoint there

    endpoint_MirrorGXYZ\White.LotusCO XYZ\White.Lotus

    TSQL Local MachineGsaCO public

    TSQL Named PipesGsaCO public

    TSQL Default TCPGsaCO public

    TSQL Default VIAGsaCO public

    UNFORTUNATELY I still got the same error .

    Any idea please?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply