Check your authentication methods. Open up Enterprise Manager, expand your SQL Server group, and Right-Click on the server. Select Properties from the drop-down menu, and select the Security tag.

Now, since it appears that you are using name/password security, make sure that you are using both SQL Server and Windows authentication. If you are not (you're only using windows authentication), then select the mixed-mode auth option, and click OK.

Try it again.