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

No Home Folder in SSMS Expand / Collapse
Author
Message
Posted Monday, March 25, 2013 12:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 7:54 AM
Points: 5, Visits: 74
Hello friends,

I have inherited a SSRS 2008 R2 Server
v10.50.1600.1

I want to manage the reports/ssrs/subscriptions via Management Studio. But when I connect, I do not have a 'Home' Folder. What access am I missing? I am in the built-in administrators group of the server. The web-ReportManager-interface works just fine. I have access to everything there.

I can't seem to find the answer anywhere!!
Thanks!!
Post #1435101
Posted Tuesday, March 26, 2013 4:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:12 AM
Points: 5,142, Visits: 4,930
You cant do what you want to do in SSMS you need to do it via the web page.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1435376
Posted Tuesday, March 26, 2013 6:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 7:54 AM
Points: 5, Visits: 74
Any idea why? I want my SSMS back!!
I read in several places that SQL 2008 disabled that feature.
But does the same go for 2008 R2 ?
There's got to be a better way!
Post #1435436
Posted Tuesday, March 26, 2013 6:44 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:12 AM
Points: 5,142, Visits: 4,930
If you want to control SSRS in SSMS then you will need to downgrade to SSRS2005.

As for why, unsure, I would see if there is a connect article on it or ask MS why they removed the functionality.

Yes the same goes for 2008R2 and 2012.





Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1435438
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse