"Report Services instance could not be found".

Question

Post reply

"Report Services instance could not be found".

Howard C. BAchtel-438731

SSCrazy

Points: 2384
More actions
May 18, 2011 at 8:54 am

#240422

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.

Viewing 5 posts - 1 through 4 (of 4 total)

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

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 1

it's probably a silly question but did you check the service was running?

Can you connect locally on the box?

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

Howard C. BAchtel-438731 SSCrazy Points: 2384 More actions · Answer 2

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.

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 3

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

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

Howard C. BAchtel-438731 SSCrazy Points: 2384 More actions · Answer 4

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.