Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Invalid object name ...

Invalid object name 'dbname.sys.tables'. when launch Reporting Tools Setup

(0) Share

Report

Posted on by Community Member Microsoft Employee

Dear ALL,

I got an issue when i tried to launch Reporting Tools Setup on GP 2013 R2 and i got this error but after click OK i manage to launch Reporting Tools Setup. Can anyone, let me know why this error prompt out?

Thank you.

*This post is locked for comments

All responses (5)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Invalid object name 'dbname.sys.tables'. when launch Reporting Tools Setup

Hi everyone,

I think i know what is the problem already! This database is corrupted already and after restore again the error gone. Sorry everyone, for disturb you all.

Anyway, thank you very much for trying to help.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Invalid object name 'dbname.sys.tables'. when launch Reporting Tools Setup

Hi Soma,

Tried already but same error?
Suggested answer

soma 24,406 on at

Like (0)

Report

RE: Invalid object name 'dbname.sys.tables'. when launch Reporting Tools Setup

Try to login GP with "Run as Administrator".

Hope this helps!!!
Community Member Microsoft Employee on at

Like (0)

Report

RE: Invalid object name 'dbname.sys.tables'. when launch Reporting Tools Setup

Hi Jorge,

Yes i did login as 'sa'. I will check with SQL Profiler later.

Thank you.
Suggested answer

coquisalsa 2,725 on at

Like (0)

Report

RE: Invalid object name 'dbname.sys.tables'. when launch Reporting Tools Setup

Are you logging as 'sa' or POWERUSER?

SQL Profiler can help you to find the cause of the problem.