This is the error in the data log file:

2009-02-28 23:00:37,455 ERROR mojoPortal.Web.UrlRewriter - System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
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.SqlHelperParameterCache.DiscoverSPParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter)
at mojoPortal.Data.SqlHelperParameterCache.GetSPParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter)
at mojoPortal.Data.SqlHelperParameterCache.GetSPParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
at mojoPortal.Data.DBFriendlyUrl.GetByUrl(String hostName, String friendlyUrl)
at mojoPortal.Business.FriendlyUrl..ctor(String hostName, String friendlyUrl)
at mojoPortal.Web.UrlRewriter.RewriteUrl(HttpApplication app)
at mojoPortal.Web.UrlRewriter.UrlRewriter_BeginRequest(Object sender, EventArgs e)

please help, I am about to scrap the whole thing.

Thanks for responding, I am having a hella time installing this thing. I have checked and rechecked.  After having trouble installing two weeks ago,Godaddy moved this hosting account to a server that accepts remote connections. For the sake of finding out whats wrong I am willing to provide ftp info as well. I wanted to give mojoportal a shot, but this is not a good beginning, and I am running out of time for learning curve and experimentation. Again, any help would be appreciated.

My string is as follows:

<add key="MSSQLConnectionString" value="server=Server=STartThemeans.db.3182258.hostedresource.com;UID=STartThemeans;PWD=Corpface09;database=STartThemeans" />

The hosting control panel settings are as follows:

SQL Server Database Information

Status:Setup

Host Name:STartThemeans.db.3182258.hostedresource.com

Database Name:STartThemeans

Database Version: 2005

Description: Start Multimedia Content

User Name:STartThemeans

DSN:mssql_STartThemeans.dsn

Installed (Uninstall)

ASP Schema: Installed (Uninstall)

OK, so after reuploading the bin. Deleting the DotNetOpenID.dll and fixing my typo (stupid, I know) I am now getting the following response:

Probing system...
File system permissions ok.
MSSQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.
This site appears to be running in a secured environment using Medium Trust policy or at least lower than Full Trust.

In order for the Search Engine to work in Medium trust, you need to add this in Web.config in the AppSettings section:

<add key="Lucene.Net.lockdir" value="d:\hosting\startmedia\Data\Sites\1\index" />

Running script mojoportal-core - 2.2.7.8 - 00:00:00.1406241
Running script mojoportal-core - 2.2.7.9 - 00:00:01.6406145
Running script mojoportal-core - 2.2.8.0 - 00:00:01.7968635
Running script mojoportal-core - 2.2.8.1 - 00:00:01.7968635
Running script mojoportal-core - 2.2.8.2 - 00:00:01.8124884
Running script mojoportal-core - 2.2.8.3 - 00:00:01.8124884
Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.

Should an uninstall an ASP schema that comes with my hosting control panel?

will do. Thanks.