There are two causes to your problem, its either a jumper problem, or you have the wrong type of cable...I will explain:
I am going to guess you are running Windows XP because it will let you use a hard drive that isn't exactly set up correctly.
Its fine that you are using the same IDE cable, but my first suggestion would be to look at your jumper settings on the back of the HD's . One needs to be set as a master (almost always the HD with the OS on it) The second needs to be designated a slave. Each hard drive is different so I would suggest going to your respective hard drive manufactuers websites and looking up the jumper settings.
Second if you did not add your 2nd hard drive into your system's BIOs you need to do that. The HD will come with a set up disk. If you can't find one, download Seagates at www.seagate.com
they have a cool program called "Disk Wizard" that sets up a second hard drive and I believe it will support other companies HD's
About the cable:
You might be using a Ultra IDE 33 cable. I have heard from some people that switching to an Ultra IDE 66 solves the error you are getting on the bootup. It is sort of complicated to explain the difference but basically it has to do with the number of conductors. If the jumper settings don't solve your problem you might look into that. The error you are getting on boot up is definately telling you there is an issue
Let me know if anything works