While configuring the Data Source Settings for Jet Express, I'm getting the following error message when I run the "Test Connection" function: "The data provider returned the following error: unable to open database file"
We're running NAV 2015 and using the "Dynamics NAV 2013 and later (SQL Server)" option for our Data Source Type.
This was working a few weeks ago, with what I believe are the same configurations (screen shots from the working configuration look the same), and I'm not aware of any obvious changes that have taken place to the database or our NAV configurations.
I know I get completely different error messages if I intentionally configure any of the following Data Source Settings fields in a manner I know is wrong: Server, Database, and all fields on the Authentication tab.
This basically only leaves the Company field. I also receive the same message if I leave the Company field completely blank.
Another tidbit that may or may not be important, when I click on the drop down for the Database, I see various databases on the server, but when I click on the Company field drop down, I don't see anything come up. I don't remember if this is how it behaved before or not.
Any ideas on what my problem might be?
Thanks,
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello archdixon,
In order for users to utilize the "Dynamics NAV 2013 and later (SQL Server)" Data Source the user must be added to the root security of the SQL Server Management Studio and mapped to the NAV 2013 database with db_datareader permission and a public role (see attached).
You can do that or you can use a proxy user to gain db_datareader access to the database.
You can either create one SQL Server user with db_datareader access or create one Windows AD user with db_datareader access (e.g. one of your database administrator's AD accounts).
In the Jet Data Source Settings switch to either "SQL Server Authentication" or "Windows Authentication (other user)" and enter the appropriate credentials.
Configuring a data source to NAV 2013 or later through SQL Server:
Requirements for using the Dynamics NAV 2013 SQL Server Connector: http://kb.jetreports.com/article/AA-00915
Configuring Jet Essentials for the Dynamics NAV 2013 SQL Server Connector: http://kb.jetreports.com/article/AA-00902
Best regards,
MWilson
-
Jet Reports Historic Posts Hi MWilson,
Thank you for your response. I had already sorted out all of the root security in SSMS, previous to me getting this test connection error–it had been working properly before this issue.
Anyway, I got this fixed, so I wanted to document what I had to do (in case it's helpful for someone else in the future).
Basically, I had to uninstall Jet Express and reinstall it. After doing this it worked just fine–all with the same configurations I was using before the uninstall/reinstall.
An important note–when I uninstalled Jet Express, Excel broke and wouldn't run any more. We had to fix Excel by running the Microsoft Office "Repair" function (available, I presume, when you run the MS Office 'Setup' file and there are already Office components installed on the computer).
Hope that's helpful to someone sometime so they don't spin their wheels on this issue as long as I did.
Please sign in to leave a comment.