<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Mohan Kumar
»
Uninstall SSRS If you are not using it
12 posts, Page 1 of 2
1
2
»»
Uninstall SSRS If you are not using it
Rate Topic
Display Mode
Topic Options
Author
Message
Mohan Kumar
Mohan Kumar
Posted Monday, May 26, 2008 10:29 PM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 03, 2013 4:44 PM
Points: 1,336,
Visits: 595
Comments posted to this topic are about the item
Uninstall SSRS If you are not using it
--
www.sqlvillage.com
Post #506657
Alexander-449406
Alexander-449406
Posted Monday, May 26, 2008 10:34 PM
Grasshopper
Group: General Forum Members
Last Login: Friday, February 22, 2013 10:29 AM
Points: 22,
Visits: 141
There is a good reason for this error, here: [url=http://msdn.microsoft.com/en-us/library/aa337324.aspx][/url]
Reporting Services is not an unplanned installation.
Post #506658
Anipaul
Anipaul
Posted Tuesday, May 27, 2008 1:01 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:01 AM
Points: 4,815,
Visits: 1,343
Nice article but if you googled first you could hit the reporting service first. Generally when I get a new error I google it.........:)
Post #506712
parcival
parcival
Posted Tuesday, May 27, 2008 2:16 AM
Grasshopper
Group: General Forum Members
Last Login: Friday, June 17, 2011 7:14 AM
Points: 16,
Visits: 166
Saying that you will Google the error is all very well but don't forget that someone has to highlight and document these "features" in the first place. Well done for writing the article.
Post #506745
Kevin-458339
Kevin-458339
Posted Tuesday, May 27, 2008 5:24 AM
Old Hand
Group: General Forum Members
Last Login: Friday, June 07, 2013 1:36 AM
Points: 334,
Visits: 3,136
Thanks for the article - it is to the point and focused.
It made me think of the components of SQL that I have installed and know that I do not use them and should get around to removing them - but never have. (on my laptop - not on production servers)
Thanks
Kevin
Post #506817
dbaforever
dbaforever
Posted Tuesday, May 27, 2008 6:03 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, December 11, 2012 3:02 PM
Points: 135,
Visits: 460
At first glance, I tend to disagree. I don't always know which features will be used in the long-term on a new SQL Server. So I install AS,IS and RS. Then I install the latest Service Pack. (If I install RS later, I will have to reapply the Service Pack to fully patch that new module)
And by having it already installed, it is ready to use if/when we decide to use that feature.
Of course I agree with stopping the services related to an unused product.
This is just my practice.
Post #506845
SuperDBA-207096
SuperDBA-207096
Posted Tuesday, May 27, 2008 6:47 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Wednesday, January 02, 2013 12:15 PM
Points: 1,443,
Visits: 711
In general, it's a good idea to reduce the surface area of a server by disabling unused services. This includes Reporting Services, integration services, IIS, etc....
Post #506886
Mohan Kumar
Mohan Kumar
Posted Tuesday, May 27, 2008 7:34 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 03, 2013 4:44 PM
Points: 1,336,
Visits: 595
this error came after a year from date of installation. when service was already disabled.
--
www.sqlvillage.com
Post #506923
russell-154600
russell-154600
Posted Tuesday, May 27, 2008 8:11 AM
Valued Member
Group: General Forum Members
Last Login: Friday, February 22, 2013 11:13 AM
Points: 69,
Visits: 183
John Bates (5/27/2008)
At first glance, I tend to disagree. I don't always know which features will be used in the long-term on a new SQL Server. So I install AS,IS and RS. Then I install the latest Service Pack. (If I install RS later, I will have to reapply the Service Pack to fully patch that new module)
And by having it already installed, it is ready to use if/when we decide to use that feature.
Of course I agree with stopping the services related to an unused product.
This is just my practice.
This practice is flawed. Best Practice dictates that you should install only what you need. If you aren't sure, then someone who is should be performing the installation.
As for the guy saying "If you had googled first" I would submit that little relevant information would be returned. This is a case of an experienced DBA using his knowledge along with a little bit of testing to resolve an error that is generally not documented.
Well done. Nice article. And now a google search WILL return relevant information for DBAs who run into the same issue.
Post #506946
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Tuesday, May 27, 2008 8:54 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
Tend to agree with you above. Don't install something you don't need.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #506974
« Prev Topic
|
Next Topic »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
