Tuesday, February 10, 2009

SSRS 2008 Grant Database Error

WOW....this should not be this hard. I am upgrading our SSRS from 2005 to 2008 so that we can use the tablix and some graphs in out reports. After I had installed everything (in the right places mind you) I could not grant database access. "Unable to connect to the Report Server WMI provider" ...I read tons of post about it being security and this and that. Well I never imagined that the security it was talking about was hosting the central admin on the SSRS server! Thanks to Bruce Van Buren (http://znetsys.spaces.live.com/blog/cns!ED65D09C41E55E06!165.entry) I realized the errors of my ways and it is now fixed. I am pretty sure that when I roll this into production I did not want my Central Admin sitting on my SQL 2008 IIS box. One of the cool things about (at least I thought) about SSRS 2008 was the new architecture. Removing IIS and using SQL server network stack and http.sys (http://www.devconnections.com/updates/LasVegas_07/SQL_Connections/Welker_SQL%20Connections_SMS315_What)

No comments: