|
|
|
Joined: 9/18/2003
Posts: 3
|
|
|
Hello,
Just downloaded and installed the Media module and I am getting the following error:
Error: Media 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.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 DotNetNuke.Modules.Media.SqlDataProvider.GetMedia(Int32 moduleId) at DotNetNuke.Modules.Media.MediaController.GetMedia(Int32 moduleID) at DotNetNuke.Modules.Media.MediaModule.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
I have tried the uninstall/reinstall solution, as well as the uninstall the image module, reinstall media module to no avail. Other modules work fine (except for the FAQ and Survey which throw the same error) and permissions are set wide open in SQL Server.
Any ideas?
|
|
|
|
| |
|
|
Joined: 9/18/2003
Posts: 3
|
|
|
I fixed it. In the web.config I forgot to change the appsettings to SQL Server 2000 (I just changed the connections string). I just commented out the SQL Express stuff and configured the SQL Server 2000 appsetting and everything went well.
|
|
|
|
| |
|
|
Joined: 2/28/2007
Posts: 1
|
|
|
Hi I get he following error when installing Media Module
Resource Upload Logs |
Return |
|
StartJob |
Starting Installation |
StartJob |
Reading files |
Info |
Loading DotNetNuke.Modules.Media.dll |
Info |
File DotNetNuke.Modules.Media.dll read successfully |
Info |
Loading EditMedia.ascx |
Info |
File EditMedia.ascx read successfully |
Info |
Loading MediaModule.ascx |
Info |
File MediaModule.ascx read successfully |
Info |
Loading EditMedia.ascx.resx |
Info |
File EditMedia.ascx.resx read successfully |
Info |
Loading MediaModule.ascx.resx |
Info |
File MediaModule.ascx.resx read successfully |
Info |
Loading DotNetNuke.Modules.Media.SqlDataProvider.dll |
Info |
File DotNetNuke.Modules.Media.SqlDataProvider.dll read successfully |
Info |
Loading 03.02.00.SqlDataProvider |
Info |
File 03.02.00.SqlDataProvider read successfully |
Info |
Loading 03.02.03.SqlDataProvider |
Info |
File 03.02.03.SqlDataProvider read successfully |
Info |
Loading Uninstall.SqlDataProvider |
Info |
File Uninstall.SqlDataProvider read successfully |
Info |
Loading DNN_Media.dnn |
Info |
File DNN_Media.dnn 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 EditMedia.ascx.resx. |
Info |
Found valid path (App_LocalResources) for MediaModule.ascx.resx. |
Info |
Loading Modules info |
Info |
Loading Control info for 'Media' module |
EndJob |
Dnn load finished successfully |
|
StartJob |
Begin Sql execution |
Info |
Executing 03.02.00.SqlDataProvider |
StartJob |
Start Sql execution: 03.02.00.SqlDataProvider file |
Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is already an object named 'UpgradeMedia' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /***** Used only once during Upgrade *****/ CREATE PROCEDURE dbo.UpgradeMedia @OldModuleDefID INT, @NewModuleDefID INT AS UPDATE Modules SET ModuleDefID = @NewModuleDefID WHERE ModuleDefID = @OldModuleDefID |
EndJob |
End Sql execution: 03.02.00.SqlDataProvider file |
|
Info |
Executing 03.02.03.SqlDataProvider |
StartJob |
Start Sql execution: 03.02.03.SqlDataProvider file |
Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'MediaAlignment' in table 'dbo.Media' is specified more than once. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.Media ADD MediaAlignment int NULL System.Data.SqlClient.SqlException: Column already has a DEFAULT bound to it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.Media ADD CONSTRAINT DF_Media_MediaAlignment DEFAULT 0 FOR MediaAlignment |
EndJob |
End Sql execution: 03.02.03.SqlDataProvider file |
|
EndJob |
Finished Sql execution |
|
StartJob |
Creating files |
Failure |
ExceptionSystem.UnauthorizedAccessException: Access to the path 'D:\Inetpub\vhosts\thoughtpowers.com\httpdocs\bin\DotNetNuke.Modules.Media.dll' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.SetAttributes(String path, FileAttributes fileAttributes) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFile(String FullFileName, Byte[] Buffer) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateBinFile(PaFile File) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFiles(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install() |
|
|
|
|
|
|
| |