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.
Best Answer
Did you also change the Server to use Mixed Mode rather than just Windows Authentication? If so, you need to restart the server for this to take effect.