March 3, 2014 at 5:18 pm
I installed a full version of SQL server 2008 R2 developer with SSIS, SSRS, SSAS. I started the SSRS service in windows. No matter which server name I try, I get the error Unable to connect to the report server ZZZ. In management studio, I can see SQl servers, Integration Server but no Report server. It looks like I need to create one so that I can learn SSRS. How do I do this ?
The error photo -
March 3, 2014 at 9:30 pm
What options did you choose when you installed SSRS? "Install but do not configure"? If you did a default install, the install script should have created a ReportServer database. Do you see a ReportServer database when you are in SSMS?
March 4, 2014 at 3:44 pm
pietlinden (3/3/2014)
What options did you choose when you installed SSRS? "Install but do not configure"? If you did a default install, the install script should have created a ReportServer database. Do you see a ReportServer database when you are in SSMS?
I never saw a report server in SSMS. I am now reinstalling the whole BI stack.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply