| |
|
|
|
|
|
|
|
|
|
 |  | |
| | |
| | |
| | |
 | | |
|
|
|
| Error Installing DotNetNuke |
|
|
I have successfully recreated the error I was getting when trying to
follow the tutorial on creating DNN4 modules
(http://www.adefwebserver.com/DotNetNukeHELP/DNN_Module4/DotNetNuke_module_4.htm).
This is the page I get to and I am on the create the table section. As
soon as I try and go to the SQL script executer under the host menu
this is the error that I get
Error Installing DotNetNuke
Current Assembly Version: 04.00.02
ERROR: Could not connect to database specified in connectionString for
SqlDataProviderSystem.Data.SqlClient.SqlException: Cannot open user default
database. Login failed. Login failed for user 'DARRYLW\ASPNET'. 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 *****/ /***** *****/
/************************************************************/ if exists (select
* from dbo.sysobjects where id = object_id(N'Version') and OBJECTPROPERTY(id,
N'IsTable') = 1) begin if '' <> '' begin EXECUTE sp_rename N'dbo.Version',
N'Version', 'OBJECT' EXECUTE sp_rename N'PK_Version', N'PK_Version', 'OBJECT'
EXECUTE sp_rename N'IX_Version', N'IX_Version', 'INDEX' ALTER TABLE dbo.Version
ADD CONSTRAINT IX_Version UNIQUE NONCLUSTERED ( Major, Minor, Build ) ON
[PRIMARY] end end else begin if not exists (select * from dbo.sysobjects where
id = object_id(N'Version') and OBJECTPROPERTY(id, N'IsTable') = 1) begin CREATE
TABLE dbo.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.Version WITH NOCHECK ADD
CONSTRAINT [PK_Version] PRIMARY KEY CLUSTERED ( [VersionId] ) ON [PRIMARY] ALTER
TABLE dbo.Version ADD CONSTRAINT IX_Version UNIQUE NONCLUSTERED ( Major, Minor,
Build ) ON [PRIMARY] end end System.Data.SqlClient.SqlException: Cannot open
user default database. Login failed. Login failed for user 'DARRYLW\ASPNET'. 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'GetDatabaseVersion') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure dbo.GetDatabaseVersion System.Data.SqlClient.SqlException: Cannot
open user default database. Login failed. Login failed for user
'DARRYLW\ASPNET'. 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.GetDatabaseVersion as select Major, Minor,
Build from Version where VersionId = ( select max(VersionId) from Version )
System.Data.SqlClient.SqlException: Cannot open user default database. Login
failed. Login failed for user 'DARRYLW\ASPNET'. 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'FindDatabaseVersion') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure dbo.FindDatabaseVersion System.Data.SqlClient.SqlException:
Cannot open user default database. Login failed. Login failed for user
'DARRYLW\ASPNET'. 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.FindDatabaseVersion @Major int, @Minor
int, @Build int as select 1 from Version where Major = @Major and Minor = @Minor
and Build = @Build System.Data.SqlClient.SqlException: Cannot open user default
database. Login failed. Login failed for user 'DARRYLW\ASPNET'. 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'UpdateDatabaseVersion') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure dbo.UpdateDatabaseVersion System.Data.SqlClient.SqlException:
Cannot open user default database. Login failed. Login failed for user
'DARRYLW\ASPNET'. 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.UpdateDatabaseVersion @Major int, @Minor
int, @Build int as insert into Version ( Major, Minor, Build, CreatedDate )
values ( @Major, @Minor, @Build, getdate() )
What is this? Why am I getting this error? I'm not trying to install DNN. Why is trying to install it? I've done everything in the
tutorial step by step being very careful not to skip anything and then
this happens. The database is on, I've checked the connection string in
the web.config and it's correct.
Thanks
Darryl
|
|
|
|
| |
| | |
| | |
| | |
|  |
| |
|
|
|
These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.
For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
|
| |
|
|
|
|
|
Multipartner Virtual Data Rooms
The Virtual Data Rooms (VDR) provided by an expert advisor, far from any ordinary software company!, supporting the sellers and their consultants.
Multipartner builds and services higly professional Virtual Data Rooms (VDR) specifically tailored to M&A, Real Estate and NPL deals.
www.multipartner.com
|
DNN SEO
Seablick Consulting specializes in DNN search engine optimization (SEO), DNN consulting, as well as support & training.
seablick.com
|
Intura Vision / Intura Enterprise
Point-of-Sale and business management applications targeted towards quick service, fast casual and delivery-based restaurant concepts.
www.intura.com
|
|
|
|