« October 2009 | Main | February 2010 »
January 27, 2010
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:
I am pretty sure that wasn't in there before I installed R2.
So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.
Share:
Posted by Steve Mann at 3:56 PM | Comments (0)
SQL Server 2008 Reporting Services Integration with SharePoint 2010
I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.I went through the process and when I saw some options disabled I figured something was wrong:
The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.
I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:
After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.
So what you need are both parts:
SQL Server 2008 R2 November CTP
http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)
SQL Server 2008 R2 RS Addin for SharePoint
http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en
After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):
But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).
After successfully integrating, a Reporting Services option appears under the site collection site settings:
That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right: