I got the answer on experts-exchange. It turns out I needed to use SQL Authentication, not Windows Authentication. Everything is working now. Thanks.

The dumb thing I was overlooking was that I had to re-install the server from scratch and never upgraded to Service pack 3a. As soon as I did, the problem...