Hello,

I'm hoping that someone can help me with this issue.  I am installing mojoportal on a site where the mojo portal database has already been created  - and two sites already exist.  What I would like to do, is remove the existing sites (is there a script for that?) as they were created during a previous test and I'm unsure of their configuration.  They will not be used for the live sites that I'm currently trying to install for.  But first, I need to get past the installation. 

I am getting the following errors when I try to run the setup/default.aspx page:

Probing system...
File system permissions ok.
MSSQL database connection ok.

mojoSetup has detected that the database user does not have permission to alter the database schema. You need to correct this or provide a connection string with sufficient permission.

database initial schema already exists.
database core schema needs upgrade.
2 site(s) found.
This site appears to be running in a secured environment using Medium Trust policy or at least lower than Full Trust.

After looking thru the site hosting help, the problem lies in the fact that the sql script references [dbo]. Their help advised me to change the [dbo] to my database name.  To test this, I took one of the install scripts (2.3.3.9.config) and ran it in query analyzer.  I received an error that I did not have permissions to update the schema.  When I replaced all [dbo] with my database name, as the site help advised, I was able to run the script in the query analyser with no errors.  So, I replaced the updated script on my install site (2.3.3.9.config), touched the web.config file and ran the setup again - same message.

Can someone advise me what to try next?

Also, any help in cleaning out the existing database would be greatly appreciated.  I cannot delete the database and start over, as that is not an option on the hosting site.  I need to find a way to clean out the existing mojoportal tables of the previous installation and repopulate the tables.

Thank you in advance for any help.

Donna

Joe,

Thank you for your advise.  I've now gotten further with the install.  Here is the current error message:

Probing system...
File system permissions ok.
MSSQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema already exists.
database core schema needs upgrade.
2 site(s) found.
This site appears to be running in a secured environment using Medium Trust policy or at least lower than Full Trust.

Running script mojoportal-core - 2.3.3.9 - 00:00:00.1406295
System.Data.SqlClient.SqlException: There is already an object named 'mp_FriendlyUrls_GetSearchCount' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:00.1562550
 

Donna