MS Access 2010

Hello! I'm having an issue with connecting to my Access 2010 database through SQL Server 2008 Report Builder 3.0. I attempted using the 2007 connection string but it keeps failing. I have it set up the following way. Please let me know if you have successfully connected to your database and what steps you took to accomplish it. Thanks!

Data Source Type: OLE DB
Connection String: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\ProjectTracking\CurrentProject.accdb;
Credentials: Windows Authentication

Error Message: This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode.

0 answers