You can take the SIE exam as many times as possible. After the first failed attempt, you'll have to wait 30 days to take the exam. For the second failed attempt, you'll wait for 30 days. The third and the subsequent failed attempts require 180 waiting days.