6

I noticed a lot of 3rd party SharePoint applications require that Office be installed on the server in order to function - PDF converters, for example.

To me, this seems like a horrible idea. The overhead, update requirements, reboots, and footprint all combine to make this a bad idea. Am I wrong in my assumption?

4
  • Microsoft advertises SharePoint to be especially designed to work well with MS Office, so I think if you use SharePoint it's not a bad idea to install Office. And because of that, I wouldn't be surprised that a lot of 3rd party SharePoint apps rely on Office being installed...
    – xor_eq
    Oct 13, 2010 at 16:36
  • @xor_eq: SharePoint integrates with Office, true. But nowhere does Microsoft say or even recommend to install Office on a SharePoint server. Oct 13, 2010 at 21:02
  • 1
    Your logic sounds good to me. Personally, I would balk because of the additional patching required every cycle.
    – SilentW
    Oct 13, 2010 at 22:14
  • 2
    One concern you've not mentioned is that the installation of Office opens yet more potential vulnerabilities, which to my mind is the most serious issue. Oct 13, 2010 at 22:43

7 Answers 7

7

When a vendor or supplier wants me to install client/bulky apps on a server, it lowers my opinion of their technical savvy and/or experience. I don't like it, but I'm used to it.

Sometimes I'm able to get ahead of things and learn about these little surprises before the purchase. It's up to me to make the case that we're going to have trouble down the road with a company that doesn't understand why a leased network printer should have a better method of volume tracking than buggy crapware installed on a server.

It's definitely a bad idea, but unless you're in a position to go with another supplier based on the unprofessionalism and sloppiness of this kind of requirement, it's nothing to lose much sleep over.

8

Speaking as a vendor who provides a popular PDF Converter for SharePoint that requires Office to be installed on the server for some formats I'd like to add my 2 cents.

In the past when I was in charge of change control for a large financial institution I would have raised my eyebrows if any vendor required office to be installed on the server. Oh how I loved my fancy Ivory Tower.... the irony is not completely lost on me.

Fact is that sometimes we need to look at what the business requires, and if the business requires perfect fidelity when converting documents that use the latest and greatest office formats then you can't escape going down the route of installing Office on the server.

Now, plenty of people have tried and failed to make this stable, and sometimes even employing dedicated people that go around rebooting hung servers. The thing is, if you know what you are doing and deal with all the pitfalls, of which there are many, then it is actually possible to successfully and reliably use Office on the server in a way that scales well.

I don't want to make this into an elaborate sales pitch, but we have hundreds of (high profile) customers and I have yet to hear from a customer who had a crash, outage or any kind of downtime related to our software.

If you don't know what you are doing and just code up some COM automation with Office directly in your SharePoint app then you are bound to run into problems, but if you do your job well, run everything in a separate process, allow optional offloading to non SharePoint servers then there is nothing wrong from a technical perspective with running office on the Server.

5
  • Nice to hear it from the horses mouth, as it were Oct 13, 2010 at 20:51
  • Indeed, thanks for the (levelheaded) weighing in. (btw, the blog link on your profile 403s, Muhimbi) Oct 13, 2010 at 22:20
  • Blog is working at the moment. Not sure what was causing 403. Oct 14, 2010 at 7:32
  • The URL from your StackOverFlow profile points to muhimbi.com/blog whereas your blog lives at blog.muhimbi.com - probably a simple redirect is required on the /blog directory
    – Kolten
    Oct 14, 2010 at 15:39
  • Cheers, I thought you were referring to the blog button on the Muhimbi site. I have updated my profile, it was an old link. Oct 14, 2010 at 19:37
6

Programs that interact with Office often use the COM/Interop Interface, which is not supported on a Server:

Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.

I can confirm that certain operations indeed deadlock the process (Printing out a Word Document on a Printer Driver that opens a Prompt caused me major headaches).

However, some applications only require office because of some component it brings with it and they may indeed run perfectly well.

But as said: If the Manufacturer of the Operating System and the Office Product says it's not supported, I'm inclined to believe them.

3
  • Thank you - I was looking for an official Microsoft statement on the matter, but couldn't find one. This is great. Reading it also confirms my assumptions that this should never, ever be done - for reasons I didn't even initially think about.
    – Kolten
    Oct 13, 2010 at 22:10
  • 1
    That's a good point, and maybe something that you can take back to the prospective vendor and/or the business folks that need the component. However, there are those (myself among them) that believe IT is there to serve the needs of the business. If the business decides, after having been fully briefed of the risks and potential extra administration from the IT staff, that they want this anyway, you just have to work with that.
    – mfinni
    Oct 14, 2010 at 17:17
  • 1
    @mfinni Of course, Business Needs are always above everything. I'm not a big fan of commercial solutions advocating this though, as the expectations of non-technical management people can be too high ("If it wouldn't work, they wouldn't sell stuff like this, would they? I think it's your fault"). That being said, I think that most big companies run on less-than-optimal and fragile solutions that break if you look at them in the wrong way, but otherwise do exactly what they need to do: Generate Value. Choose a Poison, but know both possible outcomes before :) Oct 14, 2010 at 17:31
3

I agree it is an idea which sends shivers down my spine, but it is pretty standard practice with content management systems targetting Office document collaboration.

I have also found this practice on Linux with OpenOffice with Plone for example.

Now, when we look at it pragmatically, in many may use-cases is the sharepoint server not a realtime critical resource, and the company copes just fine with an occasional reboot. Especially in SME environments there are relatively few users so the loads generated will not bring the server to its knees. In these circumstances this is a pragmatic approach to get the automations people want.

9
  • We are a very large organization, and have approximately 2,000 concurrent clients hitting our SharePoint farm at any given time. Downtime is strictly regulated and planned via change management.
    – Kolten
    Oct 13, 2010 at 16:54
  • Well, that was not exactly the use case I had in mind ;-). I hope you have a very big farm and benchmark/estimate the impact on the capacity plan. Oct 13, 2010 at 16:59
  • 1
    What overhead - disk space? The update requirements just mean that you have more updates to do, based on likely risk. The office updates still come out on Patch Tuesday, so there's no change to your existing process - assuming you patch your OS today. You just have an expanded footprint of things that you have to keep patched. Actual reboots required for Office updates, I'm sure, are less frequent than reboots for Windows updates. And what do you mean by "footprint"?
    – mfinni
    Oct 13, 2010 at 16:59
  • Footprint meaning changes to the registry, software taking up memory, etc. So from the responses I'm getting this is common practice and I shouldn't be too worried? I expected the exact opposite to be quite honest - I have always thought installing client apps on a server was a bad idea?!
    – Kolten
    Oct 13, 2010 at 17:05
  • 2
    @Peter Tillemans: In my opinion, you're spouting blanket generalizations that aren't applicable to every scenario or situation. Should you install Office on your file server, probably not. Should you install Office on a Sharepoint server if it's needed for some specific Sharepoint functionallity, yes you should.
    – joeqwerty
    Oct 13, 2010 at 17:26
3

You're absolutely right that it's a bad idea. But... At the end of the day this is what we do as system administrators though is it not? We have to balance the costs of making a change to our production servers against the cost of not making that change.

If the business must have a certain functionality on the Sharepoint install and this is the only way to get it then what else can you do really? Be clear about the risks and costs of doing the install in terms of resources and potential downtime for patching, etc. and see how it stacks up.

One thing that probably is reasonable is to find out exactly what office components are needed and do a minimalist install of just those components. There's a big difference between whacking the office disk into the server and just doing a "point and drool" quick install and saying "well it only needs, for example, word plus the foobaz plugin, so that's all I'll install"

0

The points the others have made about installing software on a server are good ones which I agree with. I would think servers should be used for serving and being used for their designated role.

If you don't want to install the full office suite there are small packages to allow you to view documents, powerpoints and so on. Look at Powerpoint Viewer or Word Viewer.

1
  • Viewing of documents isn't really the issue here. While I appreciate the response, my issue is to do with 3rd party components requiring Office to be installed on the server do perform thier specific functions.
    – Kolten
    Oct 13, 2010 at 21:30
0

Another reason for Office-on-the-server is when it's a terminal server for thin clients :-)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .