This is for Progression.
There are several things you will need to do. You did move over all the Macola databases, didn't you? Not only data_xx, but PWE, MSLLOCKDB (see below), and SCREENS, right?
First, you will need to edit the macsql.cfg in your Macola root directory and change each instance of the old server name to the new server name.
Then, edit the PWE.tam file (x:\macsql\pwe) to reflect the new server name. The file may be read-only, so check the attributes before you change.
Macola users aren't going to exist in the Master on the new database, so the first thing you'll want to do is run
sp_dropuser supervisor_sql in Query Analyzer against each Macola database. If this returns a message that user supervisor_sql does not exist in the database, that's fine, move on to the next db.
Once that completes, open the user7.sql script in Query Analyzer and run it. The script can be found in x:\macsql\sql scripts). It has a use screens statement, so it doesn't matter what db you run it against.
This step is optional, but I find it can be beneficial. Delete the msllockdb (or don't copy it over in the first place). Then, in Query Analyzer, run the Lockbd7.sql (x:\macsql\sql scripts) against the master database. Once that completes, run the msl_locking script in Query Analyzer against the newly created msllockdb.
At that point, you should be able to log into Macola. From there, you should go into System Manager\Maintain\Visual Menu Builder and run Tools\Synchronize with SQL (tools is on the menu bar).
If you had aliases set up in the client network utility pointing to the old server, either remove them or point them to the new server.