DNA General   Ask your general questions about DNA in here.
Moderatoren : Ray

Connection String problem SQLExpress 2008

• #0  20-11-2011 3:55:41

  ---

  aagincic Copper lv1 19 Punten 1 Draden 3 Berichten

  Hello, i have same problem ... I have use web.config provided there I make next steps: 1. create database in Microsoft SQL Management Studio 2. run tool windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe and create membership objects 3. Add permissions for test user 4. Edit connection string settings: add name="PubDB" connectionstring="Data Source=.\SQLEXPRESS;Initial Catalog=my_database;User ID=test;Password=test;MultipleActiveResultSets=True" providername="System.Data.SqlClient" add name="ForumDB" connectionstring="Data Source=.\SQLEXPRESS;Initial Catalog=my_database;User ID=test;Password=test;MultipleActiveResultSets=True" providername="System.Data.SqlClient" add name="DNADB" connectionstring="Data Source=.\SQLEXPRESS;Initial Catalog=my_database;User ID=test;Password=test;MultipleActiveResultSets=True" providername="System.Data.SqlClient" add name="DefaultConnection" connectionstring="Data Source=.\SQLEXPRESS;Initial Catalog=my_database;User ID=test;Password=test;MultipleActiveResultSets=True" providername="System.Data.SqlClient" add name="LogConnection" connectionstring="Data Source=.\SQLEXPRESS;Initial Catalog=my_database;User ID=test;Password=test;MultipleActiveResultSets=True" providername="System.Data.SqlClient" But i receive same error: System.Data.Entity.Internal.InternalContext.SaveChanges() at DNA.Mvc.Installation.InstallationHelpers.WidgetsSeed(IDataContext dbContext) at DNA.Mvc.Controllers.InstallController.CreateWeb(Web web, String solution) The fail happed by website creation, (user created site successful) I have tried more combinations of setting but not help. There is one couple questions about that: 1. can i have all in one database 2. in web.config for log database is used attached database – that is required? Thanks Sasa

  • IP:******
  • 

• #1  20-11-2011 6:22:13

  ---

  thangcq Copper lv1 3 Punten 0 Draden 1 Berichten

  You don't need create database, DNA will automatically create database (CodeFirst), just change connectionstring in webconfig like this add name="DNADB" connectionstring="Data Source=.;Initial Catalog=DNADB;Integrated Security=True;MultipleActiveResultSets=True" providername="System.Data.SqlClient" add name="EcomDB" connectionstring="Data Source=.;Initial Catalog=EcomDB;Integrated Security=True;MultipleActiveResultSets=True" providername="System.Data.SqlClient" add name="DefaultConnection" connectionstring="Data Source=.;Initial Catalog=aspmembership;Integrated Security=True;MultipleActiveResultSets=True" providername="System.Data.SqlClient"

  • IP:******
  • 

• #2  20-11-2011 13:27:12

  ---

  aagincic Copper lv1 19 Punten 1 Draden 3 Berichten

  Many databases? That is nessesery? Ok... later can i have user sql login (by deploy)? While i can't have Integrated security on production server. Thanks Sasa

  • IP:******
  • 

• #3  21-11-2011 0:00:15

  ---

  Ray Copper lv1 176 Punten 22 Draden 198 Berichten

  Please read the following article it maybe help https://dotnetage.com/publishing/dna/2011/09/03/6915/how-to-use-sqlserver-for-dotnetage2-1-.html Sharing my ideas and codes to make things change.

  • IP:******
  • 

• #4  21-11-2011 1:35:07

  ---

  aagincic Copper lv1 19 Punten 1 Draden 3 Berichten

  Ok here we go: First i have do so but i receive error: Cannot open database "dna_test" requested by the login. The login failed. Login failed for user 'test'. Same things is with integrated security=true and setting application pool to local system, there is no security combination then can successfully create a database Second i have create database dna_test and set valuable permissions Then receive I error: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. third I have run %windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe Then i become screen for create user User creation was successful But for site creation I receive error An error occurred while updating the entries. See the inner exception for details. Source:EntityFramework Data:System.Collections.ListDictionaryInternal StackTrace: 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) That was message in View Installation Log I have search word CheckSchemaVersion but i found in source nothing: Namespace = "https://dotnetage.com/XML/Schema/installer/config/sql" where is in solutuon installation scripts?

  • IP:******
  • 

• #5  21-11-2011 10:47:55

  ---

  Ray Copper lv1 176 Punten 22 Draden 198 Berichten

  In order to install DotNetAge by manual you maybe try the following steps: Step1. Install asp.net common, profile,membership, roles sql scripts %windir%\Microsoft.NET\Framework\v2.0.50727\InstallCommon.sql %windir%\Microsoft.NET\Framework\v2.0.50727\InstallMembership.sql %windir%\Microsoft.NET\Framework\v2.0.50727\InstallProfile.SQL %windir%\Microsoft.NET\Framework\v2.0.50727\InstallRoles.sql Step2. Run the DnaDB install.sql 1:   2: create table [dbo].[EdmMetadata] ( 3: [Id] [int] not null identity, 4: [ModelHash] [nvarchar](max) null, 5: primary key ([Id]) 6: ); 7: create table [dbo].[dna_myfollows] ( 8: [ID] [int] not null identity, 9: [UserName] [nvarchar](255) not null, 10: [FollowerName] [nvarchar](255) not null, 11: primary key ([ID]) 12: ); 13: create table [dbo].[dna_MyFriends] ( 14: [ID] [int] not null identity, 15: [UserName] [nvarchar](255) not null, 16: [FriendName] [nvarchar](255) not null, 17: [IsFriend] [bit] not null, 18: [Impression] [int] not null, 19: [Added] [datetime] not null, 20: [IsBadGuy] [bit] not null, 21: [Group] [nvarchar](255) null, 22: primary key ([ID]) 23: ); 24: create table [dbo].[dna_Passports] ( 25: [ID] [int] not null identity, 26: [Type] [int] null, 27: [UserData] [ntext] null, 28: [UserId] [nvarchar](max) null, 29: [UserName] [nvarchar](255) null, 30: primary key ([ID]) 31: ); 32: create table [dbo].[dna_Permissions] ( 33: [ID] [int] not null identity, 34: [Title] [nvarchar](255) null, 35: [Action] [nvarchar](255) null, 36: [Assembly] [nvarchar](1024) null, 37: [Controller] [nvarchar](255) null, 38: [Description] [ntext] null, 39: [PermissionSetID] [int] not null, 40: primary key ([ID]) 41: ); 42: create table [dbo].[dna_PermsInRoles] ( 43: [PermID] [int] not null, 44: [RoleName] [nvarchar](128) not null, 45: primary key ([PermID], [RoleName]) 46: ); 47: create table [dbo].[dna_PermissionSets] ( 48: [ID] [int] not null identity, 49: [Name] [nvarchar](100) null, 50: [Title] [nvarchar](255) null, 51: [Description] [ntext] null, 52: [ResbaseName] [nvarchar](255) null, 53: [TitleResName] [nvarchar](255) null, 54: primary key ([ID]) 55: ); 56: create table [dbo].[dna_messages] ( 57: [ID] [int] not null identity, 58: [Sender] [nvarchar](1024) null, 59: [Receivers] [ntext] null, 60: [Reads] [ntext] null, 61: [Received] [datetime] not null, 62: [Sent] [datetime] not null, 63: [Title] [nvarchar](1024) null, 64: [Content] [ntext] null, 65: [Encoding] [nvarchar](50) null, 66: [ContentType] [nvarchar](50) null, 67: primary key ([ID]) 68: ); 69: create table [dbo].[dna_Subscriptions] ( 70: [ID] [int] not null identity, 71: [HashKey] [int] not null, 72: [Token] [nvarchar](2048) not null, 73: [UserName] [nvarchar](50) not null, 74: primary key ([ID]) 75: ); 76: create table [dbo].[dna_WebSettings] ( 77: [Id] [int] not null identity, 78: [Name] [nvarchar](1024) not null, 79: [Title] [nvarchar](50) null, 80: [Type] [int] not null, 81: [Theme] [nvarchar](255) null, 82: [TimeZone] [nvarchar](255) null, 83: [AllowExtensions] [ntext] null, 84: [CacheDuration] [int] not null, 85: [Copyright] [ntext] null, 86: [Created] [datetime] not null, 87: [CssText] [ntext] null, 88: [Data] [ntext] null, 89: [DefaultLanguage] [nvarchar](50) null, 90: [DefaultUrl] [nvarchar](1024) null, 91: [Description] [ntext] null, 92: [EnableUserRegistration] [bit] not null, 93: [IsEnabled] [bit] not null, 94: [Layout] [nvarchar](1024) null, 95: [LogoImageUrl] [nvarchar](1024) null, 96: [MasterName] [nvarchar](1024) null, 97: [MaximumFileSize] [int] not null, 98: [MostOnlined] [datetime] not null, 99: [MostOnlineUserCount] [int] not null, 100: [Owner] [nvarchar](256) not null, 101: [SearchKeywords] [ntext] null, 102: [ShortcutIconUrl] [nvarchar](1024) null, 103: primary key ([Id]) 104: ); 105: create table [dbo].[dna_WebPages] ( 106: [ID] [int] not null identity, 107: [WebID] [int] not null, 108: [Title] [nvarchar](255) not null, 109: [ViewData] [ntext] null, 110: [ViewName] [nvarchar](255) null, 111: [AllowAnonymous] [bit] not null, 112: [Created] [datetime] not null, 113: [Description] [ntext] null, 114: [IconUrl] [nvarchar](1024) null, 115: [ImageUrl] [nvarchar](1024) null, 116: [IsShared] [bit] not null, 117: [IsStatic] [bit] not null, 118: [Keywords] [ntext] null, 119: [LastModified] [datetime] not null, 120: [LinkUrl] [nvarchar](1024) null, 121: [Owner] [nvarchar](255) not null, 122: [ParentID] [int] not null, 123: [Path] [nvarchar](1024) not null, 124: [Pos] [int] not null, 125: [ShowInMenu] [bit] not null, 126: [Target] [nvarchar](50) not null, 127: primary key ([ID]) 128: ); 129: create table [dbo].[dna_WebPageRoles] ( 130: [PageID] [int] not null, 131: [RoleName] [nvarchar](128) not null, 132: primary key ([PageID], [RoleName]) 133: ); 134: create table [dbo].[dna_WidgetDescriptors] ( 135: [ID] [int] not null identity, 136: [Action] [nvarchar](255) null, 137: [Area] [nvarchar](1024) null, 138: [ContentType] [nvarchar](50) null, 139: [ContentUrl] [nvarchar](2048) null, 140: [Controller] [nvarchar](255) null, 141: [Defaults] [ntext] null, 142: [Description] [ntext] null, 143: [IconUrl] [nvarchar](1024) null, 144: [ImageUrl] [nvarchar](1024) null, 145: [InstalledPath] [nvarchar](1024) null, 146: [IsClosable] [bit] null, 147: [IsDeletable] [bit] null, 148: [Scopes] [int] not null, 149: [ShowBorder] [bit] not null, 150: [ShowHeader] [bit] null, 151: [Title] [nvarchar](50) null, 152: [TitleLinkUrl] [nvarchar](1024) null, 153: [Version] [nvarchar](50) null, 154: [Modified] [datetime] not null, 155: primary key ([ID]) 156: ); 157: create table [dbo].[dna_Widgets] ( 158: [ID] [uniqueidentifier] not null, 159: [DescriptorID] [int] not null, 160: [PageID] [int] not null, 161: [Action] [nvarchar](255) null, 162: [Area] [nvarchar](1024) null, 163: [BodyCssText] [ntext] null, 164: [ContentUrl] [nvarchar](2048) null, 165: [Controller] [nvarchar](255) null, 166: [CssText] [ntext] null, 167: [Data] [image] null, 168: [HeaderCssText] [ntext] null, 169: [IconUrl] [nvarchar](1024) null, 170: [IsClosable] [bit] not null, 171: [IsDeletable] [bit] not null, 172: [IsExpanded] [bit] not null, 173: [IsStatic] [bit] not null, 174: [Pos] [int] not null, 175: [Scope] [int] not null, 176: [ShowBorder] [bit] not null, 177: [ShowHeader] [bit] not null, 178: [Title] [nvarchar](255) null, 179: [TitleLinkUrl] [nvarchar](1024) null, 180: [ZoneID] [nvarchar](255) null, 181: primary key ([ID]) 182: ); 183: alter table [dbo].[dna_PermsInRoles] add constraint [PermissionRole_Permission] foreign key ([PermID]) references [dbo].[dna_Permissions]([ID]) on delete cascade; 184: alter table [dbo].[dna_Permissions] add constraint [PermissionSet_Permissions] foreign key ([PermissionSetID]) references [dbo].[dna_PermissionSets]([ID]) on delete cascade; 185: alter table [dbo].[dna_WebPages] add constraint [WebPage_Web] foreign key ([WebID]) references [dbo].[dna_WebSettings]([Id]) on delete cascade; 186: alter table [dbo].[dna_WebPageRoles] add constraint [WebPageRole_WebPage] foreign key ([PageID]) references [dbo].[dna_WebPages]([ID]) on delete cascade; 187: alter table [dbo].[dna_Widgets] add constraint [WidgetDescriptor_Widgets] foreign key ([DescriptorID]) references [dbo].[dna_WidgetDescriptors]([ID]) on delete cascade; 188: alter table [dbo].[dna_Widgets] add constraint [WidgetInstance_WebPage] foreign key ([PageID]) references [dbo].[dna_WebPages]([ID]) on delete cascade; Step3: connectionStrings: 1:   2: <connectionStrings> 3: <add name="DNADB" connectionString="multipleactiveresultsets=True;data source=YourServerName;initial catalog=YourDBName;integrated security=True;multipleactiveresultsets=True" providerName="System.Data.SqlClient" /> 4: <add name="LogConnection" connectionString="Data Source=|DataDirectory|log.sdf" providerName="System.Data.SqlServerCe.4.0" /> 5: connectionStrings> Step4: change membership/roles/profile providers (SQLServer could not use the System.Web.Provders) 1:   2: <membership defaultProvider="DefaultMembershipProvider"> 3: <providers> 4: <clear /> 5: <add name="DefaultMembershipProvider" 6: type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="DNADB" 7: ... /> 8: providers> 9: membership> 10: <profile defaultProvider="DefaultProfileProvider" inherits="DNA.Mvc.UserProfile"> 11: <providers> 12: <clear /> 13: <add name="DefaultProfileProvider" 14: type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" 15: connectionStringName="DNADB" 16: applicationName="/" /> 17: providers> 18: <properties> 19: ... 20: properties> 21: profile> 22: <roleManager enabled="true" cacheRolesInCookie="true" cookieName=".MVCROLES" defaultProvider="DefaultRoleProvider"> 23: <providers> 24: <clear /> 25: <add connectionStringName="DNADB" applicationName="/" name="DefaultRoleProvider" 26: type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> 27: <add applicationName="/" name="AspNetWindowsTokenRoleProvider" 28: type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> 29: providers> 30: roleManager> Sharing my ideas and codes to make things change.

  • IP:******
  • 

• #6  21-11-2011 13:45:23

  ---

  aagincic Copper lv1 19 Punten 1 Draden 3 Berichten

  Thanks - now i'ts ok. Sasa

  • IP:******
  •