I installed the microsoft sql server 2005 in my computer, with firewall switched off, and IIS on.
I have set up a log in account and linked it to a user of a database. The log in mode is set to mixed windows and sql server authentication.
The problem now is I can't log in using the sql server authentication at all. (windows authentication is fine though). It should be possible to log in on the same computer with server authenticaiton?
Please give me your advice. Thanks