database mirroring RRS feed

  • Question

  • excuse:  new to sql server but experience on other databases on other platforms


    problem:  trying to set up mirroring between principal and mirror databases.  Two separate servers using certificate for authentication.


    error received:

    an error occurred while starting mirroring.

    alter failed for database 'cinrandfw_TEST'.(microsoft.sqlserver.smo)

    an exception occurred while executing a transact-sql statement or batch


    the server network address "TCP://usdfwsvrsql01.hq.cinnet.cinram.com: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.(microsoft SQL Server, Error:1418Smile


    Any assistance will be greatly appreciated.




    Thursday, August 21, 2008 8:03 PM


All replies