How to transfer ConfigMgr 2007 ASP Reports to Reporting Services

Once you've installed the Reporting Services Point you may find that the Copy Report Wizard (transfer your ASP reports to Reporting Services) is not enabled. There is an additional step involved... you need to configure the reporting services properties from the ConfigMgr 2007 R2 MMC.

Select your Reporting Server, right click, choose Properties:

1MMC Server Config0

Choose the Data Source Settings tab, verify that you have a Server name and Database name set. If you add these two pieces of information, click the Test button to verify the connection.

1MMC Server Config2

Note that if you are using a database instance other than the default instance, it would take the form of Servername\InstanceName. Be aware that there are certain limitations with the R2 MMC when using an instance other than default.

Modify the default setting, otherwise the end consumer of reports will get prompted each time.

1MMC Server Config3

At a minimum use the Windows Integrated security option for seamless end user experience:

1MMC Server Config3b

You should now be able to transfer reports using the transfer reports wizard.

1MMC Server Config6

Published Friday, May 15, 2009 5:07 PM by sthompson
Filed under: , ,

Comments

No Comments
Powered by Community Server (Commercial Edition), by Telligent Systems