Well, that seems to be the issue. I was restoring a production db back up to create the test system db on the new sql server and the URL of the test server was not in the portalalias table there. My resolution was to backup our existing test system (which has the correct URLs) and restore it to the new server. Worked like a champ. Now, to find a "how to create a test system" document.
Thanks for the quick and very helpful response!