You can publish your SQL Server and its databases in an active directory. This is not required, and is useful primarily if you write applications that pick a database dynamically from the active directory. (sort of like selecting a printer to print something). You need this service to keep the active directory up to date.
Regards,
Andras
Andras Belokosztolszki, MCPD, PhD
GoldenGate Software