cannot view databases etc in reporting service in ssms

Question

cannot view databases etc in reporting service in ssms

sqlfriend

SSC Guru

Points: 52794
More actions
May 20, 2011 at 4:53 pm

#251331

I just add a Reporting service feature to my local sql server 2008 developer version installation on a windows 7 box.
Then when I tried to connect SQL reporting service from SSMS, I cannot see other nodes except job, security, and shared schedules.
I even tried to run the ssms as administrator, the same thing happened.
But if I open report manager in IE, it works fine.

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

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

SQLRNNR SSC Guru Points: 281344 More actions · Answer 1

You should use report manager for much of the administration of SSRS 2008 - a lot was changed between 2005 and 2008.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

sqlfriend SSC Guru Points: 52794 More actions · Answer 2

I should say when I connect to SQL 2008 reporting service in ssms, the first node I can see is a Job folder, instead, in sql 2005 it's a home folder. Is it supposed to be right?

I cannot see the home folder as in sql 2005 reporting service. Insetad it has a job

Any recommended articles about SSRS administration for dba for sql 2008 reporting service?

I also realized the topic of this post should not see cannot view database, database actually in database service in ssms, but I don't have an option to change the topic

Thanks

SQLRNNR SSC Guru Points: 281344 More actions · Answer 3

I'd start here.

http://msdn.microsoft.com/en-us/library/bb522825(v=SQL.100).aspx

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

sqlfriend SSC Guru Points: 52794 More actions · Answer 4

Thanks, I will take a look at the linked site.

But any one has sql 2008 reporting installed, can anyone tell me below:

when I connect to SQL 2008 reporting service in ssms, the first node I can see is a Job folder, instead, in sql 2005 it's a home folder. Is it supposed to be right?