Is the IIS app pool running under .NET 4? Are you using the .NET 4 version of web.config?

Take a look at this thread. There is a workaround near the end that should work. Really shouldn't be necessary, though...

Also listed below is the config.

I copied the config sections out of the post you referred me to under the configuration section. Should I be doing something else ? I really need to get Gallery up and running and not able to do so. When I use the web installer I expereince issues as well connecting to the database.

<?xml version="1.0"?>
<configuration>
<configSections>
<sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
<sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
<section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
<sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
<section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="Everywhere"/>
<section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
<section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
<section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
</sectionGroup>
</sectionGroup>
</sectionGroup>

<sectionGroup name="system.web">
<section name="galleryServerPro" type="GalleryServerPro.Configuration.GalleryServerProConfigSettings, GalleryServerPro.Configuration" allowDefinition="MachineToApplication" restartOnExternalChanges="true" requirePermission="false"/>
</sectionGroup>
<section name="cachingConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Caching.Configuration.CacheManagerSettings, Microsoft.Practices.EnterpriseLibrary.Caching" requirePermission="false"/>
</configSections>

<connectionStrings>
<clear/>
<add name="SQLiteDbConnection" connectionString="Data Source=|DataDirectory|galleryserverpro_data.sqlite;Version=3;"/>
<add name="SqlServerDbConnection" connectionString="Data Source=(local);Initial Catalog=GalleryServerPro;Integrated Security=true;Application Name=Gallery Server Pro"/>
</connectionStrings>

<appSettings>
<add key="ComponentArtScriptControls" value="PerControl"/>
</appSettings>

<cachingConfiguration defaultCacheManager="Cache Manager">
<cacheManagers>
<add expirationPollFrequencyInSeconds="60" maximumElementsInCacheBeforeScavenging="1000" numberToRemoveWhenScavenging="10" backingStoreName="Null Storage" name="Cache Manager"/>
</cacheManagers>
<backingStores>
<add encryptionProviderName="" type="Microsoft.Practices.EnterpriseLibrary.Caching.BackingStoreImplementations.NullBackingStore, Microsoft.Practices.EnterpriseLibrary.Caching" name="Null Storage"/>
</backingStores>
</cachingConfiguration>

<system.web>

<pages theme="" styleSheetTheme="" validateRequest="false" controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID">
</pages>

<galleryServerPro configSource="gs\config\galleryserverpro.config"/>

<!-- <trust level="Full" /> -->

<globalization uiCulture="auto:en" culture="auto:en-US"/>

<xhtmlConformance mode="Strict"/>

<compilation debug="false" targetFramework="4.0">
<assemblies>
<add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/></assemblies>
</compilation>

<!-- The <authentication> section enables configuration of the security authentication mode used by
ASP.NET to identify an incoming user.
The timeout is set to 129,600 minutes by default, which is 90 days. This allows the user to be automatically
logged in (requires selecting the "Remember Me" checkbox during login which sets a persistent cookie).
Note that when the user clicks "Log out", the persistent cookie is removed and the user will have to
log in next time. -->
<authentication mode="Forms">
<forms protection="All" timeout="129600" slidingExpiration="true"/>
</authentication>

<authorization>
<!-- <deny users="?" />-->
</authorization>

<!-- Configure the Membership provider.-->
<membership defaultProvider="SqlMembershipProvider">
<providers>
<clear/>
<add applicationName="Gallery Server Pro" passwordFormat="Clear" minRequiredNonalphanumericCharacters="0" minRequiredPasswordLength="2" maxInvalidPasswordAttempts="50" enablePasswordReset="true" enablePasswordRetrieval="true" passwordAttemptWindow="10" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" connectionStringName="SqlServerDbConnection" name="SqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider"/>
</providers>
</membership>

<!-- Configure the Role provider.-->
<roleManager enabled="true" cacheRolesInCookie="true" cookieProtection="Validation" defaultProvider="SqlRoleProvider">
<providers>
<clear/>
<add applicationName="Gallery Server Pro" connectionStringName="SqlServerDbConnection" name="SqlRoleProvider" type="System.Web.Security.SqlRoleProvider"/>
</providers>
</roleManager>

<!-- Configure the Profile provider.-->
<profile defaultProvider="SqlProfileProvider">
<providers>
<clear/>
<add applicationName="Gallery Server Pro" connectionStringName="SqlServerDbConnection" name="SqlProfileProvider" type="System.Web.Profile.SqlProfileProvider"/>
</providers>
<properties>
<add name="ShowMediaObjectMetadata" defaultValue="false" type="String" allowAnonymous="false"/>
<add name="UserAlbumId" defaultValue="0" type="Int32" allowAnonymous="false"/>
<add name="EnableUserAlbum" defaultValue="true" type="String" allowAnonymous="false"/>
</properties>
</profile>

<httpHandlers>
<add verb="*" path="ComponentArtUploadProgress.axd" type="ComponentArt.Web.UI.UploadProgressHandler, ComponentArt.Web.UI"/>
<add verb="*" path="ComponentArtScript.axd" type="ComponentArt.Web.UI.ScriptHandler,ComponentArt.Web.UI"/>
</httpHandlers>

<httpModules>
<add name="ComponentArtUploadModule" type="ComponentArt.Web.UI.UploadModule, ComponentArt.Web.UI"/>
</httpModules>

<sessionState mode="InProc" timeout="60"/>

<!-- The <customErrors> section controls what happens if/when an unhandled error occurs. This setting is
ignored if enableExceptionHandler=true in galleryserverpro.config.
The mode attribute must be one of these values: Off (No redirection is performed; all users get detailed
error message), On (all users are redirected to friendly error page), RemoteOnly (local users see detailed
error message, remote users are redirected) -->
<customErrors mode="RemoteOnly"/>

</system.web>
<!--
The site admin page lets you specify the smtp server and port, and the entries are stored in galleryserverpro.config.
If you need to specify a username and password, you can do so here. When this section is configured, the smtp
server and port in galleryserverpro.config are ignored, so make sure to include the server and port here. Uncomment
the section below to make it take effect. -->
<!--
<system.net>
<mailSettings>
<smtp>
<network
host="relayServerHostname"
port="portNumber"
userName="username"
password="password" />
</smtp>
</mailSettings>
</system.net>
-->

<!-- By default ASP.NET prevents file uploads larger than 4 MB. To change this, increase the maxRequestLength
attribute for all pages that host the Gallery Server Pro user control. Ex: To allow files up to 2 GB, use
maxRequestLength="2097151". This value should be the same or higher than the maxUploadSize setting in
galleryserverpro.config (which is exposed on the Site admin - Media objects - General page). The maxUploadSize
setting is the preferred way to manage upload sizes, as GSP provides a friendly message when that value is
violated, which is not possible when maxRequestLength is violated.

It is also recommended to increase the timeout from the default value
of 90 seconds to allow for long-running tasks such as file uploads. Set the
executionTimeout attribute to the desired value (8 hours = 28800, 24 hrs = 86400). -->
<location path="default.aspx">
<system.web>
<httpRuntime maxRequestLength="2097151" executionTimeout="86400"/>
</system.web>
</location>

<system.web.extensions>
<scripting>
<webServices>
<jsonSerialization maxJsonLength="2147483647"/>
</webServices>
<scriptResourceHandler enableCompression="true" enableCaching="true"/>
</scripting>
</system.web.extensions>

<system.webServer>
<!-- By default IIS 7 restricts uploads larger than about 30 MB. To allow larger uploads, use the <requestFiltering>
element to set a new value. The attribute maxAllowedContentLength is in bytes, so to set a new value of 2 GB,
use 2147483648 (2 * 1024 * 1024 * 1024).
Note: If you get an error that requestFiltering cannot be overriden you must edit
%windir%\System32\inetsrv\config\applicationHost.config file and change the string:
<section name="requestFiltering" overrideModeDefault="Deny" />
to:
<section name="requestFiltering" overrideModeDefault="Allow" />

<security>
<requestFiltering>
<requestLimits maxAllowedContentLength="2147483648"/>
</requestFiltering>
</security>
-->

<validation validateIntegratedModeConfiguration="false"/>

<modules>
<remove name="ComponentArtUploadModule"/>
<add name="ComponentArtUploadModule" type="ComponentArt.Web.UI.UploadModule, ComponentArt.Web.UI"/>
</modules>

<handlers>
<remove name="ComponentArtUpload"/>
<remove name="ComponentArtScriptHandler"/>
<add name="ComponentArtUpload" path="ComponentArtUploadProgress.axd" type="ComponentArt.Web.UI.UploadProgressHandler, ComponentArt.Web.UI" verb="*"/>
<add name="ComponentArtScriptHandler" path="ComponentArtScript.axd" type="ComponentArt.Web.UI.ScriptHandler,ComponentArt.Web.UI" verb="*"/>
</handlers>

<defaultDocument>
<files>
<remove value="default.aspx"/>
<add value="default.aspx"/>
</files>
</defaultDocument>

</system.webServer>

</configuration>

so listed below is the error I get when I use the web installer.......

Does that make sense ?

[15:9:826]Performing synchronization pass #1.
[15:9:830]Parameter entry 'Application Path/1' is applicable to 'iisApp/gsp' because of its scope.
Details:
name: Application Path
[15:9:830]Parameter entry 'SetAcl1/1' is applicable to 'setAcl/gsp/App_Data' because of its scope.
Details:
name: SetAcl1
[15:9:830]Parameter entry 'SetAcl2/1' is applicable to 'setAcl/gsp/gs/config' because of its scope.
Details:
name: SetAcl2
[15:9:831]Parameter entry 'SetAcl3/1' is applicable to 'setAcl/gsp/gs/mediaobjects' because of its scope.
Details:
name: SetAcl3
[15:9:831]Parameter entry 'SetAcl4/1' is applicable to 'setAcl/gsp/App_Data/install_temp' because of its scope.
Details:
name: SetAcl4
[15:9:832]Parameter entry 'Connection String/1' is applicable to 'dbFullSql/install.sql' because of its scope.
Details:
name: Connection String
[15:9:832]Parameter entry 'Connection String/2' is applicable to 'dbFullSql/InstallCommon.sql' because of its scope.
Details:
name: Connection String
[15:9:833]Parameter entry 'Connection String/3' is applicable to 'dbFullSql/InstallMembership.sql' because of its scope.
Details:
name: Connection String
[15:9:834]Parameter entry 'Connection String/4' is applicable to 'dbFullSql/InstallProfile.sql' because of its scope.
Details:
name: Connection String
[15:9:834]Parameter entry 'Connection String/5' is applicable to 'dbFullSql/InstallRoles.sql' because of its scope.
Details:
name: Connection String
[15:9:835]Parameter entry 'Connection String/6' is applicable to 'dbFullSql/InstallGalleryServerPro.sql' because of its scope.
Details:
name: Connection String
[15:9:848]Adding MSDeploy.iisApp (MSDeploy.iisApp).
Details:
operationType: Add
providerName: MSDeploy.iisApp
path: MSDeploy.iisApp
[15:9:894]Source createApp (gsp) does not match destination (Default Web Site/gallery) differing in attributes (isDest,managedRuntimeVersion['',''],enable32BitAppOnWin64['',''],managedPipelineMode['',''],applicationPool,appExists). Update pending.
[15:9:894]Update operation on createApp (gsp) skipped because of rule CreateApplicationRule.
Details:
rule: CreateApplicationRule
operationType: Update
[15:9:913]Parameter entry 'GSP Administrator Name/1' is applicable to 'gsp\App_Data\install_temp' because of its scope.
Details:
name: GSP Administrator Name
[15:9:946]Parameter entry 'GSP Administrator Password/1' is applicable to 'gsp\App_Data\install_temp' because of its scope.
Details:
name: GSP Administrator Password
[15:9:946]Attribute 'size' equality changed to True when comparing filePath (Default Web Site/gallery\App_Data\install_temp) to gsp\App_Data\install_temp because of rule Parameterization.
Details:
rule: Parameterization
attribute: size
newEquals: True
[15:9:973]Deleting dirPath (Default Web Site/gallery\gs\mediaobjects).
Details:
operationType: Delete
providerName: dirPath
path: Default Web Site/gallery\gs\mediaobjects
[15:9:988]Parameter entry 'App Connection String/1' is applicable to 'gsp\gs\services\web.config' because of its scope.
Details:
name: App Connection String
[15:9:988]Parameter entry 'App Connection String/1' could not be applied to 'gsp\gs\services\web.config'. Deployment will continue with the original data. Details:
No matches were found for the search string '/configuration/connectionStrings/add[@name='SqlServerDbConnection']/@connectionString' (type 'XmlFile').
Details:
name: App Connection String
[15:9:988]Attribute 'size' equality changed to True when comparing filePath (Default Web Site/gallery\gs\services\web.config) to gsp\gs\services\web.config because of rule Parameterization.
Details:
rule: Parameterization
attribute: size
newEquals: True
[15:9:10]Parameter entry 'App Connection String/1' is applicable to 'gsp\web.config' because of its scope.
Details:
name: App Connection String
[15:9:10]Attribute 'size' equality changed to True when comparing filePath (Default Web Site/gallery\web.config) to gsp\web.config because of rule Parameterization.
Details:
rule: Parameterization
attribute: size
newEquals: True
[15:9:13]Source setAcl (gsp/App_Data) does not match destination (Default Web Site/gallery/App_Data) differing in attributes (isDest,setAclUser,setAclAccess). Update pending.
[15:9:13]Updating setAcl (Default Web Site/gallery/App_Data).
Details:
operationType: Update
providerName: setAcl
path: Default Web Site/gallery/App_Data
[15:9:16]Source setAcl (gsp/gs/config) does not match destination (Default Web Site/gallery/gs/config) differing in attributes (isDest,setAclUser,setAclAccess). Update pending.
[15:9:16]Updating setAcl (Default Web Site/gallery/gs/config).
Details:
operationType: Update
providerName: setAcl
path: Default Web Site/gallery/gs/config
[15:9:55]Source setAcl (gsp/gs/mediaobjects) does not match destination (Default Web Site/gallery/gs/mediaobjects) differing in attributes (isDest,setAclUser,setAclAccess). Update pending.
[15:9:55]Updating setAcl (Default Web Site/gallery/gs/mediaobjects).
Details:
operationType: Update
providerName: setAcl
path: Default Web Site/gallery/gs/mediaobjects
[15:9:58]Source setAcl (gsp/App_Data/install_temp) does not match destination (Default Web Site/gallery/App_Data/install_temp) differing in attributes (isDest,setAclUser,setAclAccess). Update pending.
[15:9:58]Updating setAcl (Default Web Site/gallery/App_Data/install_temp).
Details:
operationType: Update
providerName: setAcl
path: Default Web Site/gallery/App_Data/install_temp
[15:9:62]Source dbFullSql (install.sql) does not match destination (data source=(local);initial catalog=GalleryServerPro;user id=sa;pooling=False) differing in attributes (databaseName). Update pending.
[15:9:62]Adding dbFullSql (data source=(local);initial catalog=GalleryServerPro;user id=sa;pooling=False).
Details:
operationType: Add
providerName: dbFullSql
path: data source=(local);initial catalog=GalleryServerPro;user id=sa;pooling=False
[15:9:66]The database 'GalleryServerPro' could not be created.
Retrying operation 'Add' on object dbFullSql (data source=(local);initial catalog=GalleryServerPro;user id=sa;pooling=False). Attempt 1 of 5.
Details:
originalMessage: The database 'GalleryServerPro' could not be created.
operationType: Add
retryAttempt: 1
retryCount: 5
[15:9:74]The database 'GalleryServerPro' could not be created.
Retrying operation 'Add' on object dbFullSql (data source=(local);initial catalog=GalleryServerPro;user id=sa;pooling=False). Attempt 2 of 5.
Details:
originalMessage: The database 'GalleryServerPro' could not be created.
operationType: Add
retryAttempt: 2
retryCount: 5
[15:9:81]The database 'GalleryServerPro' could not be created.
Retrying operation 'Add' on object dbFullSql (data source=(local);initial catalog=GalleryServerPro;user id=sa;pooling=False). Attempt 3 of 5.
Details:
originalMessage: The database 'GalleryServerPro' could not be created.
operationType: Add
retryAttempt: 3
retryCount: 5
[15:9:87]The database 'GalleryServerPro' could not be created.
Retrying operation 'Add' on object dbFullSql (data source=(local);initial catalog=GalleryServerPro;user id=sa;pooling=False). Attempt 4 of 5.
Details:
originalMessage: The database 'GalleryServerPro' could not be created.
operationType: Add
retryAttempt: 4
retryCount: 5
[15:9:95]The database 'GalleryServerPro' could not be created.
Retrying operation 'Add' on object dbFullSql (data source=(local);initial catalog=GalleryServerPro;user id=sa;pooling=False). Attempt 5 of 5.
Details:
originalMessage: The database 'GalleryServerPro' could not be created.
operationType: Add
retryAttempt: 5
retryCount: 5
EXCEPTION: Microsoft.Web.Deployment.DeploymentClientServerException: The database 'GalleryServerPro' could not be created. ---> System.Data.SqlClient.SqlException: Login failed for user 'sa'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
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.Web.Deployment.SqlDatabaseProvider.AddHelper(DeploymentObject source)
--- End of inner exception stack trace ---
at Microsoft.Web.Deployment.DeploymentObject.Add(DeploymentObject source, DeploymentSyncContext syncContext)
at Microsoft.Web.Deployment.DeploymentSyncContext.HandleAdd(DeploymentObject destObject, DeploymentObject sourceObject)
at Microsoft.Web.Deployment.DeploymentSyncContext.HandleUpdate(DeploymentObject destObject, DeploymentObject sourceObject)
at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentObject dest, DeploymentObject source)
at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildren(DeploymentObject dest, DeploymentObject source)
at Microsoft.Web.Deployment.DeploymentSyncContext.ProcessSync(DeploymentObject destinationObject, DeploymentObject sourceObject)
at Microsoft.Web.Deployment.DeploymentObject.SyncToInternal(DeploymentObject destObject, DeploymentSyncOptions syncOptions, PayloadTable payloadTable, ContentRootTable contentRootTable)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentProviderOptions providerOptions, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(String provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentWellKnownProvider provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.PlatformInstaller.MSDeployProxy.Install(InstallerContext context, RemoteCredentials remoteCredentials)