Login windows 7 with sql server

Step1
you need to authenticate yourself against db, e.g., sa/password123

if you're on Windows you can also use Integrated Security=true; in this case you dont need any username/pwd

Step2
Then create a system in .Net which connects to your db, use MVC pattern

Step3
In web.config have connection string which will point to it

Step4
Create login form which will accept username/pwd what you mentioned in your table. Now upon click you can check userid/password and see if Active is Y or not

select * from table1 where userid=10101 and active = 'Y'