Re: Error initializing provider - test connection failed.



Todd 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.
Make sure that the account that SQL is using has the rights to log on
services. You might need to reset the password on the account to have
it take. That's what worked for me.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question