By default DotNetNuke ships with a sql data provider, which supports installation on sql server and sql server express products. This is defined in the web.config as follow:
<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>
Whilst most of this definition will not be changed, on occasion the
upgradeConnectionString,
objectQualifier or
databaseOwner attributes are altered by some sites.