#2 Login failed .... why...

[Derek Done]

I have extracted to wwwroot and tried entering in
the "Server Address": DSN, dbname, server node name,
node ip. Nothing works.

In the user and pass. Ive tried entering either a local
admin account or the msde assiged 'sa' and
password 'test'. This also doesnt work.

Please advise

The server address is: http://ymi.homeip.net:8888

[Nobody/Anonymous]

Logged In: NO

I'm experiencing this problem with no 'sa' like accounts. So we
have users who own a database who can login sometimes but
most of the time get login failures even though the id and
passwords are correct. Is there a requirement in the sql
server setup for a user to login correctly?