If a password is set, generally it means people are matching on the server, or want to keep it private for some reason. It's to keep random players from joining in. If you don't know the password, it means you probably shouldn't be playing on that server. If you do know the password (ie: a friend gave it to you so you could start up a private game), simply type "password <password>" at the console as SkAtEr said.