Login windows 7 with sql server

Question

Hi all

     how to login system through sql server,  there is a table contains column [useriId], [password],[active] for  the userId is 10101 with the password "Welcome" and he is an active user .
so the users who r in active only can login to system , can anyone tell how to achive this

                

UserId	Password	active
10101	Welcome	Y
10102	Welcome	Y
10103	Welcome	N