Sharepoint and Reporting Services Integration - Set-up

Question

Hi All,
I am having major issues setting up my environment (run in one issue after another)

- I have my sharepoint, reporting services and reporting services addon on the one server
- my sharepoint databases point to a sql 2005 server
- my reporting services points to a sql 2008 server

I am following steps here
http://msdn.microsoft.com/en-us/library/bb677368.aspx

When I am trying to complete "Grant Database Access" I see the error
     "Unable to connect to the Report Server WMI provider."

I read somewhere that the sql 2005 database may not work with the 2008. 

So I tried to follow steps from
http://blogs.msdn.com/shaden/archive/2007/07/05/moving-the-sharepoint-databases-to-a-new-sql-server-instance.aspx

Now I cannot even do a full backup as I see the error
Object WSS_Search_CAM01MOSS failed in event OnBackup. For more information, see the error log located in the backup directory.

I am at a loss.  Could somebody point me in the right direction... or super doopa instructions?
Thanks
Kez

---

DBA

Answer 1

ssrs questions go to Business Intelligence.

Moving this.

---

WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx

Answer 2

Hi Kez,

 

Do you use Windows Server 2008? If yes, it’s a known issue that you might receive this error message. This happens because User Account Control (UAC) in Windows Vista and Windows Server 2008 requires explicit acceptance from an administrator to elevate and use the administrator token when performing tasks that require administrator permissions. In this case, however, the Windows SharePoint Services Administration service cannot be elevated to grant the Reporting Services service account or accounts access to the SharePoint configuration and content databases.

 

You can try the workaround below to manually grant database access:

1.         Add the Report Server service account to the WSS_WPG Windows group on the Reporting Services computer.

2.         Connect to the database instance that hosts the SharePoint configuration and content databases, and create a SQL database login for the Report Server service account.

3.         Add the SQL database login to the following database roles:

l  db_owner role in the WSS Content database

l  WSS_Content_Application_Pools role in the SharePoint_Config database

 

For more information, please refer to:

http://msdn.microsoft.com/en-us/library/ms156468.aspx

 

Hope this helps.

 

Lu Zou

Answer 3

Hi Kez,

This could have happened cue to several issues.It could be that your serach is not working properly .Tryc and check if if you can do a full crawl on the search.

Also have a look at this blog and see if the same is happening with your environment.

http://blogs.vertigo.com/personal/michael/Blog/archive/2007/01/23/sharepoint-2007-search-never-stops-crawling.aspx


Try and see what isin the log file so that it gives an indication as to what is wrong.