How to Install Microsoft Ole DB Provider for SQL Server

Written by theon weber
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Install Microsoft Ole DB Provider for SQL Server
Microsoft Ole DB Provider helps software developers write applications for use with certain aspects of computer networks. (network image by Allyson Ricketts from

Microsoft's OLE DB Provider is an optional addition to the Microsoft SQL Server software, which is designed for software developers to write applications allowing clients connected to an SQL server to access and browse the metadata and query data stored by Microsoft SQL Server. It is not installed by default along with the basic SQL Server install, and must be downloaded separately from Microsoft's website. Microsoft maintains downloads for versions of OLE DB designed for both SQL Server 2005 and SQL Server 2008.

Skill level:

Things you need

  • Microsoft SQL Server 2005 or 2008

Show MoreHide


  1. 1

    Go to the appropriate Microsoft download page linked in "References."

  2. 2

    Scroll down the page until you find the section headed "Microsoft Core XML Services." It's about halfway down the 2008 page and near the top of the 2005 page. Click the download link, and run the downloaded file.

  3. 3

    Search on the same page for the section headed "Microsoft SQL Server [2005/2008] Analysis Services [9.0/10.0] OLE DB Provider." It's near the top of the 2008 page and about halfway down the 2005 page. There will be three download links-"X86 Package" for 32-bit versions of Windows, "X64 Package" for 64-bit versions, and "IA64 Package" for Intel Itanium versions. Download the appropriate version and run the downloaded file to install Ole DB Provider.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.