ASP can not connect to SQLExpress

[sdcwa]

I am trying to connect to IIS + SQLEXPRESS + ASP

There is a global.asa with the following connection string:
"Provider=SQLOLEDB;Server=.\sqlexpress;Database=Prop_SDCWA;uid=sdcwaprop;pwd=sdcwaprop;"

I am not able to connect. The lof file has this:
2011-03-28 12:16:59 192.168.1.30 GET /prop_sdcwa/Login.asp |61|80040e4d|Login_failed_for_user_'sdcwaprop'. 80 - 192.168.1.30 Mozilla/5.0+(Windows;+U;+Windows+NT+6.0;+en-US;+rv:1.9.2.16)+Gecko/20110319+Firefox/3.6.16+(+.NET+CLR+3.5.30729) 500 0 0 46

The user was created in SQLEXPRESS.

Any ideas?

thanks,

Nestor

 

[emozley]

Have you tried logging into SQL express via a console to test the username and password?