Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

"Report Services instance could not be found". Expand / Collapse
Author
Message
Posted Wednesday, May 18, 2011 8:54 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 7:00 AM
Points: 85, Visits: 336
We recently installed SQL Server 2008. I try to connect to Reporting Services using SSMS from my client and receive the following message "Report Services instance could not be found". I can connect to SSAS, SSIS and SSMS with no issue. I believe permissions are appropriate on all and Dcom user permissions are as well.

Any suggestions as to what may be the issue.

Thanks in advance.
Post #1111061
Posted Wednesday, May 18, 2011 9:31 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:08 AM
Points: 2,674, Visits: 695
it's probably a silly question but did you check the service was running?
Can you connect locally on the box?


The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #1111105
Posted Wednesday, May 18, 2011 10:32 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 7:00 AM
Points: 85, Visits: 336
Thanks for the question. The answer is Yes and No. The service is running. I can not connect to it. I did not do the actual install and am going through the steps to see if something was missing.
Post #1111172
Posted Wednesday, May 18, 2011 1:31 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:08 AM
Points: 2,674, Visits: 695
I don't build SSRS servers very often, far less than SQL Servers, and I haven't created a build doc for SSRS 2008 (R2) yet. The install I did was to test if our reports worked without any issues. As far as I know setup and install is pretty easy.
I'm obviously an admin on the actual box and syadmin to sql. All the connections and setup use integrated security, Everything runs as domain service accounts.
You should be able to step through the ssrs config from management without errors - you set permissions there. I don't know which o/s you have but windows 2008 r2 introduces a few changes from windows 2008 some of which are very annoying! Lookout for windows firewall ( which claims it can't be disabled in R2 ) allowing remote access for both o/s and sql.
I usually work on the basis of:-
can I rdp to the box
Can I map a drive/share
can I copy a file
Can I register sql and ssrs in SSMS on the box ( or in rdp session )
can I resgister sql and ssrs froma workstation.
can I get to ssrs locally e.g. localhost/reports or reportserver
can I do this from another server/workstation using the server name and the ip address ( which may need a login initially )

hope this might help


The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #1111316
Posted Friday, May 20, 2011 9:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 7:00 AM
Points: 85, Visits: 336
Thanks again. I need to look into a few things and will see where we are here. Our organization is different (than most organizations ). I did not set the server/instance up and don't know if I don't have permissions that I should or if it is not set up correctly.

Thanks.
Post #1112489
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse