jknj72
asked on
SQL Server Reporting Services installation
I am trying to help out a buddy of mine. He has this server that has SQL 05 and I noticed that he had Business Intelligence so Im trying to get the Report Server installed. I went into Report Services Configuration Manager and right away I get an error:
No report servers were found on the specified machine
Invalid namespace
Does this mean that during SQL Server setup that not all the options were checked? How can I fix this? Ultimately I am trying to get SSRS, SSIS and SSAS all to work on this server.
Thanks
No report servers were found on the specified machine
Invalid namespace
Does this mean that during SQL Server setup that not all the options were checked? How can I fix this? Ultimately I am trying to get SSRS, SSIS and SSAS all to work on this server.
Thanks
<Does this mean that during SQL Server setup that not all the options were checked?>
Yes. Or not on this server
How can I fix this? >
get sql 2005 installation media and install SSRS
you can get it for free with SQL Server 2005 Express Edition with Advanced Services
http://msdn.microsoft.com/en-us/library/ms365166(v=sql.90).aspx
or if you have with Std ent editions
Yes. Or not on this server
How can I fix this? >
get sql 2005 installation media and install SSRS
you can get it for free with SQL Server 2005 Express Edition with Advanced Services
http://msdn.microsoft.com/en-us/library/ms365166(v=sql.90).aspx
or if you have with Std ent editions
ASKER
I know its not SQL Express Edition so how do I go about installing what I need(Report Server). Keep in mind that I can run BI and create a report, I just cannot Publish and I cant configure which leads me to believe the Report Server was not installed. How do I go about installing this? THANK YOU!!!
This is in my Help>>>About in SQL Server Management Studio
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710 )
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3082
Operating System 5.2.3790
This is in my Help>>>About in SQL Server Management Studio
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3082
Operating System 5.2.3790
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
May be you have installed advance express edition.
If you did with full version then modify the installation and add SSIS, SSRS, SSAS components with the Installed Data Engine component.