Problem in implementing mirroring

[cmrhema]

Hi, All

I underwent the following Steps for creating a mirror in sql server 2005.
1. Downloaded and isntalled sp2 in principal,mirro r as well as witness servers
2. Created a new database named it as FinalMirror
3. Right clicked on the database Tasks-backup-BackupType--Full--Ok created FinalMirror.bak
4. Right clicked on the database Tasks-backup-BackupType--Transactional Log--Ok created FinalMirror-Transaction Log Backup(both of the files are under the same name FinalMirror.bak )
(Also Tried to create backup seperately as final1.bak and finaltrans.trn)
5. Copied this finalmirror.bak from my system to the Mirror Server.
It was stored in the Principal server in the following location
C:\Program Files\Microsoft SQL Server\MSSQL.1\ MSSQL\Backup

6. Right click on Mirror Server Database--Restore Database --Manually wrote down the ToDatabase
7. Selected from device and selected the added the copied backup file
8. Performed a restore --select the relevant backup--checked the checkbox on restore

(Did it individually for backup and transactional log)
(Tried with finalmirror.bak for backup and transactional log also tried final1.bak and finaltrans.trn)
9. On the left panel selected the Options and choosed NO RECOVERY
(In the mirror database its displayed as FinalMirror(res toring))
10.performed mirroring and for witness unchecked the "encrypt option"

Mirroring on process

but after I click the start mirroring button in the Mirror server the database is shown as FinalMirror(In Recovery)



It ends up with an error 1418

"The server network address "TCP://dddd.abcdIT:502 2" can not be reached or does not exist"



I have set the norecovery option too.



where am i going wrong
please help

regards
cmrhema

[ck9663]

Hi, All

I underwent the following Steps for creating a mirror in sql server 2005.
1. Downloaded and isntalled sp2 in principal,mirro r as well as witness servers
2. Created a new database named it as FinalMirror
3. Right clicked on the database Tasks-backup-BackupType--Full--Ok created FinalMirror.bak
4. Right clicked on the database Tasks-backup-BackupType--Transactional Log--Ok created FinalMirror-Transaction Log Backup(both of the files are under the same name FinalMirror.bak )
(Also Tried to create backup seperately as final1.bak and finaltrans.trn)
5. Copied this finalmirror.bak from my system to the Mirror Server.
It was stored in the Principal server in the following location
C:\Program Files\Microsoft SQL Server\MSSQL.1\ MSSQL\Backup

6. Right click on Mirror Server Database--Restore Database --Manually wrote down the ToDatabase
7. Selected from device and selected the added the copied backup file
8. Performed a restore --select the relevant backup--checked the checkbox on restore

(Did it individually for backup and transactional log)
(Tried with finalmirror.bak for backup and transactional log also tried final1.bak and finaltrans.trn)
9. On the left panel selected the Options and choosed NO RECOVERY
(In the mirror database its displayed as FinalMirror(res toring))
10.performed mirroring and for witness unchecked the "encrypt option"

Mirroring on process

but after I click the start mirroring button in the Mirror server the database is shown as FinalMirror(In Recovery)



It ends up with an error 1418

"The server network address "TCP://dddd.abcdIT:502 2" can not be reached or does not exist"



I have set the norecovery option too.



where am i going wrong
please help

regards
cmrhema

Try creating the two database manually first. Test the connection between the two servers, manually. If you can connect to the two servers manually, there's something wrong with your mirroring config, not just the db.

-- CK

[cmrhema]

Try creating the two database manually first. Test the connection between the two servers, manually. If you can connect to the two servers manually, there's something wrong with your mirroring config, not just the db.

-- CK

I can very well connect the two servers manually. Once again putting forth the steps that would enable the readers to analyze my problem and reply



I underwent the following Steps for creating a mirror in sql server 2005.
1. Downloaded and isntalled sp2 in principal,mirro r as well as witness servers
2. Created a new database named it as FinalMirror
3. Right clicked on the database Tasks-backup-BackupType--Full--Ok created FinalMirror.bak
4. Right clicked on the database Tasks-backup-BackupType--Transactional Log--Ok created FinalMirror-Transaction Log Backup FinalMirrorlog. trn

5. Copied this finalmirror.bak ,FinalMirrorlog .trn from my system to the Mirror Server.
It was stored in the Principal server in the following location
C:\Program Files\Microsoft SQL Server\MSSQL.1\ MSSQL\Backup

6. Right click on Mirror Server Database--Restore Database --Manually wrote down the ToDatabase
7. Selected from device and selected the added the copied backup file
8. Performed a restore --select the relevant backup--checked the checkbox on restore
9. On the left panel selected the Options and choosed NO RECOVERY
(In the mirror database its displayed as FinalMirror(res toring))
10. Underwent the above two process 8 and 9 for transaction log
11. performed mirroring
Mirroring on process

but after I click the start mirroring button ,

I have the error 1418
Error: 1418 - Microsoft SQL Server - The server network address can not be reached or does not exist. Check the network address name and reissue the command. The server network endpoint did not respond because the specified server network address cannot be reached or does not exist.

in the Mirror server the database is shown as FinalMirror(In Recovery)


Now i tried out to netstat command
When i gave netstat -a
I could not see any of the servers other than mine
then i tried out netstat -abn
There were many details but none of the servers of the mirror or witness reflected

What is the problem?
Kindly help

Regards
cmrhema