This was my another mirroring Project, but this time i got stuck with the following message:

Mirroring Setup = Principal and Mirror with NO WITNESS using HIGH SAFETY MODE (don’t ask)

The server network address "TCP://SERVER667.DOMAIN.DROP.com:5023" 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).

I Tried several Tricks of adding NT ID to both of these Servers as SYSADMIN. But Still did not work. I Tried Dropping the Mirroring and Re-Creating it again, but still the Same Issue. I also tried Changing the Ports, but no success.

Finally I checked these 2 Installation as these were fairly new and found the SQL Services were running as Local Services. I change them to use my usual DOMAIN Accounts and then tried setting up the Mirroring Again and it WORKED this time..

image

Some more issues related to mirroring are covered here nicely. I Like this guy. (In technological sense)

http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx

Here is a Shot of Database Mirroring Monitor

image

We will be using the Rep_TestDatabase database for this exercise and Setup Mirroring with Principal and Mirror without a WITNESS.

I will be using windows Authentication in this example.

image

Right Click –> Properties OR Right Click —> Tasks –> Mirror

image

Click on configure Security –>

image

image

image

image

image

image

Leaver the Service Accounts to default, if you are not setting up some fancy security.

image

image

Immediately after the Close button, the Database Properties to Start Mirroring dialog appears.

image

Here are several Error situations, i wanted to capture.

This First one occurs if you have not restored a backup of the database to the Mirror Server.

image

Create a Full Database Backup and Restore it on the Mirror Server using WITH NORECOVERY Option.

image

This error is generated if the Database is SET to Read_only Mode.

After the Complete Stage has been setup, Click “Start Mirroring” once the Mirroring has been started successfully

it will be as seen in this window.

image

© 2010 D B A N A T I O N Suffusion WordPress theme by Sayontan Sinha
Better Tag Cloud