Make sure that the account that SQL is using has the rights to log onTodd said:I am connecting with SQL 2000. The .adp file is set up to
the correct SQL Server and database and the identity is
through NT integrated security.
The test connection fails giving the following error:
Test connection failed beacause of an error in intializing
provider. Cannont open database requested in login 'my
login here'. Login fails.
services. You might need to reset the password on the account to have
it take. That's what worked for me.