Using TADOConnection with MSSQL, login failure



I finally got a TADOConnection object to connect to my MSSQL database at design time. I can even hook up a TADODataSet->TDataSource->TDBGrid and see data.

However if I try to run the application (Delphi7) I get an error: "Login failed for user XYZ"

Why does it work at design time but not run time? Any ideas?

srdaniel
.