Login Troubles

I am trying your product out to see if it will help me take a project I'm working on to the next level. I am making a on-line registration for my work with Special Olympics. I used a MS Access database and have one running on asp. But I would like to move up to SQL so that I can make it a more "live" site. I have their management software configured to go to a SQL Server. Everything seemed to be OK through the compile, but when I try to login I keep getting invalid login. I have a table set up in SQL that has the userid (varchar,15) password (varchar,10) association (Varchar,10) Level (char,5) - pretty sure it is me but can't seem to find the answer - any help someone could give would be appreciated