Using JetExpress, the Test Connection appears to work (417ms) and the Data Source Settings look normal for Dynamics NAV 2013 and later (SQL Server)
But when I write a simple GL formula it results in an #VALUE! error.
On debugging, the first two lines read as follows.
An unexpected error has occurred:
Login failed for user 'DOMAIN\username'
Any pointers would be much appreciated!
Thanks
Date
Votes
7 comments
-
Jet Reports Historic Posts What Authentication type are you using in your Data Source Settings for connecting to the NAV database?
-
Jet Reports Historic Posts Hi
I am using "Windows authentication (other user)".
Our IT Dept have created a user called "navadmin" and this is specified as the username.
The account whose NAV roles and permissions are used is "Windows authentication (current user)".
Hope this helps to pinpoint the problem. -
Jet Reports Historic Posts Hello Shameil,
Can you verify that the user account you are specifying after choosing "Windows Authentication (other user)" has db_datareader access to the NAV database on the SQL Server?
Best regards,
MWilson -
Jet Reports Historic Posts Hi, yes the navadmin user does have db_datareader access to the database that I am trying to connect to.
-
Jet Reports Historic Posts Hello Shameil,
Can you attach a screenshot of the Authentication tab of the Data Source Settings and a screenshot of how the user is configured in SQL Server Management Studio?
Best regards,
MWilson -
Jet Reports Historic Posts Hi MWilson
Apologies for the delayed response. Screenshots are attached of the Authentication settings and the connection account (navadmin).
When we kept getting the #VALUES! error, we experimented with adding the current user to SQL Server and this seemed to solve the problem - screenshot attached. However, our IT Dept is not keen to add all JetReport designers to SQL Server - is there a recommended way to configure JetReports/SQL Server?
Also, Jetreports is running very slowly but that's a topic for another day…
Many thanks for your help -
Jet Reports Historic Posts Hello Shameil,
What I would recommend is to check if your SQL Server is set for 'Mixed Mode Authentication' (SQL Server and Windows Authentication).
If it is, create a single SQL Server user (not a Windows AD user) in the root security of SSMS and give that user db_datareader permissions to the NAV database.
Open Windows Explorer type %APPDATA% in the address bar and press enter (this brings you to C:\Users\Username\AppData\Roaming).
Delete the 'Jet Reports' folder.
In the Jet Data Source Settings choose your data source, switch to 'SQL Server Authentication', add the credentials and test your connection.
Best regards,
MWilson
Please sign in to leave a comment.