Hello there,

I am using XP with IIS 5.0 and SQL 2005 (not express).

It should be pretty basic but doesn't appear to be.  I changed the line below.  Is there anything more?

<add key="SiteSqlServer" value="Server=COMPUTERNAME;Database=DotNetNuke;uid=MYCOMPITER/USER;pwd=MYPASSWORD;" />

How can I check to ensure the connection works, SQL 2000 had Query Analyzer.  TCP is open.

Thanks, Dennis

<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" />

<section name="members" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" />

<section name="roles" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" />

<section name="profiles" 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=COMPUTERNAME;Database=DotNetNuke;uid=MYCOMPITER/USER;pwd=MYPASSWORD;" />

<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="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.-->

<add key="HostHeader" value="" /><!-- Host Header to remove from URL so "www.mydomain.com/johndoe/Default.aspx" is treated as "www.mydomain.com/Default.aspx" -->

<add key="RemoveAngleBrackets" value="false" /><!--optionally strip angle brackets on public login and registration screens-->

</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>

<httpHandlers>

<!-- This is for FTB 3.0 support -->

<add verb="GET" path="FtbWebResource.axd" type="FreeTextBoxControls.AssemblyResourceHandler, FreeTextBox" />

<!-- This is for CAPTCHA support -->

<add verb="*" path="*.captcha.aspx" type="DotNetNuke.UI.WebControls.CaptchaHandler, DotNetNuke" />

<!-- This is for Serving files, secure, insecure, from database -->

<add verb="*" path="LinkClick.aspx" type="DotNetNuke.Services.FileSystem.FileServerHandler, DotNetNuke"/>

</httpHandlers>

<!-- set code access security trust level - this is generally set in the machine.config

-->

<!-- 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"/>

-->

<!-- allow large file uploads -->

<httpRuntime useFullyQualifiedRedirectUrl="true" maxRequestLength="8192"/>

<!-- GLOBALIZATION

-->

<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:

-->

<membership userIsOnlineTimeWindow="15" >

<providers>

<add name="AspNetSqlMembershipProvider"

type="Microsoft.ScalableHosting.Security.SqlMembershipProvider, MemberRole"

connectionStringName="SiteSqlServer"

enablePasswordRetrieval="true"

enablePasswordReset="true"

requiresQuestionAndAnswer="false"

minRequiredPasswordLength="7"

minRequiredNonalphanumericCharacters="0"

requiresUniqueEmail="false"

passwordFormat="Encrypted"

applicationName="DotNetNuke"

description="Stores and retrieves membership data from the local Microsoft SQL Server database" />

</providers>

</membership>

-->

<anonymousIdentification

enabled="true"

cookieName=".ASPXANONYMOUS"

cookieTimeout="100000"

cookiePath="/"

cookieRequireSSL="false"

cookieSlidingExpiration="true"

cookieProtection="None"

domain="" />

</memberrolesprototype>

<dotnetnuke>

<htmlEditor defaultProvider="Ftb3HtmlEditorProvider">

<providers>

<clear />

<!--

-->

<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>

<members defaultProvider="AspNetMembershipProvider">

<providers>

<clear/>

<add name="AspNetMembershipProvider" type="DotNetNuke.Security.Membership.AspNetMembershipProvider, DotNetNuke.Provider.AspNetProvider" providerPath="~\Providers\MembershipProviders\AspNetMembershipProvider\"/>

</providers>

</members>

<roles defaultProvider="DNNRoleProvider">

<providers>

<clear/>

<add name="DNNRoleProvider" type="DotNetNuke.Security.Membership.DNNRoleProvider, DotNetNuke.Provider.DNNProvider" providerPath="~\Providers\MembershipProviders\DNNMembershipProvider\"/>

</providers>

</roles>

<profiles defaultProvider="DNNProfileProvider">

<providers>

<clear/>

<add name="DNNProfileProvider" type="DotNetNuke.Security.Profile.DNNProfileProvider, DotNetNuke.Provider.DNNProvider" providerPath="~\Providers\MembershipProviders\DNNMembershipProvider\"/>

</providers>

</profiles>

</dotnetnuke>

</configuration>