Re: Error initializing provider - test connection failed.

J

J-man

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.
Click to expand...

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

Similar Threads

Access 2007 and ADP to SQL Server 2005 in Vista 12
Can't connect to local SQL Server 2005 from .adp 7
ADP Connection Issue 2
Access 2007 can't connect to SQL Server 1
Windows 2000 - MS Access XP and Sql Server 2005. 1
Additional SQL Link Fails for Trusted Logon 6
Open Connection error 1
Remote NT Login not working 5

Top