Graveworm wrote:Could anyone plz explain to me what i should change in the Web.Config file to correctly install the forum. I'm new to Asp.Net as u might have realized by now but i really need to set up this forum.
I keep getting an error telling me that The SQL server does not exist or is not accessible.
Thanks in advance
Hi Graveworm,
I know how you feel. It took me ages to find the soutions. I made my life more difficut with some unorthodox installation with different ports. But when you stick to a standart installation you should be fine.
Here I just paste my web.confi file so you can see what you need to do.
For those who see that I use the sa to log on. I know this is not good, but this is for a test only. So the security has to be corrected.
On the path of YAF you will see that I have DNN in front. Just make sure you put the right path in. In my case the dot net nuke is accessed the following way: http://localhost/dnn.
I am sure you can find out the rest.
By the way this is DNN 3.0.11
<configuration>
<!-- register local configuration handlers -->
<configSections>
<sectionGroup name="dotnetnuke">
<section name="data" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" />
<section name="logging" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" />
<section name="scheduling" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" />
<section name="htmlEditor" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" />
<section name="searchIndex" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" />
<section name="searchDataStore" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" />
<section name="friendlyUrl" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" />
</sectionGroup>
<sectionGroup name="system.web">
<section name="membership" type="Microsoft.ScalableHosting.Configuration.MembershipConfigHandler, MemberRole, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b7c773fb104e7562" />
<section name="roleManager" type="Microsoft.ScalableHosting.Configuration.RolesConfigHandler, MemberRole, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b7c773fb104e7562" />
<section name="profile" type="Microsoft.ScalableHosting.Configuration.ProfileConfigHandler, MemberRole, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b7c773fb104e7562" />
<section name="anonymousIdentification" type="Microsoft.ScalableHosting.Configuration.AnonymousIdConfigHandler, MemberRole, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b7c773fb104e7562" />
</sectionGroup>
<section name="yafnet" type="yaf.SectionHandler,yaf" />
</configSections>
<!-- the old connectionString setting has been deprecated and replaced with the data provider section below -->
<appSettings>
<add key="SiteSqlServer" value="Server=(local);Database=DNN311;uid=sa;pwd=test;" />
<add key="MachineValidationKey" value="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902" />
<add key="MachineDecryptionKey" value="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902F8D923AC" />
<add key="MachineValidationMode" value="SHA1" />
<add key="InstallTemplate" value="DotNetNuke.install.resources" />
<add key="AutoUpgrade" value="true"/>
<add key="UseDnnConfig" value="true" />
</appSettings>
<system.web>
<!-- HttpModules for Common Functionality -->
<httpModules>
<add name="UrlRewrite" type="DotNetNuke.HttpModules.UrlRewriteModule, DotNetNuke.HttpModules.UrlRewrite" />
<add name="Exception" type="DotNetNuke.HttpModules.ExceptionModule, DotNetNuke.HttpModules.Exception" />
<add name="UsersOnline" type="DotNetNuke.HttpModules.UsersOnlineModule, DotNetNuke.HttpModules.UsersOnline" />
<add name="Profile" type="Microsoft.ScalableHosting.Profile.ProfileModule, MemberRole, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b7c773fb104e7562" />
<add name="AnonymousIdentification" type="Microsoft.ScalableHosting.Security.AnonymousIdentificationModule, MemberRole, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b7c773fb104e7562" />
<add name="RoleManager" type="Microsoft.ScalableHosting.Security.RoleManagerModule, MemberRole, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b7c773fb104e7562" />
<add name="DNNMembership" type="DotNetNuke.HttpModules.DNNMembershipModule, DotNetNuke.HttpModules.DNNMembership" />
<add name="Personalization" type="DotNetNuke.HttpModules.PersonalizationModule, DotNetNuke.HttpModules.Personalization" />
</httpModules>
<!-- This is for FTB 3.0 support -->
<httpHandlers>
<add verb="GET" path="FtbWebResource.axd" type="FreeTextBoxControls.AssemblyResourceHandler, FreeTextBox" />
</httpHandlers>
<!-- set code access security trust level - this is generally set in the machine.config
<trust level="Medium" />
-->
<!-- set debugmode to false for running application -->
<compilation debug="false" />
<!-- permits errors to be displayed for remote clients -->
<customErrors mode="RemoteOnly" />
<!-- Forms or Windows authentication -->
<authentication mode="Forms">
<forms name=".DOTNETNUKE" protection="All" timeout="60" />
<forms name="YetAnotherForum" slidingExpiration="true"/>
</authentication>
<!--
<identity impersonate="true"/>
<authentication mode="Windows">
</authentication>
-->
<!-- allow large file uploads -->
<httpRuntime useFullyQualifiedRedirectUrl="true" maxRequestLength="8192" />
<!-- GLOBALIZATION
This section sets the globalization settings of the application.
Utf-8 is not supported on Netscape 4.x
If you need netscape compatiblity leave iso-8859-1.
UTF-8 is recommended for complex languages
-->
<globalization culture="en-US" uiCulture="en" requestEncoding="UTF-8" responseEncoding="UTF-8"
fileEncoding="UTF-8" />
<!--<globalization culture="en-US" uiCulture="en" fileEncoding="iso-8859-1" requestEncoding="iso-8859-1" responseEncoding="iso-8859-1"/>-->
<!-- page level options -->
<pages validateRequest="false" enableViewStateMac="true" />
<!-- membership config:
Attributes:
userIsOnlineTimeWindow="int" Time window (in minutes) to consider a User as being Online after since last activity
hashAlgorithmType="[SHA1|SHA512|MD5|...]" Any valid hash algorithm supported by .NET framework, default is SHA1
Child nodes:
<providers> Providers (class must inherit from MembershipProvider)
<add Add a provider
name="string" Name to identify this provider instance by
type="string" Class that implements MembershipProvider
provider-specific-configuration />
</providers>
Configuration for SqlMembershipProvider and AccessMembershipProvider:
connectionStringName="string" Name corresponding to the entry in <connectionStrings> section where the connection string for the provider is specified
passwordAttemptThreshold="int" The number of failed password attempts, or failed password answer attempts that are allowed before locking out a user?s account
passwordAttemptWindow="int" The time window, in minutes, during which failed password attempts and failed password answer attempts are tracked
enablePasswordRetrieval="[true|false]" Should the provider support password retrievals
enablePasswordReset="[true|false]" Should the provider support password resets
requiresQuestionAndAnswer="[true|false]" Should the provider require Q & A
applicationName="string" Optional string to identity the application: defaults to Application Metabase path
requiresUniqueEmail="[true|false]" Should the provider require a unique email to be specified
passwordFormat="[Clear|Hashed|Encrypted]" Storage format for the password: Hashed (SHA1), Clear or Encrypted (Triple-DES)
description="string" Description of what the provider does
-->
<membership userIsOnlineTimeWindow="15">
<providers>
<add name="DNNSQLMembershipProvider"
type="DotNetNuke.Security.Membership.DNNSQLMembershipProvider, DNNSQLMembershipProvider"
connectionStringName="SiteSqlServer"
enablePasswordRetrieval="true"
enablePasswordReset="true"
requiresQuestionAndAnswer="false"
requiresUniqueEmail="false"
passwordFormat="Encrypted"
applicationName="/"
description="Stores and retrieves membership data from the local Microsoft SQL Server database" />
</providers>
</membership>
<!-- Configuration for roleManager:
enabled="[true|false]" Feature is enabled?
cacheRolesInCookie="[true|false]" Cache roles in cookie?
cookieName=".ASPXROLES" Cookie Name
createPersistentCookie="[true|false]" Creates a persistent cookie or session cookie?
cookieTimeout="30" Cookie Timeout
cookiePath="/" Cookie Path
cookieRequireSSL="[true|false]" Set Secure bit in Cookie
cookieSlidingExpiration="[true|false]" Reissue expiring cookies?
cookieProtection="[None|Validation|Encryption|All]" How to protect cookies from being read/tampered
defaultProvider="string" Name of provider to use by default
domain="[domain]" Enables output of the "domain" cookie attribute set to the specified value
maxCachedResults="int" Maximum number of roles to cache in cookie
Child nodes:
<providers> Providers (class must inherit from RoleProvider)
<add Add a provider
name="string" Name to identify this provider instance by
type="string" Class that implements RoleProvider
provider-specific-configuration />
</providers>
<providers> type="TypeName" Class that inherits from System.Web.Security.RoleProvider
providerSpecificConfig Config for the provider
Configuration for SqlRoleProvider:
connectionStringName="string" Name corresponding to the entry in <connectionStrings> section where the connection string for the provider is specified
description="string" Description of what the provider does
commandTimeout="int" Command timeout value for SQL command
-->
<roleManager
cacheRolesInCookie="true"
cookieName=".ASPXROLES"
cookieTimeout="30"
cookiePath="/"
cookieRequireSSL="false"
cookieSlidingExpiration="true"
createPersistentCookie="false"
cookieProtection="All">
<providers>
<add name="DNNSQLRoleProvider"
type="DotNetNuke.Security.Role.DNNSQLRoleProvider, DNNSQLRoleProvider"
connectionStringName="SiteSqlServer"
applicationName="/"
description="Stores and retrieves roles data from the local Microsoft SQL Server database" />
</providers>
</roleManager>
<!--
Configuration for profile:
<profile>
enabled="[true|false]" Feature is enabled?
automaticSaveEnabled="[true|false]" Enable automatic save of profile
inherits="type-name" Class from which the profile type inherits from. This type must inherit from ProfileBase type.
<providers> Providers (class must inherit from ProfileProvider)
<add Add a provider (only single entry supported)
name="string" Name to identify this provider instance by
type="string" Class that implements ProfileProvider
provider-specific-configuration />
<providers>
<properties> Optional element. List of properties in the Profile system
<add Add a property
name="string" Name of the property
type="string" Optional. Type of the property. Default: string.
readOnly="[true|false]" Optional. Is Value read-only. Default: false.
defaultValue="string" Optional. Default Value. Default: Empty string.
allowAnonymous="[true|false]" Optional. Allow storing values for anonymous users. Default: false.
serializeAs=["String|Xml|Binary|ProviderSpecific"] Optional. How to serialize the type. Default: ProviderSpecific.
/>
</properties>
</profile>
-->
<profile enabled="true">
<providers>
<add name="AspNetSqlProvider"
type="DotNetNuke.Users.Profile.DNNSQLProfileProvider, DNNSQLProfileProvider"
connectionStringName="SiteSqlServer"
applicationName="/"
description="Stores and retrieves profile data from the local Microsoft SQL Server database" />
</providers>
<properties>
<add name="FirstName" type="string" allowAnonymous="true" />
<add name="LastName" type="string" allowAnonymous="true" />
<add name="Unit" type="string" allowAnonymous="true" />
<add name="Street" type="string" allowAnonymous="true" />
<add name="City" type="string" allowAnonymous="true" />
<add name="Region" type="string" allowAnonymous="true" />
<add name="PostalCode" type="string" allowAnonymous="true" />
<add name="Country" type="string" allowAnonymous="true" />
<add name="Telephone" type="string" allowAnonymous="true" />
<add name="Fax" type="string" allowAnonymous="true" />
<add name="Cell" type="string" allowAnonymous="true" />
<add name="Website" type="string" allowAnonymous="true" />
<add name="IM" type="string" allowAnonymous="true" />
<add name="TimeZone" type="integer" allowAnonymous="true" />
<add name="PreferredLocale" type="string" allowAnonymous="true"/>
</properties>
</profile>
<!--
anonymousIdentification configuration:
enabled="[true|false]" Feature is enabled?
cookieName=".ASPXANONYMOUS" Cookie Name
cookieTimeout="100000" Cookie Timeout in minutes
cookiePath="/" Cookie Path
cookieRequireSSL="[true|false]" Set Secure bit in Cookie
cookieSlidingExpiration="[true|false]" Reissue expiring cookies?
cookieProtection="[None|Validation|Encryption|All]" How to protect cookies from being read/tampered
domain="[domain]" Enables output of the "domain" cookie attribute set to the specified value
-->
<anonymousIdentification
enabled="true"
cookieName=".ASPXANONYMOUS"
cookieTimeout="100000"
cookiePath="/"
cookieRequireSSL="false"
cookieSlidingExpiration="true"
cookieProtection="None"
domain="" />
</system.web>
<dotnetnuke>
<htmlEditor defaultProvider="Ftb3HtmlEditorProvider">
<providers>
<clear />
<add name="Ftb3HtmlEditorProvider"
type="DotNetNuke.HtmlEditor.Ftb3HtmlEditorProvider, DotNetNuke.Ftb3HtmlEditorProvider"
providerPath="~\Providers\HtmlEditorProviders\Ftb3HtmlEditorProvider\" />
</providers>
</htmlEditor>
<searchIndex defaultProvider="ModuleIndexProvider">
<providers>
<clear />
<add name="ModuleIndexProvider"
type="DotNetNuke.Services.Search.ModuleIndexer, DotNetNuke.Search.Index"
providerPath="~\Providers\SearchProviders\ModuleIndexer\" />
</providers>
</searchIndex>
<searchDataStore defaultProvider="SearchDataStoreProvider">
<providers>
<clear />
<add name="SearchDataStoreProvider"
type="DotNetNuke.Services.Search.SearchDataStore, DotNetNuke.Search.DataStore"
providerPath="~\Providers\SearchProviders\SearchDataStore\" />
</providers>
</searchDataStore>
<data defaultProvider="SqlDataProvider">
<providers>
<clear />
<add name="SqlDataProvider"
type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider"
connectionStringName="SiteSqlServer"
upgradeConnectionString=""
providerPath="~\Providers\DataProviders\SqlDataProvider\"
objectQualifier=""
databaseOwner="dbo" />
</providers>
</data>
<logging defaultProvider="XMLLoggingProvider">
<providers>
<clear />
<add name="XMLLoggingProvider"
type="DotNetNuke.Services.Log.EventLog.XMLLoggingProvider, DotNetNuke.XMLLoggingProvider"
configfilename="LogConfig.xml.resources"
providerPath="~\Providers\LoggingProviders\XMLLoggingProvider\" />
</providers>
</logging>
<scheduling defaultProvider="DNNScheduler">
<providers>
<clear />
<add name="DNNScheduler"
type="DotNetNuke.Services.Scheduling.DNNScheduling.DNNScheduler, DotNetNuke.DNNScheduler"
providerPath="~\Providers\SchedulingProviders\DNNScheduler\"
debug="false"
maxThreads="-1"/>
</providers>
</scheduling>
<friendlyUrl defaultProvider="DNNFriendlyUrl">
<providers>
<clear />
<add name="DNNFriendlyUrl"
type="DotNetNuke.Services.Url.FriendlyUrl.DNNFriendlyUrlProvider, DotNetNuke.HttpModules.UrlRewrite" />
</providers>
</friendlyUrl>
</dotnetnuke>
<yafnet>
<connstr>user id=sa;password=test;data source=(local);initial catalog=yafnet;timeout=90</connstr>
<root>/DNN/DesktopModules/YetAnotherForumDotNet/</root>
<language>english.xml</language>
<theme>standard.xml</theme>
<uploaddir>/DNN/DesktopModules/YetAnotherForumDotNet/upload/</uploaddir>
<!--logtomail>email=;server=;user=;pass=;</logtomail-->
<boardid>1</boardid>
<!--categoryid>1</categoryid-->
</yafnet>
</configuration>