Dear all,

I am trying to install 4.3.4 on a WinXp x64 with SQL 2005.
Here is the info about the system.

Microsoft SQL Server Management Studio     9.00.1399.00
Microsoft Analysis Services Client Tools        2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML                                        2.6 3.0 5.0 6.0
Microsoft Internet Explorer                         6.0.3790.1830
Microsoft .NET Framework                          2.0.50727.42
Operating System                                     5.2.3790

These are the steps I follow :

1. Copy fresh install files of 4.3.4 on a directory
2. Make this dir virtual from IIS
3. Give full access to the virtual dir for the NETWORK SERVICE user
   
4. Give full access to the dir %WINDOWSDIR%\TEMP for the NETWORK SERVICE user
   
5. Give full access to %WINDOWSDIR%\Microsoft.NET\Framework\v.xxxx and %WINDOWSDIR%\Microsoft.NET\Frameworkx64\v.xxxx for the NETWORK SERVICE user (this was taken from here http://dnnblog.venexus.com/SyndicationService.asmx/GetRssCategory?categoryName=DotNetNuke%20Errors)
   
6. Create empty database to SQL
   
7. Create the user and apoint him as a db_owner
8. Copy the release.config as web.config
9. Edit the web.config to match for SiteSQLServer keys on configuration and application settings the users' username, password, including commenting out the SQL express keys

And this is what it comes up:

Installation Status Report

00:00:00.218 - Installing Version: 3.1.0
00:00:00.281 - Installing Script: DotNetNuke.SetUp.SqlDataProvider
00:00:00.328 - Installing Script: DotNetNuke.Schema.SqlDataProvider
00:00:01.375 - Installing Script: DotNetNuke.Data.SqlDataProvider
00:00:02.328 - Installing MemberRole Provider:
00:00:02.328 - Executing InstallCommon.sql
00:00:02.859 - Executing InstallMembership.sql
00:00:03.187 - Executing InstallProfile.sql
00:00:03.343 - Executing InstallRoles.sql
00:00:04.015 - Upgrading to Version: 3.1.1
00:00:05.234 - Upgrading to Version: 3.2.0
00:00:05.296 - Upgrading to Version: 3.2.1
00:00:05.328 - Upgrading to Version: 3.2.2
00:00:05.343 - Upgrading to Version: 3.2.3
00:00:06.390 - Upgrading to Version: 3.2.4
00:00:06.437 - Upgrading to Version: 3.2.5
00:00:06.453 - Upgrading to Version: 3.2.6
00:00:06.484 - Upgrading to Version: 3.2.7
00:00:06.484 - Upgrading to Version: 3.3.0
00:00:06.531 - Upgrading to Version: 3.3.1
00:00:06.562 - Upgrading to Version: 3.3.2
00:00:06.609 - Upgrading to Version: 3.3.3
00:00:06.703 - Upgrading to Version: 4.0.0
00:00:06.828 - Upgrading to Version: 4.0.1
00:00:06.859 - Upgrading to Version: 4.0.2
00:00:06.875 - Upgrading to Version: 4.0.3
00:00:06.875 - Upgrading to Version: 4.0.4
00:00:07.375 - Upgrading to Version: 4.0.5
00:00:07.375 - Upgrading to Version: 4.0.6
00:00:07.375 - Upgrading to Version: 4.0.7
00:00:07.375 - Upgrading to Version: 4.3.0
00:00:07.390 - Upgrading to Version: 4.3.1
00:00:07.406 - Upgrading to Version: 4.3.2
00:00:07.437 - Upgrading to Version: 4.3.3
00:00:07.500 - Upgrading to Version: 4.3.4
00:00:07.500 - Performing General Upgrades
00:00:09.281 - Loading Host Settings:
00:00:09.437 - Configuring SuperUser:

 

---

Server Error in '/ODUS2' Application.

---

The stored procedure 'dbo.GetPropertyDefinitionsByPortal' doesn't exist.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The stored procedure 'dbo.GetPropertyDefinitionsByPortal' doesn't exist.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL: 1. Add a "Debug=true" directive at the top of the file that generated the error. Example:   <%@ Page Language="C#" Debug="true" %> or: 2) Add the following section to the configuration file of your application: <configuration>    <system.web>        <compilation debug="true"/>    </system.web> </configuration> Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode. Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:

[InvalidOperationException: The stored procedure 'dbo.GetPropertyDefinitionsByPortal' doesn't exist.] System.Data.SqlClient.SqlCommand.DeriveParameters() +3042 System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +232 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +382 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +621 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +198 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) +63 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +273 DotNetNuke.Data.SqlDataProvider.GetPropertyDefinitionsByPortal(Int32 portalId) +156 DotNetNuke.Entities.Profile.ProfileController.GetPropertyDefinitionsByPortal(Int32 portalId) +28 DotNetNuke.Security.Profile.DNNProfileProvider.GetProfileProperties(Int32 portalId, IDataReader dr, UserProfile objProfile) +43 DotNetNuke.Security.Profile.DNNProfileProvider.GetUserProfile(UserInfo& user) +133 DotNetNuke.Entities.Users.UserInfo.get_Profile() +65 DotNetNuke.Services.Upgrade.Upgrade.ParseSuperUser(XmlNode node) +586 DotNetNuke.Services.Upgrade.Upgrade.InstallDNN(String strProviderPath) +1720 DotNetNuke.Framework.Install.InstallApplication() +1350 DotNetNuke.Framework.Install.Page_Load(Object sender, EventArgs e) +319 System.Web.UI.Control.OnLoad(EventArgs e) +127 System.Web.UI.Control.LoadRecursive() +101 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2588

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

I have made the exact same installation on WinXP SP2 x32 with SQL Server 2005 again and it worked like a charm from the first time.
But on this configuration I can't have it working.

Any ideas.

I did a lot of research before posting here, as the last resort, just in case some of the guys from the core team sees it and has an idea what is going on here.

Thank you and sorry for the long post.

David Oster aka George Pasparakis