When Rogers switched from @Home to their own network, they also changed the way they authenticate machines. They are now using the MAC address from your external facing nic card. If you had your existing cable service up and working with, say, your Windows machine, using whatever nic it has, then unplug the RJ45 from the Windows machine and plug it into the SME machine, it will not get an IP address from Rogers. They are expecting to see the MAC address from the Windows machine. If you pull the nic card out of the Windows machine, and install it in the SME, using it for the external interface, you should be able to renew your lease.
If you are still unable to get an IP, or are not able to install the Windows nic in the SME (because it's ISA), then call Rogers tech support and tell them you need to change the MAC address that they are authenticating you with. This could take 3-4 days to complete.
One other thing you may try, if you are still using your Rogers connection on your Windows box, before you unplug your RJ45, or shut down your Windows box, using winipcfg (Win9X/ME) or ipconfig /release (NT/2000/XP), release your current IP info and you may be able to renew your lease with the SME box. I've heard of this working in the past when switching nic's.
Hope this sheds some light on your situation.
Terry