SQL Server Instance???

I have Visual Studio.NET 2003 Academic (Professional)
Edition Installed on my Machine.
First I need to confirm that when I installed VS.NET that it installed SQL
Server.

Here is my problem.



I open VS.NET and view the
"Server Explorer" window.Then under
"Servers" "lotr" is listed (lotr is the name of my
computer if that means anything as of right now).Next I expand
"lotr", and then go to the bottom of the list and try to expand
"SQL servers", but a "Microsoft Development
Environment" error window pops up. It reads "Could not
automatically discover and SQL Server instances. Choose Register SQL
Server Instance from the shortcut menu if you know there are SQL instances
on this machine."From there I am completely
lost and have no idea what to do, because I have never set VS.NET up
before and have little if any knowledge of SQL Server, but I do know if I
right click on "SQL servers" and choose "Register New SQL
Server Instance" it give me a "Register SQL Server
Instance" window and has the server name "lotr" entered
(not editable) and wants me to enter an "Instance Name". I was
told on another form to enter "(local)" and my computer name
("lotr") by another. either way after I would register the instance
when I try to expand it a "SQL Server Login" window pops up. The
"Server" reads "lotr" (not editable) and the
"Database" is blank (not editable), the checkbox "Use Windows
NT Integrated Security" is unchecked, "Login" says
"Administrator" and I do not know what to enter for
"Password". I have tried the administrator account password for
my machine, but all that happens then is a "Microsoft Development Environment"
window pops up. It read "[DBNETLIB][ConnectionOpen(Connect()).]SQL
Server does not exist or access denied."



Thanks A Lot,
MCCCStudent