Re: Migrating releases from 18.104.22.168 to 22.214.171.124 - MSSQL issues
I'm assuming you only have MS SQL databases.
I use MS SQL Server Management studio (free download) to manage my MS SQL databases. My mojoPortal database user is a member of db_owner, which gives it the rights it needs. I check this in MS SQL SMS by connecting, opening databases | <my database> | security | users | <my user>, double click on <my user> and on the popup dialog look under Role Members and check that db_owner is ticked.
I have had issues in the past when using the same database name & user name on remote & local installs, so I now use different database names and database user names (I usually use WebMatrix for managing synchronising local & remote databases - not sure if that caused the issues I saw with using the same names)