I have a installed 2005 sqlexpress as well as express manager studio. I added a login under Logins, associated user with my database and gave it db_owner role under User mapping.
Now I right click on the server, under properties change from windows authentication to sql server authentication, enter login and password, click test and I get error:
Login failed for user... User is not associated.. Error: 18452.