J J-man Aug 16, 2003 #1 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.
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.
