Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...ERROR: Could not connect to database specified in connectionStringERROR: Could not connect to database specified in connectionString
Previous
 
Next
New Post
3/28/2006 2:03 AM
 
Sean Killeen

Joined: 3/24/2006
Posts: 3

Alright, my setup:

  • location: http://localhost/DotNetNuke/
    WinXP Pro
  • IIS 5.1
  • ASP.NET v2.0
  • Database -- Remote SQL Server 2000 Database

I installed to C:\inetpub\wwwroot\DNN\ and created a virtual directory "DotNetNuke".

I moved SiteUrls.config to the right folder

I edited the connection string so that it was using the one for SQL 2000 and inserted a connection string for a database that I know to be good.

Still, I get this error:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 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: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 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: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 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: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 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: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 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: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 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: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 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() )

I have read both of the installation instructions but have not been able to come up with much as a result (really, there has to be a good technical writer out there who could contribute to the project in this way at some point...I hope)

I know that I am new to this, but I do have technical knowledge and would love to answer your questions (however simple they might seem) so that I might get this up and running. I would be happy to post web.config file & any other files (edited, of course) at your request. thanks!
 
New Post
3/28/2006 8:47 AM
 
Kevin Silverthorne

Joined: 3/24/2006
Posts: 4

Might want to post your connection string in the web.config.  Changing stuff that will identify your machine of course.

But I did notice that the error being given is stating

When connecting to SQL Server 2005

And you have stated that you are using 2000.  So I would guess something is up with the connection string.

silverthorne
 
New Post
3/28/2006 12:23 PM
 
Sean Killeen

Joined: 3/24/2006
Posts: 3

Right, that's what I was thinking, too, something along those lines. I'm going to try to paste all the parts of the web.config that matter (may be a little long, sorry all):

 <connectionStrings>
    <add
      name="SiteSqlServer"
      connectionString="Server=SNOW.HOSTMYSITE.NET;Database=interfall;user=*****;password=*****;"
      providerName="System.Data.SqlClient" />
  </connectionStrings>
  <appSettings>
    <add key="SiteSqlServer" value="Server=SNOW.HOSTMYSITE.NET;Database=interfall;user=*;password=*;"/>
 

it is important to note that previously, i was using uid and pwd instead of user and password, but when that didn't work i copied a connection string from one of my other projects that did.

the other thing that I changed was that I deleted the parts for SQL server 2005. I doubt that's an issue since i'm not using it.

Any ideas now? I'll paste whatever else you need, but that's all i changed.
 
New Post
3/29/2006 11:33 AM
 
Konrad Liber

Joined: 2/8/2006
Posts: 8
I have that problem to

SQL server 2005 express edition
Windows XP pro,SP2......

[URL=http://img138.imageshack.us/my.php?image=fdfsdfsdf6te.gif][IMG]http://img138.imageshack.us/img138/8260/fdfsdfsdf6te.th.gif[/IMG][/URL]

<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="navigationControl" 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" />
            <section name="caching" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" />
            <section name="authentication" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" />
        </sectionGroup>
        <sectionGroup name="memberrolesprototype">
            <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>
    </configSections>
    <!-- the old connectionString setting has been deprecated and replaced with the data provider section below -->
    <appSettings>
        <add key="SiteSqlServer" value="Server=NIMFOSAN-KXNM56;Database=dotnetnuke;uid=*********;pwd=******;" />
        <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" />
        <add key="InstallMemberRole" value="true"/><!--optionally install the MemberRole scripts -->
        <add key="ShowMissingKeys" value="false" /><!-- Show missing translation keys (for development use) -->
        <add key="EnableWebFarmSupport" value="false" /><!--Set to true to enable web farm suppot.  See Web Farm Support documentation for additional configuration steps.-->
        <add key="EnableCachePersistence" value="false" /><!--Some cached items can persist an app recycle by serializing the object to disk. Set to "true" to enable this performance enhancement.-->
    </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="Authentication" type="DotNetNuke.HttpModules.AuthenticationModule, DotNetNuke.HttpModules.Authentication" / -->
            <add name="UsersOnline" type="DotNetNuke.HttpModules.UsersOnlineModule, DotNetNuke.HttpModules.UsersOnline" />
            <add name="ProfilePrototype" type="Microsoft.ScalableHosting.Profile.ProfileModule, MemberRole, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b7c773fb104e7562" />
            <add name="AnonymousIdentificationPrototype" type="Microsoft.ScalableHosting.Security.AnonymousIdentificationModule, MemberRole, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b7c773fb104e7562" />
            <add name="RoleManagerPrototype" 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" originUrl="http://localhost/.*" />
        -->
        <!-- 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" />
        </authentication>
        <machineKey validationKey="AutoGenerate,IsolateApps"
            decryptionKey="AutoGenerate,IsolateApps" validation="3DES"/>
        <!--
            <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" />
    </system.web>
   
    <memberrolesprototype>
        <!-- membership config:
              Attributes:
                  userIsOnlineTimeWindow="int"                Time window (in minutes) to consider a User as being Online after since last activity
                  hashAlgorithm="[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
                   minRequiredPasswordLength="int"              The minimum password length
                   minRequiredNonalphanumericCharacters="int" The minimum number of non-alphanumeric characters
                   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"
                    minRequiredPasswordLength="4"
                    minRequiredNonalphanumericCharacters="0"
                    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="" />
    </memberrolesprototype>
   
    <dotnetnuke>
        <htmlEditor defaultProvider="Ftb3HtmlEditorProvider">
            <providers>
                <clear />
                <!--
                     FTB options:
                     ============
                     toolbarStyle="Office2003|OfficeXP|Office2000|OfficeMac"  Sets the default FTB Toolbar style
                     enableProFeatures="[true|false]"                         Pro features require a license from FreeTextBox
                                                                              or you may test them with localhost only
                     spellCheck="[{none}|IeSpellCheck|NetSpell]"              IeSpellCheck is free for non-commercial use only
                                                                              NetSpell requires some integration work
                -->
                <add name="Ftb3HtmlEditorProvider"
                    type="DotNetNuke.HtmlEditor.Ftb3HtmlEditorProvider, DotNetNuke.Ftb3HtmlEditorProvider"
                    providerPath="~\Providers\HtmlEditorProviders\Ftb3HtmlEditorProvider\"
                    toolbarStyle="Office2003"
                    enableProFeatures="false"
                    spellCheck="" />
            </providers>
        </htmlEditor>
        <navigationControl defaultProvider="SolpartMenuNavigationProvider">
              <providers>
                <clear />
                <add name="SolpartMenuNavigationProvider"
                    type="DotNetNuke.NavigationControl.SolpartMenuNavigationProvider, DotNetNuke.SolpartMenuNavigationProvider"
                    providerPath="~\Providers\NavigationProviders\SolpartMenuNavigationProvider\" />
                <add name="DNNMenuNavigationProvider"
                    type="DotNetNuke.NavigationControl.DNNMenuNavigationProvider, DotNetNuke.DNNMenuNavigationProvider"
                    providerPath="~\Providers\NavigationProviders\DNNMenuNavigationProvider\" />
                <add name="DNNTreeNavigationProvider"
                    type="DotNetNuke.NavigationControl.DNNTreeNavigationProvider, DotNetNuke.DNNTreeNavigationProvider"
                    providerPath="~\Providers\NavigationProviders\DNNTreeNavigationProvider\" />
                <add name="DNNDropDownNavigationProvider"
                    type="DotNetNuke.NavigationControl.DNNDropDownNavigationProvider, DotNetNuke.DNNDropDownNavigationProvider"
                    providerPath="~\Providers\NavigationProviders\DNNDropDownNavigationProvider\" />
              </providers>
        </navigationControl>
        <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="DBLoggingProvider">
            <providers>
                <clear />
                <add name="XMLLoggingProvider"
                    type="DotNetNuke.Services.Log.EventLog.XMLLoggingProvider, DotNetNuke.XMLLoggingProvider"
                    configfilename="LogConfig.xml.resources"
                    providerPath="~\Providers\LoggingProviders\XMLLoggingProvider\" />
                <add name="DBLoggingProvider"
                    type="DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider, DotNetNuke.Provider.DBLoggingProvider"
                    providerPath="~\Providers\LoggingProviders\Provider.DBLoggingProvider\" />
            </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"
                    includePageName="true"
                    regexMatch="[^a-zA-Z0-9 _-]" />
            </providers>
        </friendlyUrl>
        <caching defaultProvider="BroadcastPollingCachingProvider">
            <providers>
                <clear />
                <add name="FileBasedCachingProvider"
                    type="DotNetNuke.Services.Cache.FileBasedCachingProvider.FBCachingProvider, DotNetNuke.Caching.FileBasedCachingProvider"
                    providerPath="~\Providers\CachingProviders\FileBasedCachingProvider\" />
                <add name="BroadcastPollingCachingProvider"
                    type="DotNetNuke.Services.Cache.BroadcastPollingCachingProvider.BPCachingProvider, DotNetNuke.Caching.BroadcastPollingCachingProvider"
                    providerPath="~\Providers\CachingProviders\BroadcastPollingCachingProvider\" />
            </providers>
        </caching>
        <authentication defaultProvider="ADSIAuthenticationProvider">
            <providers>
                <clear />
                <add name="ADSIAuthenticationProvider"
                    type="DotNetNuke.Security.Authentication.ADSIProvider, DotNetNuke.Authentication.ADSIProvider"
                    providerPath="~\Providers\AuthenticationProviders\ADSIProvider\" />
            </providers>
        </authentication>
    </dotnetnuke>
</configuration>


please help
 
New Post
4/24/2006 3:46 PM
 
James Bayne

www.bd.com
Joined: 4/24/2006
Posts: 3
Any solution for this?  I too am getting the same thing running Windows 2000 Server, SQL 2000 and .Net 2.0
 
 Page 1 of 3
123Next 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...ERROR: Could not connect to database specified in connectionStringERROR: Could not connect to database specified in connectionString


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, 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 DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out