SEARCH
0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Prev | Current Page 397 | Next

James Luetkehoelter

"Pro SQL Server Disaster Recovery"


CHAPTER 8 n DATABASE MIRRORING 213
The first step in configuring database mirroring is to launch the Configure Security
wizard, as shown in Figure 8-14. Personally, whenever presented with a wizard, I??™m a bit
concerned that I need to have all of my ducks in a row before beginning it. (If you??™ve ever
installed the original release of Reporting Services, you know what I mean.) However,
there??™s no need for concern here, unless you intend to mirror across untrusted Active
Directory domains. For simplicity and your sanity, I won??™t attempt that in this walkthrough
(say, ???Thank you, James???).
Figure 8-14. The key to configuring database mirroring is this Configure Security button,
which automates the creation of TCP endpoints.
CHAPTER 8 n DATABASE MIRRORING 214
Oddly enough, the Configure Security wizard gathers a significant amount of information,
some of it seemingly irrelevant to security. This wizard is actually configuring
endpoints, which need to be secured. I guess the Create Endpoint wizard would be a bit
of an esoteric wizard name for the average DBA.
As you can see in Figure 8-15, the wizard first determines whether or not a witness
instance is required.


Pages:
385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409