The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P46: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Managing High Availability Chapter 6 207 Figure Database Mirroring Menu Once you get the Database Mirroring page on the screen the first thing you must do is click the Configure Security button. This button will present you with a wizard which will walk you through the process. The key screens will be shown here the others merely described. After clicking Next on the introduction page you are asked if you wish to configure security to include a witness server instance. After clicking Next you are prompted with a page with the Principal and Mirror checked and grayed out with the Witness server either checked or grayed out. If you select No on the first page then this page is skipped. On the next page you are asked to configure the Database Mirroring Endpoint as shown in Figure . This is the endpoint that will be created on the Principal server that the Mirror instance and Witness instance will use to contact the Principal instance. Port 5022 is the default TCP port number however this port number can be changed to another port number if required. You can also change the Endpoint name if you so desire. 208 Chapter 6 Managing High Availability Figure Database Mirroring Principle Server Endpoint Configuration The next page asks you to select the Mirror server instance and set its port number and Endpoint name. If the instances are on different physical servers it is recommended that you use the same port number because this keeps your configuration less complex. If the instances are on the same physical server then you will need to select different port numbers since only one instance at a time can use a single port number. If you have selected to use a Witness then the next page lets you select the instance to use as the Witness instance as well as the port number and name of the endpoint. The same rules about port numbers apply. The next page asks you for the service accounts of the SQL Servers. If the machines are on the same domain or the domains are .
