SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


"Report Services instance could not be found".


"Report Services instance could not be found".

Author
Message
Howard C. BAchtel-438731
Howard C. BAchtel-438731
SSC-Enthusiastic
SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)

Group: General Forum Members
Points: 186 Visits: 391
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.
colin.Leversuch-Roberts
colin.Leversuch-Roberts
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4753 Visits: 715
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/
Howard C. BAchtel-438731
Howard C. BAchtel-438731
SSC-Enthusiastic
SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)

Group: General Forum Members
Points: 186 Visits: 391
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
colin.Leversuch-Roberts
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4753 Visits: 715
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/
Howard C. BAchtel-438731
Howard C. BAchtel-438731
SSC-Enthusiastic
SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)

Group: General Forum Members
Points: 186 Visits: 391
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search