question

ramesh 1 avatar image
ramesh 1 asked

Problems setting up database mirroring on sql server 2005

hi team, need help facing error while data mirroring . 1. fire wall disabled on both the server 2. both the sql services and agent services are running with the same account(admin) 3. port are working , confirmed by using **netstat -t** command 4. configuration,db name, os, sql server all are same alter database test set partner = 'TCP:/mirroed:5023' on primary server ![error text][1] [1]: /upfiles/errere.JPG
sql-server-2005database-mirroring
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
WilliamD avatar image
WilliamD answered
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:// : ` 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][1] 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. [1]: http://msdn.microsoft.com/en-us/library/ms190941(SQL.90).aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.