Showing related tags and posts across the entire site.
-
[quote user="ikkyu"]I am sure one of the field is a unique ID which can be used to identify the company[/quote] No. If you have several companies, there is a set of (almost) all tables for each company. Each table name is prefixed with "Company Name $", for example: dbo.Company Name...
-
nav users just get the public role on sql. In order to query any tables, you have to give them dbreader role in enterprise manager.
-
I’ve got it figured out, there is a setting on the Crystal Server XI that allows me to set the database login credentials, as far as I know now this has to be done for each report put on the server.
-
I should also note that once prompted by Crystal Server XI the authentication fails and users cannot view the reports. I can view the directly in the Crystal Report application but via the web interface Crystal Server XI does not authenticate users to the NAV MS SQL database. I have tried to test both...