locked
Fatal scripting error. Cannot open connection specified in the SQLCMD script. RRS feed

  • Question

  • Hi All,

    We have Three Node Cluster out of which two nodes are involved in DB Cluster, third node is being used for alwayon (Only Windows Clustered).

    Now the issue is both the DB Cluster nodes are down and AG databases are in "NOT SYNCHRONIZING" STATE. Since our third node for alwayon is available we want to recover databases and executed below forced failover command getting error.

    - YOU MUST EXECUTE THE FOLLOWING SCRIPT IN SQLCMD MODE.
    :Connect VDBTAM

    ALTER AVAILABILITY GROUP [ROM] FORCE_FAILOVER_ALLOW_DATA_LOSS;

    GO


    GO

    Error:

    Connecting to VDBTAM...
    Fatal scripting error. Cannot open connection specified in the SQLCMD script.
    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    )

    --

    By any chance is it possible to recover databases even primary server is down. Please suggest. Thank You

    Regards,

    Shiva


    Grateful to your time and support. Regards, Shiva

    Saturday, August 22, 2015 3:26 PM

Answers

  • Resolved. FORCED QUORUM.

    net start clussvc /fq and perform failover to bring DB's to synchronizing state.

    Regards,

    Kalyan


    Grateful to your time and support. Regards, Shiva

    Friday, September 4, 2015 9:56 PM

All replies

  • can check you see sql instance using Run => SQLCMD -L.

    Please click "Mark As Answer" if my post helped.

    Monday, August 24, 2015 1:32 AM
  • Resolved. FORCED QUORUM.

    net start clussvc /fq and perform failover to bring DB's to synchronizing state.

    Regards,

    Kalyan


    Grateful to your time and support. Regards, Shiva

    Friday, September 4, 2015 9:56 PM