Here is my page while trying to install a mojoPortal site:

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: 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.dbPortal.DatabaseHelper_GetConnectionError(String overrideConnectionString)

This site appears to be running in a secured environment using Medium Trust policy or lower.

Server Error in '/' Application.
Session state has created a session id, but cannot save it because the response was already flushed by the application.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: Session state has created a session id, but cannot save it because the response was already flushed by the application.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[HttpException (0x80004005): Session state has created a session id, but cannot save it because the response was already flushed by the application.]
System.Web.SessionState.SessionIDManager.SaveSessionID(HttpContext context, String id, Boolean& redirected, Boolean& cookieAdded) +2220274
System.Web.SessionState.SessionStateModule.CreateSessionId() +55
System.Web.SessionState.SessionStateModule.DelayedGetSessionId() +64
System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +328
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832[/quote]

It looks like my connection string in the web.config is not written correctly, but I am not sure what I am doing wrong. Ticket system here at Jodo simply replied with a link to www.connectionstrings.com but no help as to which of those examples would help me out. Here is a copy of the connection string from my web.config:

<add key="MSSQLConnectionString" value="server=(64.71.***.*);UID=*******_admin;PWD=********;database=*******_mojodb" />
<add key="MSSQLOwnerPrefix" value="[dbo]." />

Jodo support has told me that my connection string should be like this:
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

Can anyone help me out?

Thanks for the reply. I am not using the Medium Trust download because i didn't know I needed it before this step. Thus I don't seem to have a user.config file anywhere.

Do I have to replace the entire web content with the medium trust version or can I just add/overwrite the different config files? If so, what are they?

Either way, the recommended connection string from Jodo (Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;) should go into the user.config and don't worry about the one in web.config, right? I am not an asp/.net coder and am trying to wrap my PHP/mySQL brain around this CMS. What is the syntax I need to do with the Jodo recommended connection string to make it work in the user.config?

I hope I am not overstepping with my questions, thanks again for your time.

I am uploading the new release now, and will attempt to setup soon. I will let you know what happens, thank you.

OK, new release uploaded and the db connects just fine, however.. still getting the session error:

Welcome to mojoPortal Setup
Probing system...
File system permissions ok.
MSSQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.

Server Error in '/' Application.
Session state has created a session id, but cannot save it because the response was already flushed by the application.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Session state has created a session id, but cannot save it because the response was already flushed by the application.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[HttpException (0x80004005): Session state has created a session id, but cannot save it because the response was already flushed by the application.]
System.Web.SessionState.SessionIDManager.SaveSessionID(HttpContext context, String id, Boolean& redirected, Boolean& cookieAdded) +2220274
System.Web.SessionState.SessionStateModule.CreateSessionId() +55
System.Web.SessionState.SessionStateModule.DelayedGetSessionId() +64
System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +328
System.Web.SessionState.SessionStateModule.OnEndRequest(Object source, EventArgs eventArgs) +152
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

OK, new user.config and new web.config files are uploaded... now the setup page just hangs and comes back not responding eventually. :( GRRR!

Well I can't tell you how good it feels to know that it's not just me and that I am going crazy or something. As of this afternoon, I am getting the same error message in IE and Firefox (the source=mscorlib) and am awaiting your new package...

Will I have to upload the whole site again?

Followed your instructions, and also had to update the (<add key="Lucene.Net.lockdir" value="D:\hshome\rozecommsp\mojo.rozecomm.com\Data\Sites\1\index" />) line in web.config, but it installed no problem and quickly I might add. Thank you for working with me on this, I am sure I will be back with other questions soon. :)