Missing Reporting Services with SQL Server 2008 Express
-
2010년 7월 14일 수요일 오후 8:52
I installed MS SQL Server 2008 Express and I can't find any reporting services. It looks like I should have installed "with advanced features"
Is there any way that I can just add the reporting services or do I need to uninstall SQL 2k8 Express and install SQL 2k8 Express w/advanced features?
If I do need to reinstall, what is the preferred method?
모든 응답
-
2010년 7월 14일 수요일 오후 9:03중재자
Hello,
Just run the setup of SQL Server 2008 Express with Advanced Features and add Reporting Services.
Hope this helps.Regards,
Alberto Morillo
SQLCoffee.com -
2010년 7월 14일 수요일 오후 9:55
i tried that and it says there is a problem.. search for solutions... found http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=c56e753d-13ef-4b95-a5eb-0b470bf56341
Downloaded the 64bit for my 2008 64bit R2... tried to run/install and tells me I can't because there is another setup instance running....
-
2010년 7월 14일 수요일 오후 9:59tried sp1.... same deal
-
2010년 7월 14일 수요일 오후 10:05중재자
Hello,
That link is related to a CTP version of SQL Server.
If you have installed SQL Server 2008 Express then you may use the following link to install Reporting Services:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b5d1b8c3-fda5-4508-b0d0-1311d670e336
Hope this helps.Regards,
Alberto Morillo
SQLCoffee.com -
2010년 7월 14일 수요일 오후 10:08
I did that .....when I run it it tells me its not compatible and I need the SP2 CTP.... if i ignore this and try to install the advanced features:
---------------------------
Microsoft SQL Server 2008 Setup
---------------------------
SQL Server 2008 Setup is already running and cannot be launched more than once at a time.
Complete your current setup action and then rerun Setup.
---------------------------
OK
---------------------------
������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������
-
2010년 7월 19일 월요일 오전 10:37중재자
Hi Anton,
Since you have installed SQL Server 2008 Express Edition and do not want to uninstall the existing instance of SQL Server 2008 Express Edition, if we want to use SQL Server Reporting Services (SSRS), we have several options:
· Install a new instance of SQL Server 2008 Express Edition with Advanced Services
this will install another instance of SQL Server 2008 Express Edition on your machine and the SSRS will have a different instance name from the existing instance· Add SSRS to the existing instance of SQL Server
If you want to add SSRS to the existing instance, please follow the steps below:
1. Download SQL Server 2008 Express Edition with Advanced Services
we could download it from the following link:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b5d1b8c3-fda5-4508-b0d0-1311d670e3362. Run the installation downloaded above
3. In the “SQL Server Installation Center” window, please click Installation in the left pane and then click “New SQL Server stand-alone installation or add features to an existing installation”
4. In the “Installation Type” page, check “Add features to an existing instance of SQL Server 2008 and choose an instance to which you want to add feature from the dropdown list
5. In the “Feature Selection” page, check “SQL Server Reporting Services” and click “Next”
6. Complete the installation
If anything is unclear, please let me know.
- 답변으로 표시됨 Tom Li - MSFTModerator 2010년 7월 21일 수요일 오전 1:43
-
2012년 4월 10일 화요일 오전 10:44
I have tried this and reporting services did not come up as an option? Any help appreciated.
I am using 2008 R2 http://www.microsoft.com/download/en/details.aspx?id=25174
cheers
Anthony
- 편집됨 Tanman321 2012년 4월 10일 화요일 오후 12:24
-
2012년 5월 1일 화요일 오후 3:58I have the same problem as Tanmam321. Did you find any solution?
If I try to install new instance using the SQLEXPRADV_x64_ENU.exe, the option is not there either.- 편집됨 blazinsnow 2012년 5월 1일 화요일 오후 4:00
-
2012년 5월 1일 화요일 오후 5:06중재자
Can you try command line installation
using below link
FEATURES=RSRegards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread. -
2012년 5월 17일 목요일 오후 5:13
I uninstalled 2008 R2 Express and then installed the 2008 R2 Express advanced, backing up my databases before and then restoring after the install.
I now have reporting services.
-
2012년 5월 17일 목요일 오후 6:35중재자SO can you please mark my post as answer ?
Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.
.png)
