Most Valuable Yak (Rob Volk) Blog

…and other neat SQL Server tricks

Use Microsoft DB2 OLEDB Provider On Non-Enterprise SQL Server Editions

Microsoft makes a pretty good OLE DB Provider for DB2 that you can use for SSIS, DTS, and linked servers under SQL Server. It's sometimes difficult to configure but you can get some good starter settings here.

In yet another remarkable but not uncommon blunder on their part, Microsoft's installation package will only install the provider on a server with Enterprise or Developer Edition. Why they do this I don't know, but if you have a Standard Edition SQL Server and want to use this provider, here's a workaround:

  1. Install Enterprise or Developer Edition side-by-side on your Standard Edition server as a named instance, only the database engine components.
  2. Install the DB2 OLEDB Provider.
  3. Uninstall the side-by-side instance. Or keep it if you like it and have a valid license.
  • I've only tested this with Standard Edition, but I believe it will work with any edition of SQL Server.
  • You may be able to use a trial version of SQL Server for the side-by-side install, I haven't tested it.
  • This technique also works for SQL Server 2000 instances, as long as your side-by-side instance is 2005 or higher

If you're wondering why I'm posting this: <rant>

  • It was in answer to this Tweet.
  • I'm aggravated that Microsoft:
    1. Makes a great product
    2. That they give away for free
    3. And deprive their user base with a ridiculous and unnecessary SKU limitation

Sorry MS if you don't agree, but DB2 integration is NOT an Enterprise-only feature, nor one that should cost $30K+ to get.  If you really think so, then charge $30K for the provider, don't tease your customers with a freebie.


Legacy Comments

re: Use Microsoft DB2 OLEDB Provider On Non-Enterprise SQL Server Editions
Whilst this approach deals with the implementation considerations of deploying the DB2 OLEDB Provider without other Enterprise festures deployed, it does not solve the licencing problem and this deployment would still require an Enterprise license, as this "freebie" is an Enterprise feature.

re: Use Microsoft DB2 OLEDB Provider On Non-Enterprise SQL Server Editions
here is version 2 of the OLEDB driver, still has the limitation of installing only on Ent/Dev editions though