SQL 2008 mirror configuration

thank you ,i will test it and let you know if it is working

Hi,

Below link is having detailed information:

http://technet.microsoft.com/en-us/library/ms190941.aspx

http://technet.microsoft.com/en-us/library/ms179306.aspx

http://technet.microsoft.com/en-us/library/ms189852.aspx

thank you, i will try it ASAP

if i want to configure a witness server for my mirror, how can i do it?

I got the error when i try to start mirror, i use sa to connect Principal server and mirror server, at the services account page, i fill SA for 2 server account.  any advice?
Mirror-Error.jpg

i also get the error event 1474 "Database mirroring connection error 5 'Connection handshake failed. The login 'CNSHSQL1\Administrator' does not have CONNECT permission on the endpoint. State 84.' for 'TCP://CNSHSQL2.ipsosgroup.ipsos.com:5022'." i did not ues administrator to connect endpoint, i login windows use domain admin and login SQL use windows authentication, how can i set the account to use to connct endpoint

What account is the db engine service running under?  It's going to try to connect to the endpoint under that context (my guess is that it's not running as a domain account).

Please review this: http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418.  It's a pretty exhaustive list of troubleshooting your initial error.

it is woking after i change the account for dbengine services, thank you. i will open other quesiton for how to setup configure a witness server and remove mirror, thank you again