System Message 10500

(0) Share

Report

Posted on by Brian Busbey

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

All responses (1)

Answers (0)

Suggested answer

Blaine Bryant on at

Like (0)

Report

Re: System Message 10500

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.