Add User to SQL Server Express?

Ok, I need to add aspnet user to my database in SQL Server express. I have the SQL Server Mangament Tool Express CTP that i am using to do it.
Anyway when i go to add the permissions for my user to the table I type it in and it returns back that there is no user that exists with that name. I then went to the top level for SQL Server Express and it has the ASPNET user. I don't understand why the engine itself can see it and use it but not my individual database.
The quick answer is there are two permissions to a SQL Server database the server permissions created under the sercurity section and the database permissions I think you have created the database permissions not the server permissions. try the link below download the eval version and install it as a named instance and use the full management studio to create the server permissions in the Express edition. hope this helps.
http://www.microsoft.com/sql/downloads/trial-software.mspx|||So basically install SQL Server again? along with the Managment tools? Is there anyway to install just the managment tools?
|||Ok, I got the Managment tools installed. Took a bit dang thing kept wanting to install SQL Server trial.
Anyway, I am still running into the same problem. I can't seem to add the ASPNET user to the database itself. It is added the server permissions and to the sample databases, but I must be missing something somewhere because for the life of me can't figure out how to add the user to the database.
|||

I think you should install the full eval version because I just checked mine the database login is in security section inside the database and the server login is in the old SQL Server 2000 security section. The installation is completely automated after you choose the components to install the installer will do everything for you so I think you should install it. Hope this helps.

|||Thank you for your help that last post helped a lot. I feel stupid now lol.
I didn't even think to go to the security folder to add a new user. I was just right clicking on the database folder and going to permissions. It think this will be one thing i won't forget.
Thanks for the help. If these forums had a rep system I would definatly be giving you some. this little problem has stopped my development all day long.
|||I am glad I could help.