Trouble connecting user with MS Access adp to SQL Server 2000

From: Joe (anonymous_at_discussions.microsoft.com)
Date: 01/26/04

  • Next message: Neil Pike: "Re: SQL_SSRP_Slammer_Worm on Windows 98 SE" 
    Date: Sun, 25 Jan 2004 16:56:04 -0800

    I've created a Access adp database. As administrator I can log in and run DB, but the user I added "JT" as a "power user" cannot connect to the tables. The Access adp opens, but I get the message "MS Office Access could not log on to the server. Verify that the log on information is correct."

    The Access ADP will open showing the forms but not the tables. When I test the connection of the Access adp as "JT", I get the message "Test connection failed because of an error intializing provider. Log in failed for user JT" If I test the connection as "Administrator" it says "connection succeeded."

    I have the SQL server database set to "Windows authentication mode", and I have no problems logging on to the server as user "JT". I've checked & double checked all securtiy settings & user permission settings for SQL server & the database and JT is in there with the appropriate permissions.

    I've read the help sections on logging on with Windows Authentication & as Server passwords. They don't seem to explain my predicament.
    What should I do next?
    I'm a newbie to SQL Server 2000 & not a computer programer. Please give simple answers.

  • Next message: Neil Pike: "Re: SQL_SSRP_Slammer_Worm on Windows 98 SE"