BIRT: Connecting to MS Sql Server Database

  1. Download the Microsoft JDBC driver from
  2. Note: If youre using Java 1.5, you will use sqljdbc.jar, if your using Java 1.6, you will use sqljdbc4.jar.
  3. Open Eclipse
  4. Create a new Report or open an existing report
  5. Open the Data Explorer Tab
  6. If this is an existing report, Double Click on an existing Data Source, otherwise create a new Data Source. Call it whatever.
  7. From the Data Source editor, click on the Manage Drivers button.


  1. In the Manage JDBC Drivers Dialog, click on Add…


  1. Navigate to where you have either the sqljdbc.jar or sqljdbc4.jar file, and click Open. This will add the driver to the BIRT Designer.
  2. Now, click on the Drivers Tab.
  3. Double click on the SqlServerDriver entry to edit it. Put in a name, and a URL template that will prompt you on the correct URL pattern to use.


  1. Click on OK, and OK, until you get to the Data Source Editor Dialog.
  2. Select the SQL Server driver from the drop down list. It will automatically put in the template. Replace the IP Address, and Database name with the ip of your Sql Server Database, and the name of the database.


  1. Enter the correct User Name and Password.


That’s it, your done. Test Connection to make sure the information is correct, and hit OK.

Referenced by:

3 thoughts on “BIRT: Connecting to MS Sql Server Database

  1. I’ve been exploring foг a bit foг any high-quality articles օr weblog
    posts ߋn this kind of аrea . Exploring іn Yahoo І eventually
    stumbled ᥙpon tһis site. Studying thiѕ info So i’m satisfied to exhibit tһat Ӏ’vе an incredibly excellent uncanny feeling І discovered јust what I
    neeԀeⅾ. I moѕt undοubtedly wiⅼl mаke sure to dⲟn?t forget
    this website ɑnd give it a ⅼook on ɑ continuing basis.

  2. I have beеn browsing on-line greater thɑn three
    hours lаtely, yet І by no mеans found any fascinating article
    like yoսrs. It іs lovely vaⅼue sufficient f᧐r me.
    In my view, if aⅼl website owners ɑnd bloggers mɑdе excellent content
    material ɑs you probaƅly diɗ, tһe web might ƅe a
    lot more helpful tһan ever before.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s