 |
|
|
Joined: 4/8/2006
Posts: 3
|
|
|
I get following error, if anyone can help me out how to fix it, I will greatly appreciate it. I am using SQL Server 2000 on WinXP.
Thanks.
Server Error in '/DotNetNuke/dnn' Application.
Could not find file 'C:\dotnetNuke\install\Providers\DataProviders\SqlDataProvider\DotNetNuke_template.mdf'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.IO.FileNotFoundException: Could not find file 'C:\dotnetNuke\install\Providers\DataProviders\SqlDataProvider\DotNetNuke_template.mdf'.
Source Error:
The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:
1. Add a "Debug=true" directive at the top of the file that generated the error. Example:
<%@ Page Language="C#" Debug="true" %>
or:
2) Add the following section to the configuration file of your application:
<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>
Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.
Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario. |
Stack Trace:
[FileNotFoundException: Could not find file 'C:\dotnetNuke\install\Providers\DataProviders\SqlDataProvider\DotNetNuke_template.mdf'.]
System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) +2014381
System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite) +488
DotNetNuke.Data.SqlDataProvider.GetProviderPath() +220
DotNetNuke.Entities.Portals.PortalSettings.GetProviderPath() +10
DotNetNuke.Framework.Install.NoUpgrade() +30
DotNetNuke.Framework.Install.Page_Load(Object sender, EventArgs e) +452
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
|
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
|
| |
|
|
 | |
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
hi,do a search for "DotNetNuke_template.mdf'" on the site, this issue has already been addressed.
|
| |
|
|
| |
|
|
Joined: 4/8/2006
Posts: 3
|
|
|
I did a search on it, nothing is found. help!!!
|
| |
|
|
| |
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
hi,
sorry about that, i thought i saw it here, anyhow:
just simply create a blank DB in sql server, create a login and user called dnnuser or whatever in the dotnetnuke_template.mdf, give the user dbo_owner to the DB.
- copy it your your C:\Inetpub\wwwroot\dotnetnuke\Providers\DataProviders\SqlDataProvider directory (also you will want to save it your your development directory of DNN in the same location,so ifyou deploy using VS, the DB will be copied over to your production site into the correct location.
there's also a training video on this at http://www.traincert.net, and the DNN manuals also explain how to create it (DotNetNuke Installation Guide)
|
| |
|
|
| |
|
|
Joined: 4/8/2006
Posts: 3
|
|
|
Thanks, I got past that error and now get following error. I checked the connectionstring in web.config file. I have SQL Server 2000 on XP.
What am I doing wrong? Help!
web.config
<connectionStrings>
<!-- Connection String for SQL Server 2005 Express -->
<add
name="SiteSqlServer"
connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
providerName="System.Data.SqlClient" />
<!-- Connection String for SQL Server 2000/2005
<add
name="SiteSqlServer"
connectionString="Server=(local);Database=DotNetNuke;uid=dnn_user;pwd=password;"
providerName="System.Data.SqlClient" />
-->
</connectionStrings>
<appSettings>
<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->
<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/>
<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules
<add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=dnn_user;pwd=password;"/>
-->
Error Installing DotNetNuke
Current Assembly Version: 04.00.02
ERROR: Could not connect to database specified in connectionString for SqlDataProviderSystem.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.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /***** Initialization Script *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and dnn_ *****/ /***** *****/ /************************************************************/ if exists (select * from dbo.sysobjects where id = object_id(N'Version') and OBJECTPROPERTY(id, N'IsTable') = 1) begin if 'dnn_' <> '' begin EXECUTE sp_rename N'dbo.Version', N'dnn_Version', 'OBJECT' EXECUTE sp_rename N'PK_Version', N'PK_dnn_Version', 'OBJECT' EXECUTE sp_rename N'IX_Version', N'IX_dnn_Version', 'INDEX' ALTER TABLE dbo.dnn_Version ADD CONSTRAINT IX_dnn_Version UNIQUE NONCLUSTERED ( Major, Minor, Build ) ON [PRIMARY] end end else begin if not exists (select * from dbo.sysobjects where id = object_id(N'dnn_Version') and OBJECTPROPERTY(id, N'IsTable') = 1) begin CREATE TABLE dbo.dnn_Version ( [VersionId] [int] IDENTITY (1, 1) NOT NULL , [Major] [int] NOT NULL , [Minor] [int] NOT NULL , [Build] [int] NOT NULL , [CreatedDate] [datetime] NOT NULL ) ON [PRIMARY] ALTER TABLE dbo.dnn_Version WITH NOCHECK ADD CONSTRAINT [PK_dnn_Version] PRIMARY KEY CLUSTERED ( [VersionId] ) ON [PRIMARY] ALTER TABLE dbo.dnn_Version ADD CONSTRAINT IX_dnn_Version UNIQUE NONCLUSTERED ( Major, Minor, Build ) ON [PRIMARY] end end 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.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dnn_GetDatabaseVersion') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.dnn_GetDatabaseVersion 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.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.dnn_GetDatabaseVersion as select Major, Minor, Build from dnn_Version where VersionId = ( select max(VersionId) from dnn_Version ) 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.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dnn_FindDatabaseVersion') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.dnn_FindDatabaseVersion 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.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.dnn_FindDatabaseVersion @Major int, @Minor int, @Build int as select 1 from dnn_Version where Major = @Major and Minor = @Minor and Build = @Build 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.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dnn_UpdateDatabaseVersion') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.dnn_UpdateDatabaseVersion 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.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.dnn_UpdateDatabaseVersion @Major int, @Minor int, @Build int as insert into dnn_Version ( Major, Minor, Build, CreatedDate ) values ( @Major, @Minor, @Build, getdate() )
|
| |
|
|
| |