Homeostasis within the central nervous system (CNS) is a prerequisite to elicit proper neuronal function. The CNS is tightly sealed from the changeable milieu of the blood stream by the blood-brain barrier (BBB) and the blood-cerebrospinal fluid (CSF) barrier (BCSFB). Whereas the BBB is established by specialized endothelial cells of CNS microvessels, the BCSFB is formed by the epithelial cells of the choroid plexus. Both constitute physical barriers by a complex network of tight junctions (TJs) between adjacent cells. During many CNS inflammatory disorders, such as multiple sclerosis, human immunodeficiency virus infection, or Alzheimer's disease, production of pro-inflammatory cytokines, matrix metalloproteases, and reactive oxygen species are responsible for alterations of CNS barriers. Barrier dysfunction can contribute to neurological disorders in a passive way by vascular leakage of blood-borne molecules into the CNS and in an active way by guiding the migration of inflammatory cells into the CNS. Both ways may directly be linked to alterations in molecular composition, function, and dynamics of the TJ proteins. This review summarizes current knowledge on the cellular and molecular aspects of the functional and dysfunctional TJ complexes at the BBB and the BCSFB, with a particular emphasis on CNS inflammation and the role of reactive oxygen species.