At first, I set up the web.config correctly and got 500 internal server error.I'm using godaddy in medium trust for hosting. After some research, I found that I have to comment out or remove the Group that contains System.web.extensions.

So now we've moved on to actually seeing the mojoportal setup. This is where it stopped:

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

System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) 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)

My connection string is correct. My database is set to to direct-access. I can access it from SQL Server Management studio. Here is the last thing from the error logs:

2010-12-26 11:03:09,342 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
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.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
at mojoPortal.Data.DBSiteSettings.GetSite(String hostName)
at mojoPortal.Business.SiteSettings.GetSiteSettings(String hostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings() 

Could this be some sort of bug that prevented me from using asp.net4 in the first place? Here is the url to the bug:

http://www.asp.net/learn/whitepapers/aspnet4/breaking-changes#0.1__Toc256770149