Hi,
You should not be running any scripts manually. Please read the installation instructions here:
http://www.mojoportal.com/mssqlsetup.aspx
You probably should clean out the db or start with a new one now since you ran some of the legacy scripts. Those only exist for upgrading from extremely old versions of mojoPortal.
Just set your connection string and visit the setup page and it wioll run the correct scripts automatically.
Hope it helps,
Joe