Ok… So this really was not easy. If you google this you’ll find a bunch of crap that doesn’t work.

How to get iReports 4.x to work with Microsoft SQL Server 2008?????

Here’s what I did.

1) Downloaded the JDBC Drivers from Microsoft.
2) When you unzip it it will give you 2 .jar files. These are the core code.. the rest is just a waste of digital space.
3) If you’re on a x64 machine you need the sqljdbc4.jar file.
4) Paste this into the directory you install iReports under ireports\libs\
5) Restart iReports

Then it will work! If this doesn’t comment here… I’ll help you. DO NOT!! copy both files like I did. LOL it won’t work! That was my problem. I need the x64 file. No where in the document did it explain this.