Has anyone else had problems installing third-party modules? I'm pretty new at this, so I suspect I'm just doing something wrong, but it's pretty frustrating...
I recently purchased the ReportXP module, but have been having trouble installing it in my portal instance. I logged in as HOST, selected MODULE DEFINITIONS, clicked INSTALL NEW MODULE, broswed to the location of the zip file I downloaded (ICPC-ReportXP-PA-2005-04-00.zip) , clicked SAVE FILE, and got the following report:
| |
| StartJob |
Starting Installation |
| StartJob |
Reading files |
| Info |
Loading ICPC.DNN.Modules.ReportXP.dll |
| Info |
File ICPC.DNN.Modules.ReportXP.dll read successfully |
| Info |
Loading app.config |
| Info |
File app.config read successfully |
| Info |
Loading icon_ReportServices_32px.gif |
| Info |
File icon_ReportServices_32px.gif read successfully |
| Info |
Loading module.css |
| Info |
File module.css read successfully |
| Info |
Loading ReportServices.ascx |
| Info |
File ReportServices.ascx read successfully |
| Info |
Loading ReportServicesEdit.ascx |
| Info |
File ReportServicesEdit.ascx read successfully |
| Info |
Loading Settings.ascx |
| Info |
File Settings.ascx read successfully |
| Info |
Loading ReportServices.ascx.resx |
| Info |
File ReportServices.ascx.resx read successfully |
| Info |
Loading ReportServicesEdit.ascx.resx |
| Info |
File ReportServicesEdit.ascx.resx read successfully |
| Info |
Loading Settings.ascx.resx |
| Info |
File Settings.ascx.resx read successfully |
| Info |
Loading Reference.map |
| Info |
File Reference.map read successfully |
| Info |
Loading reportservice.wsdl |
| Info |
File reportservice.wsdl read successfully |
| Info |
Loading ICPC.DNN.Modules.ReportXP.SqlDataProvider.dll |
| Info |
File ICPC.DNN.Modules.ReportXP.SqlDataProvider.dll read successfully |
| Info |
Loading 01.00.00.SqlDataProvider |
| Info |
File 01.00.00.SqlDataProvider read successfully |
| Info |
Loading Uninstall.SqlDataProvider |
| Info |
File Uninstall.SqlDataProvider read successfully |
| Info |
Loading ICPC-ReportXP.dnn |
| Info |
File ICPC-ReportXP.dnn read successfully |
| Info |
Loading ICPC.DNN.Modules.ReportViewer.dll |
| Info |
File ICPC.DNN.Modules.ReportViewer.dll read successfully |
| EndJob |
Reading files done. |
| |
| StartJob |
Reading DNN file |
| Info |
DNN file is in valid 3.0 format. |
| Info |
xml loaded. |
| Info |
Loading files info |
| Info |
Found valid path (App_LocalResources) for ReportServices.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for ReportServicesEdit.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for Settings.ascx.resx. |
| Info |
Found valid path (Web References\com.icpconline.dnndev) for Reference.map. |
| Info |
Found valid path (Web References\com.icpconline.dnndev) for reportservice.wsdl. |
| Info |
Loading Modules info |
| Info |
Loading Control info for 'ICPC-ReportXP' module |
| EndJob |
Dnn load finished successfully |
| |
| StartJob |
Begin Sql execution |
| Info |
Executing 01.00.00.SqlDataProvider |
| StartJob |
Start Sql execution: 01.00.00.SqlDataProvider file |
| EndJob |
End Sql execution: 01.00.00.SqlDataProvider file |
| |
| EndJob |
Finished Sql execution |
| |
| StartJob |
Creating files |
| Info |
Created c:\inetpub\wwwroot\doePortal\bin\ICPC.DNN.Modules.ReportXP.dll |
| Info |
Created c:\inetpub\wwwroot\doePortal\bin\ICPC.DNN.Modules.ReportViewer.dll |
| Info |
Created c:\inetpub\wwwroot\doePortal\DesktopModules\ICPC-ReportXP\app.config |
| Info |
Created c:\inetpub\wwwroot\doePortal\DesktopModules\ICPC-ReportXP\icon_ReportServices_32px.gif |
| Info |
Created c:\inetpub\wwwroot\doePortal\DesktopModules\ICPC-ReportXP\module.css |
| Info |
Created c:\inetpub\wwwroot\doePortal\DesktopModules\ICPC-ReportXP\ReportServices.ascx |
| Info |
Created c:\inetpub\wwwroot\doePortal\DesktopModules\ICPC-ReportXP\ReportServicesEdit.ascx |
| Info |
Created c:\inetpub\wwwroot\doePortal\DesktopModules\ICPC-ReportXP\Settings.ascx |
| Info |
Created c:\inetpub\wwwroot\doePortal\DesktopModules\ICPC-ReportXP\App_LocalResources\ReportServices.ascx.resx |
| Info |
Created c:\inetpub\wwwroot\doePortal\DesktopModules\ICPC-ReportXP\App_LocalResources\ReportServicesEdit.ascx.resx |
| Info |
Created c:\inetpub\wwwroot\doePortal\DesktopModules\ICPC-ReportXP\App_LocalResources\Settings.ascx.resx |
| Info |
Created c:\inetpub\wwwroot\doePortal\DesktopModules\ICPC-ReportXP\Web References\com.icpconline.dnndev\Reference.map |
| Info |
Created c:\inetpub\wwwroot\doePortal\DesktopModules\ICPC-ReportXP\Web References\com.icpconline.dnndev\reportservice.wsdl |
| Info |
Created c:\inetpub\wwwroot\doePortal\bin\ICPC.DNN.Modules.ReportXP.SqlDataProvider.dll |
| Info |
Created c:\inetpub\wwwroot\doePortal\DesktopModules\ICPC-ReportXP\Providers\DataProviders\SqlDataProvider\01.00.00.SqlDataProvider |
| Info |
Created c:\inetpub\wwwroot\doePortal\DesktopModules\ICPC-ReportXP\Uninstall.SqlDataProvider |
| Info |
Created c:\inetpub\wwwroot\doePortal\DesktopModules\ICPC-ReportXP\ICPC-ReportXP.dnn.config |
| EndJob |
Files created |
| |
| StartJob |
Registering DesktopModule |
| Info |
Registering Definitions |
| Info |
Registering Controls |
| EndJob |
Registering finished |
| |
| EndJob |
Installation successful. |
|
Then, I added an instance of the ReportXP module to my home page. When I refreshed the page, here's what I got in the module section:
Error: eBilling Reports 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: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) ---> 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: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) 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 ICPC.DNN.Modules.ReportXP.Data.SqlDataProvider.Get_ReportServices(Int32 moduleId) at ICPC.DNN.Modules.ReportXP.Business.ReportServicesController.Get(Int32 moduleId) at ICPC.DNN.Modules.ReportXP.ReportServices.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
I checked the Surface Area Configuration remote connection setup on my database server, and it's configured to access local and remote connections via both TCP/IP and named pipes.
Any suggestions?
-- Tony