I hear ya. The learning curve can be very frustrating at first. I thought that all I needed was a nice lens and a dslr and I would be pumping out gorgeous pictures like blazer, greg and doug. Alas, not to be...
First of all, the minimum focal distance is 5.9 inches. You should be able to get that close and still be in focus.
You must be perpendicular as possible with the glass. Angles will distort and blur.
Use a higher f-stop. The camera will probably default to f/2.8 because an aquarium is rather dim. At f/2.8 the DOF is really shallow. Plus the best image quality is in the middle, not at the ends of the f-stop range. I would start at f/11 and go to f/8 if you need more light.
Set your ISO to 800 and see if there is any noise. If there is a little you can correct in post with PS or Noise Ninja or some other program. If too much noise you may need to back it off to 400.
Shut off all pumps and let things settle to avoid motion blur.
Experiment with a stobe if you have one. I use a tether and try the flash from different directions and with and without a diffuser.
This is a freshwater pic, but it shows a picture with the flash held above the aquarium.
If you do not have a nice tripod, if you feel any shimmy, shake, or instability, use the timer on the camera.
Okay, recap. Set the camera on Aperture priority at f/11, ISO 800. Press shutter button half way down. Check shutter speed. If slower than 1/60 (stationary subject) move f-stop to f/8. Fine tune autofocus manually or just use manual focus. Fire! How did it look? If not so good, experiment with the settings. Go to 1200 ISO or 400 ISO, go down to f/5.6, use a flash, back up, move forward. Shoot 100's of pictures. Bracket the exposure. 1/2 stop above and below. You need to find the sweet spot for your particular subject.
Now if you have 20,000 kelvin bulb or want actinic shots, then we have more complications since your camera only white balances to 10,000 K.
Oh crap, I didn't cover white balance because I shoot in raw and white balance in post. I'll leave that to the next poster.
Mike