ASP.net and SQL Connection

I'm changing our website to asp.net but having real problems getting started.
I've created a new login page and I want to authenticate users against a table
in my SQL DB. I've created a DB connection to my db. It says it connect find
but when I go under Appliication > Databases > Tables none of the tables show
up. When I do the same DB connection with my file as a straight asp file then
I see the tables. I really need to get this going. Your help is GREATLY
appreciated. Thanks J