We just installed smartlist builder with excel reports. It seems that we can only publish reports if logged in as the sa. I have set up a security task and role and assigned them to users. But still only the sa can publish reports. Is there a workaround for this? Once these files are posted to a folder, the user is asked to enter the sa password to make the connection. Since I don't want to give out the admin password, is there another way?
*This post is locked for comments
If Microsoft Dynamics GP tables or SQL Server tables are added to the report, the report must be published by a user with SQL administrator privileges. All users can publish reports that contain only data connections.
You can give users additional privileges using SQL Server Management Studio. I don't know exactly which server role(s) should be added to the user, however.
The reports do run. I have rights to all the sql tables, but it still wants a password to the odbc connection.
Are the reports actually running? It is possible that they are based on SQL tables that the user does not have rights to?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (