Could not connect Reporting services

  • I just install reporting services 2005 sp3 64 bit standard edition on windows 2003 server standard edition, but while connecting to reporting server, I am getting an error,

    'reporting services instance could not be found(microsoft .sqlserver.management.ui.rsclient)'

    Anyone gone through this issue?

  • check your configurations in reporting service configuration manager. It may have to do with permission to the folders

  • I did check the reporting configuration manager,i dont know how to configure it, web service identity and database setup are red.

  • Intresting part is that aspnet user is not created in a machine, in my knowledge when we intall reporting services, aspnet user supposed to be created on machine, right?

  • You cannot run SSRS without ReportServerDB and ReportServerTempDB if you have not installed both you need to rerun setup to install both, you can also run one of the SSRS utilities to create both run a search in BOL. And I have covered the security in the middle of the thread below.

    http://www.sqlservercentral.com/Forums/Topic719964-150-1.aspx

    Kind regards,
    Gift Peddie

  • I see report and reporttempdb on my database engine, but didnt see reprtserverdb. what about aspnet user, do we need to create that user also

  • You need both databases so you need to rerun setup and you also need Asp.net because it is used to run Reporting Services configuration.

    Kind regards,
    Gift Peddie

  • if i rerun the setup it says reporting server is already installed, and asp.net 2.0 version is already installed. I have no idea what to do now

  • You need to verify that both databases are installed and spend time with the link below because most things you need to do are covered. If you don't know you need to go to configuration manager and configure Reporting Services then you need a book.

    http://technet.microsoft.com/en-us/library/ms159624(SQL.90).aspx

    Kind regards,
    Gift Peddie

  • how do i add aspnet user and what password i need to provide while createing aspnet user, in one of my server i see aspnet user where reportisn service runs fine. so i can create aspnet user but what password do i need to provide.

  • Now I have covered all you need so go do some work because you should not be using SSRS at this level if you don't know the basic. Here is step by step if you cannot use this then you need a class.

    http://technet.microsoft.com/en-us/library/cc304416.aspx

    Kind regards,
    Gift Peddie

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply