i have the following situation:
Server NAV-SRV with SQL 2k8 and NAV 5.00 SP1
Server REPORT-SRV with SQL 2k8 and SQL Reporting Services
Database NAV "duplicated" with log shipping from NAV-SRV to REPORT-SRV
Problem: When i use a report with a data source on the "standby" NAV database on REPORT-SRV i get error messages that i have no access to the specified table. (User has rights in NAV to do so).
If I change the data source to the NAV-SRV i can open the report with no error message (before I synced the NAV Users to SQL)
Question: How can i sync the NAV Users inside the Database on REPORT-SRV to the SQL users so i can open the table on that local Database?
Thx for your help ....