locked
Database mirroring connection error 2 'DNS lookup failed with error: '11004(The requested name is valid, but no data of the requested type was found.)'.' for 'TCP://<<>>:5022' RRS feed

  • Question

  • Hi,

    I'm configuring Database mirroring work group environment, when i execute  

    ALTER DATABASE MirrorDB
        SET WITNESS = 'TCP://<<witness server IP>>:5024'

    I'm getting the following error,

    Msg 1456, Level 16, State 3, Line 2
    The ALTER DATABASE command could not be sent to the remote server instance 'TCP://witness server IP:5024'. The database mirroring configuration was not changed. Verify that the server is connected, and try again.

    when i check with the witness server error logs I found the following error and i"m not able to resolve the same.

    Error: 1474, Severity: 16, State: 1.

    Database mirroring connection error 2 'DNS lookup failed with error: '11004(The requested name is valid, but no data of the requested type was found.)'.' for 'TCP://hostname:5022'.

    Could any one  please help to resolve the same.

    Regards/Nani

    Wednesday, July 18, 2018 9:50 AM

Answers

All replies