Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to install SQL Server 2008 Reporting Services on SBS 2008

Posted on 2009-12-17
11
Medium Priority
?
1,562 Views
Last Modified: 2012-05-08
Is it possible to install  SQL Server 2008 Reporting Services on SBS 2008? Not knowing all the limitations of SBS 2008 I had just tried to install SQL as usual. The installtion program crashes shortly after beginning. So I installed just the database engine and that worked. Then I tried to install just SRS and that crashed, you get a message about Windows Installer failing. I was able to install SQL Server 2008 Express Management tools but that does not include SRS.
0
Comment
Question by:rwheeler23
  • 5
  • 5
11 Comments
 
LVL 26

Expert Comment

by:tigin44
ID: 26071391
Sure you can install SSRS along with the SBS 2008. sql server 2008 reporting server is installed by using the sql server installer.
0
 

Author Comment

by:rwheeler23
ID: 26071455
I was just handed the SQL Server 2008 CD that came with SBS 2008. If I go to add/remove programs and try to add just SRS it crashes. If I look in the log file I do not see why it crashes. The pre-system test says all will be fine. I will try again tonight when everyone is off the server.
0
 
LVL 13

Expert Comment

by:sameer2010
ID: 26071531
Hi,

This link could be useful.
http://technet.microsoft.com/en-us/library/cc527562(WS.10).aspx

Thanks,
Sam
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

Author Comment

by:rwheeler23
ID: 26077242
When  I did the orginal install it crashes during the SRS installation. If I go to install SRS 2008 it thinks it is there. If I try to uninstall SRS 2008 the Windows Installer crashes so right now I have no one of getting SRS uninstalled so I can reinstall it. Any ideas? I did try removing all of SQL Server 2008 but it crashes on the SRS poriton.
0
 
LVL 13

Expert Comment

by:sameer2010
ID: 26080043
Hi,

Are you saying that SQL is not present in add/remove programs and SRS exists (with no entry in add/remove)? Did you try stopping SRS in services.msc?
0
 

Author Comment

by:rwheeler23
ID: 26080108
Yes, there is no SRS in Program and Features however when you run the SQL install program it thinks it is there. The SRS service is there but it cannot be started. It says "access denied" when you try to start it even with the admin account.
0
 
LVL 13

Expert Comment

by:sameer2010
ID: 26080168
Did you try with the SS admin or windows admin? Can you try with SS admin?
0
 

Author Comment

by:rwheeler23
ID: 26082858
I am on as a member of the domain admin group. I even set the Security to use that user and the service will not start. I suppose I could try it as the 'sa' user but I doubt that will work. Is that what you mean by trying as the SS Admin? I cannot get SRS uninstalled.
0
 
LVL 13

Expert Comment

by:sameer2010
ID: 26089321
Yes. I meant SA or any other SS admin account.
0
 
LVL 13

Expert Comment

by:sameer2010
ID: 26089322
Also, did you try repair with services turned off initially?
0
 

Accepted Solution

by:
rwheeler23 earned 0 total points
ID: 26116630
SSRS will simply not reinstall. They are closed until next year and I will try again when I get access to their server.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question