tag:blogger.com,1999:blog-2157078164517103759.post2444835175750522229..comments2023-07-31T03:31:57.774-07:00Comments on A Static State: Deploying SSRS with SharePoint 2007 IntegrationJason Apergishttp://www.blogger.com/profile/01817509015412502702noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2157078164517103759.post-46366947060718932312008-06-04T11:22:00.000-07:002008-06-04T11:22:00.000-07:00The are several reasons why integrated SharePoint ...The are several reasons why integrated SharePoint SSRS will not work. Some are technical. However all of these reports are accessible through K2 workspace which is their asp.net web site that is used by administrators, developers and users to work with k2 blackpearl server. Those reports cannot be run through SharePoint. The only way around this would be to have two separate installs of SSRS. SSRS does not have to run on the same machine as SQL and I have in the past set up multiple SSRS machines on their own IIS box. Each SSRS box can use the same SQL box. The one thing is MS licensing is a little frustrating when it comes to this because they say you have to have a get a second SQL lic for each IIS box that you install SSRS on (http://www.microsoft.com/sql/howtobuy/howtolicensers.mspx).<BR/><BR/>I think your only solution right now would be to set up a different SSRS machine that will be used by K2. This make sure that your existing reports that are running on SharePoint will continue to work.Jason Apergishttps://www.blogger.com/profile/01817509015412502702noreply@blogger.comtag:blogger.com,1999:blog-2157078164517103759.post-2113827060826342382008-06-04T06:40:00.000-07:002008-06-04T06:40:00.000-07:00Hi, thanks for the post. We currently have SSRS ...Hi, thanks for the post. We currently have SSRS installed in integrated mode to run with our MOSS server. When we tried to install K2 we got this error "The report service is running in SharePoint integrated mode. This is currently not supported for K2 Reporting components." Any ideas how to get around this? If we change our SSRS connection to native mode we will lose the integration with SharePoint, which we currently have SSRS reports on. We are at a lost on how to proceed.Unknownhttps://www.blogger.com/profile/15763019551933370652noreply@blogger.com