Hey,

We created a site at work with MojoPortal and I love it.  I decided to setup my own site with MojoPortal recently so I purchased a domain and a Windows hosting account from Godaddy to get started.  I got everything up on the server, permissions set, and user.config and web.config files going.  I created an MSSQL and a MySQL database (I created both because I couldn't get MSSQL to work without the error below, so thought i'd try MySQL too).  I added the MySQL connection string and eventually kicked off the site setup page.  I keep getting this error with my connection string.  I'm assuming I have something wrong in my string and hope someone can help.  I appreciate it!

Here is my connection string in the user.config, web.config, and web.fulltrust.config (did it in all three just in case):

<add key="MySqlConnectionString" value="Server=tylerc82588dm.db.9389099.hostedresource.com;Database=mojoportal;Uid=tylerc82588dm;Pwd=(my password removed for privacy;" />

This is the error i'm getting:

Probing system...
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: 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.DatabaseHelperGetConnectionError(String overrideConnectionInfo)

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

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.