DotNetAge - Mvc & jQuery CMS - Install Error With SQL Express 2008 R2 , Pls Help!

Install Error With SQL Express 2008 R2 , Pls Help!

Condividere per:

16 Risposte

Ultimo Post:

pppttt

21/10/2011 05:24:22

Previous thread:[installation]

Next thread:[Loading Localization Exception]

#0 03/10/2011 19:24:01

pppttt


Copper lv1
28 Punti
1 Discussioni
6 Messaggi

I try to install Dotnetage 2.1.2 with SQL Express 2008 R2, But I got follow errror while install core solution:

An error occurred while updating the entries. See the inner exception for details.

源:EntityFramework

数据:System.Collections.ListDictionaryInternal

跟踪堆栈:

at System.Data.Entity.Internal.InternalContext.SaveChanges() at DNA.Mvc.Installation.InstallationHelpers.WidgetsSeed(IDataContext dbContext) at DNA.Mvc.Controllers.InstallController.CreateWeb(Web web, String solution)

I track this error with VS2010 and found: "InnerException = {"对象名 'dbo.dna_WidgetDescriptors' 无效。"}".

What can I do now? Pls Help !

Thanks!

IP:******

#1 03/10/2011 19:25:54

pppttt


Copper lv1
28 Punti
1 Discussioni
6 Messaggi

BTW, my connect string in web.config is :

connectionstrings
add providerName="System.Data.SqlClient" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=DNADB;Integrated Security=True;MultipleActiveResultSets=True" name="DNADB"
add providerName="System.Data.SqlServerCe.4.0" connectionString="Data Source=|DataDirectory|log.sdf" name="LogConnection"
connectionstrings

IP:******

#2 03/10/2011 19:47:42

Ray


Copper lv1
176 Punti
22 Discussioni
198 Messaggi

The following article maybe helpful https://dotnetage.com/publishing/dna/2011/09/03/6914/how-to-use-sqlexpress-for-dotnetage2-1-.html

Sharing my ideas and codes to make things change.

IP:******

#3 03/10/2011 20:16:43

pppttt


Copper lv1
28 Punti
1 Discussioni
6 Messaggi

Ray ! Thanks!
But now I got follow error:

Exception Details: System.Data.SqlClient.SqlException: 无法打开物理文件 "D:\inetpub\wwwroot\dotnetage\App_Data\aspnet.mdf"。操作系统错误 2:"2(系统找不到指定的文件。)"。
无法将文件 'D:\inetpub\wwwroot\dotnetage\App_Data\aspnet.mdf' 作为数据库 'aspnet'. 附加

where is aspnet.mdf ?

IP:******

#4 03/10/2011 20:24:20

Ray


Copper lv1
176 Punti
22 Discussioni
198 Messaggi

You have create aspnet.mdf before,you need clean the aspnet.mdf from your sqlserver or use another database for aspnet you can try the connectionstring below:

1:

   2:  <add name="DefaultConnection"

   3:  connectionstring="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\aspnet1.mdf;Initial Catalog=aspnet1;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True"

   4:  providername="System.Data.SqlClient">

Sharing my ideas and codes to make things change.

IP:******

#5 03/10/2011 20:29:27

pppttt


Copper lv1
28 Punti
1 Discussioni
6 Messaggi

I did NOT create any aspnet.mdf or others. My sql express has no any Database.

my web.config just copy from web.config.sqlexpress package.

connectionstrings
add providerName="System.Data.SqlClient" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\pubdb.mdf;Initial Catalog=PubDB;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True" name="PubDB"
add providerName="System.Data.SqlClient" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\forumdb.mdf;Initial Catalog=ForumDB;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True" name="ForumDB"
add providerName="System.Data.SqlClient" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dnadb.mdf;Initial Catalog=DNADB;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True" name="DNADB"
add providerName="System.Data.SqlClient" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\aspnet.mdf;Initial Catalog=aspnet;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True" name="DefaultConnection"
add providerName="System.Data.SqlClient" connectionString="Data Source=|DataDirectory|log.sdf" name="LogConnection"
connectionstrings

IP:******

#6 03/10/2011 20:33:05

pppttt


Copper lv1
28 Punti
1 Discussioni
6 Messaggi

It seems Dotnetage did NOT create mdf automaticly ? I think.

IP:******

#7 03/10/2011 22:29:32

Ray


Copper lv1
176 Punti
22 Discussioni
198 Messaggi

Are you host DotNetAge in IIS7 and use SQLExpress?

I think you should try to use the SQLServer or attach the SQLExpress.mdf file by using Microsoft Management Studio.

The IIS7 does not support use mdf file for SQL connection

Sharing my ideas and codes to make things change.

IP:******

#8 04/10/2011 05:52:53

pppttt


Copper lv1
28 Punti
1 Discussioni
6 Messaggi

If DNADB.mdf should be created automatically ? I got aspnetdb.mdf created, but no DNADB.mdf and get error: open dnadb login failed.
thanks

IP:******

#9 04/10/2011 06:33:51

Ray


Copper lv1
176 Punti
22 Discussioni
198 Messaggi

You don't understand what i mean yet. I said that SQLExpress mdf file can not run with IIS7 but IISExpress and VS.NET. I find an article from Rick that talk about the SQLExpress and IIS7 i hope it maybe helpful : http://www.west-wind.com/weblog/posts/2006/Mar/31/SQL-Server-Express-in-APPDATA-and-running-with-IIS

If you want to host the DotNetAge with IIS7 you should create a database in your SQLExpress and use SQLServer configuration.

Sharing my ideas and codes to make things change.

IP:******

#10 04/10/2011 07:12:09

pppttt


Copper lv1
28 Punti
1 Discussioni
6 Messaggi

I see. But I run dotnetage in VS 2010 . It's same error. No DNADB.mdf created. Thanks!

IP:******

#11 04/10/2011 09:01:51

Ray


Copper lv1
176 Punti
22 Discussioni
198 Messaggi

I do some test and get your exception now. And i will follow this error. Thank you.

Sharing my ideas and codes to make things change.

IP:******

#12 14/10/2011 08:26:00

svuser


Copper lv1
9 Punti
0 Discussioni
3 Messaggi

I recieved the same error. I'm using VS2010 and SQL SERVER2008. I created db (mdf) by myself, added SqlServices.Install in InstallController to create db structure (otherwise it won't run) and changed webconfig. But during template installing I got error just the same as pppttt.

IP:******

#13 16/10/2011 00:24:19

Ray


Copper lv1
176 Punti
22 Discussioni
198 Messaggi

I try your case last night. The pppttt and your error is comes from SQLExpress settings. The EF4.1 code first will auto create the database for us. First of all you must confirm your sql login account has enough permission for creating databases and tables.

Sharing my ideas and codes to make things change.

IP:******

#14 18/10/2011 21:55:55

svuser


Copper lv1
9 Punti
0 Discussioni
3 Messaggi

Thank you for your answer. But I'm using SQL Server 2008R2 (not express) where I have sysadmin role. Besides I have created db befor install and installation process successfully created user accounts during step 2 so I think there are no problems with permissions. These are my configuration settings:

add name="DNADB" connectionstring="Data Source=home;Initial Catalog=DNADB;Integrated Security=True;MultipleActiveResultSets=True" providername="System.Data.SqlClient"
add name="LogConnection" connectionstring="Data Source=|DataDirectory|log.sdf" providername="System.Data.SqlServerCe.4.0"

I don't know whether LogConnection is right. Thank you

IP:******

#15 21/10/2011 01:35:41

Ray


Copper lv1
176 Punti
22 Discussioni
198 Messaggi

I will release the sql file for creating the DNA database by manual

Sharing my ideas and codes to make things change.

IP:******

#16 21/10/2011 05:24:22

svuser


Copper lv1
9 Punti
0 Discussioni
3 Messaggi

Thanks for reply. I made another attempt to install without creating db by myself. Install process stopped on step 2 - it cann-t recieve access to db in code string: "var roles = Roles.GetAllRoles();" (because in fact db is still absent). So what is the right way to install cms from source code with vs 2010 and sql server? Thank you

IP:******

	DNA General Ask your general questions about DNA in here.

Moderatori : Ray

DNA General

Install Error With SQL Express 2008 R2 , Pls Help!

16 Risposte

#0 03/10/2011 19:24:01

#1 03/10/2011 19:25:54

#2 03/10/2011 19:47:42

#3 03/10/2011 20:16:43

#4 03/10/2011 20:24:20

#5 03/10/2011 20:29:27

#6 03/10/2011 20:33:05

#7 03/10/2011 22:29:32

#8 04/10/2011 05:52:53

#9 04/10/2011 06:33:51

#10 04/10/2011 07:12:09

#11 04/10/2011 09:01:51

#12 14/10/2011 08:26:00

#13 16/10/2011 00:24:19

#14 18/10/2011 21:55:55

#15 21/10/2011 01:35:41

#16 21/10/2011 05:24:22