These ports are not reserved or defined in the way that SQL Server has a reserved port
(1433, which incidentally isn??™t used by default in SQL Server 2005), but you must define
and hard-code them explicitly. You cannot have dynamic ports when it comes to database
mirroring.
You should know what ports to use before you even begin setting up database mirroring.
Yes, you could use whatever points you want at the time of installation, but your
network administrators may be more than a bit unhappy with you. As you??™ll see in Chapter
10, ensuring that there is connectivity from one server to another over a specific TCP
port is no trivial task. Simply picking a port number without first discussing your specific
needs with your networking staff is not only unwise, it??™s also rather rude.
nTip For a list of reserved port numbers, go to www.iana.org/assignments/port-numbers. This is an
old list, and a number of the reserved ports no longer have a corresponding application. Still, only use ports
that are listed as ???unassigned.???
Endpoints
When configuring database mirroring within the GUI, you can simply put in the TCP port
number to use.
Pages:
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386