Solved : Database Mirroring Status disconnected issue (Principle, Disconnected)

If you get message like disconnected on Principle server of Mirroring you can try below options, the basic option is try below options

  1. Restart SQL server Service on Principle server if still it is having same status.
  2. Re-initialize Mirroring manually by clicking on Configure Security button if still it is having same status.

Then it indicates issue is at Mirrored Server, so you will need to try below

  1. Take remote of Mirrored Server
  2. Start -> run -> Services.msc
  3. Check for SQL server browser service is running or not , make sure it is running
  4. Ensure that windows firewall service is stopped. If not stop it
  5. Restart SQL server service

You will see Status changed from Disconnected to Synchronized J

Thanks

 

Prashant Deshpande

 

 

 

 

 

 


 

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s