Problems setting up database mirroring on sql server 2005

Question

hi team, need help facing error while data mirroring .

fire wall disabled on both the server
both the sql services and agent services are running with the same account(admin)
port are working , confirmed by using netstat -t command
configuration,db name, os, sql server all are same
alter database test set partner = 'TCP:/mirroed:5023' on primary server

![error text][1]

Answer 1

Please check that the settings are correct, especially in the ALTER DATABASE command.

The one you supplied has a typo, so if you copied that from SSMS you may have the solution already:

it has to be TCP://<system address>:<port> You have one slash missing and the word mirrored is written wrong (this may not be a problem if the partner is spelled that way though).

Please also make sure that the system address exists. Normally you would use a fully qualified domain name or IP address to make sure you are connecting to the right partner.

Take a look at Setting Up Database Mirroring and make sure you have all pre-requisites setup, then double check spellings etc. It will probably be something really obvious that you just aren't seeing.

Problems setting up database mirroring on sql server 2005

Follow this question

Related Questions