configuring Mirroring problem

  • Hi...

    when i am configuring Mirroring i am getting tcp\ip port problem..

    my 1st server dafault Instance[MSSQLSERVER] run under Local system service account..

    2nd server named Inst[pcname\shiva] run under \.shiva service account..

    1st server backup and 2nd server restore completed...

    but wen i am configuring mirroring i got problem like tcp\ip port problem, database space prob..

    what is the solution for ths prob??

    thanks...

  • What's the exact error message is in the SQL error log?

  • we always use a windows domain account as service account for our sqlserver instances.

    Are there firewalls involved ? If yes, did you open the needed ports ?

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • HI Andrew..

    wen im configuring mirroring i got this error..

    The server network address "TCP://MOSSSQL-B.mycompany.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:1418)

    what is the prob? how to solve?/

    Thankyou

    shiva

  • You need to test network connectivity to the endpoint.

    Follow the troubleshooting steps under Endpoints heading here: http://msdn.microsoft.com/en-us/library/ms189127%28v=sql.105%29.aspx

    If that's all fine, then use Telnet (it's a Windows 2008 feature, so install from Server Manager/Features).

    Open a cmd prompt and run:

    telnet MOSSSQL-B.mycompany.com 5022

    If a blank screen appears, all good, you have a connection on port 5022, if you get an error then you know there is a network connectivity issue / firewall / antivirus etc.

Viewing 5 posts - 1 through 4 (of 4 total)

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