error: 40 - Could not open a connection to SQL Server

I posted this on the Dotnetnuke forums but no answer for it, so since it is a SQL error I guess maybe someone here might know.

I installed the core forum that comes with the installation, the page runs great until I add the forum module.

I get this error:

A critical error has occurred.
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)

The portal is in godaddy if this can help.

Thanks,

Erick

This problem usually occurs due to these reasons:

1. either your Datasource name is not set to the right value in web.config. If this is the case, check your web.config value with the GoDaddy's SQL server source name value (ask them for this).

2. remote connections are not allowed or there is some firewall issue. For this too contact GoDaddy support.

Hope this helps,

Vivek