Problems with Reporting Services - Execution account - Access db not working

• sandstr

  SSC Rookie

  Points: 32

  More actions

  November 10, 2023 at 10:42 am

  #4325099

  Hi,

  Im trying to set upp a datasource against a Access db. I can access the database when selecting "As the user viewing the report" but not when selecting "Without any credentials". I have even tried setting up the execution account with my admin user but I get the same error message:

  "ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Your network access was interrupted. To continue, close the database, and then open it again. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Your network access was interrupted. To continue, close the database, and then open it again."

  I´ve set the ODBC permissions for the execution account.

  The connection string looks like this "Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=c:\path\database.mdb;   (the database resides on the same server as the reporting services)

  I´ve also added the execution account with modify rights to the path and database.

  What am I missing?

• November 10, 2023 at 11:54 am

  This was removed by the editor as SPAM

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  November 11, 2023 at 11:10 am

  #4325726

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Lisa Slater Nicholls

  Hall of Fame

  Points: 3461

  More actions

  November 20, 2023 at 8:53 pm

  #4331310

  Take a look at the connection strings here https://www.connectionstrings.com/access/, I am definitely no expert on accessing Access (in fact, when I get it right, it's usually because I've put another layer in between and don't access the mdb directly in RS), but you'll notice one of their examples says:

  Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;

  ... or maybe one of the examples there that uses Jet instead of Microsoft Access Driver will have better results for you?

   

  >L<