You’re offline. This is a read only version of the page.
710
Dynamics SL 2011 SP1 via TS.
When trying to access Quick Query Viewer in the Administration>System Manager>Maintenance module we are receiving the following error when any user (even logged into the server directly) tries to access it:
System Message 10500
Connection failed for procedure GetViews, has the report user been granted rights to your SQL View?"
Haven't ever seen this before and having a hard time finding a fix. We haven't changed any permissions on the SQL server side of our SL 2011 setup. Not sure what's causing this.
Any ideas?
*This post is locked for comments
I have the same question (0)
Hello,
The first thing I would like to try to do to fix this problem would be to sync ownership and security in the update tab of DB Maintenance. In case you do not know how to do this the steps are as follows (It is best if no one is logged into SL while performing this):
1. Click Start > Control Panel > Administrative Tools > Microsoft Dynamics SL Database Maintenance
2. Make sure the SQL Server Name textbox has the correct server displayed
3. Login
4. Go to the “Update Databases” tab
5. In the pane on the right select “Synchronize All Ownership & Security”
6. Make sure all users are logged out of SL
7. Click the “Update Database” button
After this is completed try to recreate your error and then send me a Screen shot of any errors received.
Share
Report
All responses (
Answers (
