Hi,

I want to install mojoPortal on my discountasp.net account but for some reason I keep getting this error message:

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

I have no idea what to do.

After following the instructions I can only assume that a typo got into the web.config .

Yet when I checked it it was ok. I'm new to IIS so any help would be greatly appreciated.

Lawrence

Hi Joe,

Thanks for your lightening reply (do you sleep?).

As I said, I have the correct connection string in the web.config file that's why I find this error perplexing.

Could it be that the permissions are wrong?

Lawrence

Joe,

This is .

But in case others make the same mistake - here's the problem:

In the web.config file the line to edit looks like this: <add key="MSSQLConnectionString" value="server=(server);UID=user;PWD=''''';database=databaseName" />
I FORGOT to delete the ().

Thanks Joe and enjoy the beer.

Cheers!

Lawrence