I am thankful to everyone who were trying to help me.

There are three instance in my mirror/witness server and I ensured that none of the instance is using the witness...

I can able to setup the Prinicipal and Mirror and manual failover is also happening successfully. While adding the witness I am getting the error. Below are the script,

/*...

Sorry guys for replying late, I got struck with the auditing.

sayfrend - I am sure that I am trying with different port numbers for mirror and witness.

Krishna Potlakayala...

Steve - I was doing the same way how you had suggested all these times. Anyway I had removed the mirroring and re-configured in the same way how you...

The package which you had created is in 32-bit mode since your server is in 62-bit it was unable to run a 32-bit package. You have to use the...

While taking a full backup a internal status flag for full backup should get reset. Some times for some reason it will not get reset. Which will raise...

1. Open Sql Server Managment Studio

2. Connect the server

3. Expand Security

4. Expand Logins

5. Click on "abc"--> Right Click --> Properties

6. Under "Select a Page" select General and in the right...

Hi Mohit,

As per the site http://developmentalmadness.blogspot.com/2006/07/adventures-in-mirroring.html, I had changed the Primary and Secondary DNS server IP to be same in both Principal and Mirror/Witness Server but the result is...

Take a full backup.

You can check the training section of sql server central and google with your specific topic.

I thank everyone who were trying to help me.

As eng_mgomaa spoted, I had given the ROLE as Partner instead of witness. But after changing it also I am getting the...

Is the system is 64bit?

You can try Symmetric Key Encryption since you are using it in warehouse. Symmetric key is good in performance.

Refer this article,

http://blogs.technet.com/keithcombs/archive/2005/11/24/415079.aspx

If it is Windows Server 2003, right click the file --> properties --> Click on Unblock if enabled.

The Asymmetric Key Encryption uses dual key managment - Public key for encryption and private key for decryption while symmetric key encryption will use a single key for both. ...