Microsoft Dynamics GP (Archived)

"The SQL Server Reporting Services setup information is not valid"

(0) Share

Report

Posted on by Harold Worby

1,331

I get the message "The SQL Server Reporting Services setup information is not valid"

When I try to deploy Reporting services in GP2010

I've do this before with success in a single server enviroment.

This is a new Dynamics GP Server ,

Setup:

GP Server :Windows 2008 R2, SQL 2008 R2, Named instance

Report Server :Windows 2008 R2, SQL 2008 R2, Named instance

From the GP Server, logged in as Domain Administrator I can open the MSSRS Url in IE without an issue.

from GP/Tools/Setup/System/Reporting Tools Setup I get the above message

I've also tried Deploying from a Terminal server as Administrator with the same results.

and I've tried using other logins to no avail.

any Ideas?

*This post is locked for comments

I have the same question (0)

All responses (24)

Answers (1)

Suggested answer

rudra 6,534 on at

Like (0)

Report

Try running Dynamics GP as an administrator, then deploy the reports.

Also please refer the below link:-

lewict.wordpress.com/.../great-plains-2010-r2-sql-server-reports

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Horby,

please launch GP as Run as Administrator. Depending on your configuration, that may be necessary.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Make sure you have the correct paths for the reports:

http://SQLInstancename/ReportServer

http://SQLInstancename/Reports

If you have a named instance make sure you specify the full instance name and not just the server name.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

If you are running a named instance make sure you copy the paths exactly as they are setup inside of your Reporting Services Configuration Manager. In my test environment I have a named instance so it reads as the following

http://corp-zenbook/ReportServer_TESTBED

http://corp-zenbook/Reports_TESTBED

corp-zenbook is the server name and / TESTBED is the instance name.

Was this reply helpful? Yes No
Harold Worby 1,331 on at

Like (0)

Report

I'm logged in as Domain Administrator, Select Run-As Administrator on the GP Shortcut and sill get the

'The SQL Server Reporting Services setup information is not valid' message

If I take the URLs I'm entering and past them into IE they work.

Server http://ctb-application/ReportServer_SQLREPORTS

Manager http://ctb-application/Reports_SQLREPORTS

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The report server mode is set to Native correct? The only other reason I could see getting the above error message would be security. Can you validate by browsing to the report server and verify under the folder security that your Domain Admin account can create a new folder on the report server? Verify the folder you are also deploying to is setup to allow for Domain Admin to publish. In SSRS you have the ability to inherit permissions from the parent folder or you can choose to not inherit them.

Was this reply helpful? Yes No
Harold Worby 1,331 on at

Like (0)

Report

Yes the Mode is Native, Yes the user can creat/delete folders in SSRS throubh the browser on the same machine I'm trying to use to deploy.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

When you opened IE to validate the ability to create folders on the report server where you right clicking on IE and running as Administrator? If so can you try the same process again without running as Administrator?

Was this reply helpful? Yes No
Harold Worby 1,331 on at

Like (0)

Report

Right now I'm logged in the WIN2008R2 server running SQL Server for the GP Databases as Domain Administrator and running Dynamics as sa.

There are other reports on the SSRS server that use the GP database and I can run those by simply clicking on IE then on the Report. SQL Server Reporting Services is my homepage.

I can run reports as other non-admin domain users.

Can not deploy GP reports

If i look in the SSRS Logs ( on different server in same domain ) I don't even see the Dynamics contacting the SSRS server when I click Deploy I just get the 'setup information is not valid' message.

The URL is the only 'setup information' there is, right?

Guess I should have mentions this before, the reports had been deployed to a different server before os under 'deployment options' Reportin Tools Setup shows some reports as deployed and I'm trying to re-deploy.

Is ther someway to reset the Dynamics database and restart from scratch?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I would think that GP would deploy the reports again over writing what values are present. But you can see what report server is currently setup by running the following statement.

USE DYNAMICS

GO;

SELECT * FROM SY40800

If you are going to modify the columns to blank them out then I'd also suggest a backup of the Dynamics database.

Was this reply helpful? Yes No