Post reply

Cannot create/access SSRS server on local system

  • March 3, 2014 at 5:18 pm

    #304697

    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

    #1693746

    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

    #1694124

    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