I just replaced the server in my office, and am running into problems transfering MojoPortal onto the new server.  Here's what I did:

1. Backed-up the database on the old server using the SQL Server Management Studio (RtClick  -> Tasks -> Back up...)
2. Copy the root of the site to a portable drive, along with the backed-up database.
3. Copy the site onto the new server, set permissions as if configuring a new mojoportal installation.
4. Restore the database backup onto the new server using the management studio.

The original server was 2003R2 standard, running MSSQL 2008.  The new server is 2008R2 standard, running MSSQL 2008R2.  Yes, the SQL server and IIS are running on the same box in both the old and new machines.

This is what it's doing:

Welcome to mojoPortal Setup
Probing system...
File system permissions ok.

The system cannot connect to the MSSQL database. Please check your connection string.

System.Data.SqlClient.SqlException: Cannot open database "mojoportal" requested by the login. The login failed. Login failed for user 'mojouser'. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at mojoPortal.Data.DBPortal.DatabaseHelperGetConnectionError(String overrideConnectionInfo)

I've verified that the mojoportal database was restored, the mojouser account is present, the password appears to be correct (though I can't seem to check that in the management studio), so I'm stumped at this point.  Am I missing something?

Awesome, that did it!  Thanks!