I just installed the newest version of the blog module. From the installed server itself (not a remote connection), I get this message. The installation of this module went without any errors. This message appears before I make any blog entry. Other modules (survey, announcements, marketplace) run without any problem. fyi, sql is set to allow remote connections.

Thanks.

Error: Blog is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) ---> 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: 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 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Blog.Data.SqlDataProvider.GetBlogModuleSettings(Int32 PortalID, Int32 TabID) at DotNetNuke.Modules.Blog.Business.Utility.GetBlogModuleSettings(Int32 PortalID, Int32 TabID) at DotNetNuke.Modules.Blog.ViewBlog.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Thank you for your response.

Excuse my ignorance, but could you be a little more specific? What both connection strings are you referring to? In the blog portion? What two connection strings am I comparing?

thanks for your patience.

...and my connectionstrings.config file has the following:

 <add
      name="SiteSqlServer"
      connectionString="Server=abcde\fghij;Database=admin_mssql027;uid=5df2;pwd=xxxx;"
      providerName="System.Data.SqlClient" />
  </connectionStrings>
 

If this is what you are referring to, I think they are set up equally in both sections. I am still getting the same message though.