Hello All,
I'm clutching my hair in frustration trying to get this to work for the last three days. I'm trying to perform a vanilla install of DNN 4.5.4 using Visual Web Developer on an XP Pro/IIS 5.1 box with SQL Express 2005. All softwares are with a default install except my SQLExpress instance is called SQLExpressOne and I'm running in integrated windows authentication as an admin. I just cannot seem to get past the installation of DB scripts. Here is what happens -
1.) I create a virtual directory called "dotnetnuketry" on my IIS and grant full control permissions to both ASPNET and Network Service Users.
2.) I use VWD 2005 to open a new dotnetnuke framework project type using this local IIS directory "dotnetnuketry" and everything happens successfully. Change the web.config and all other config files to change the connection string to match my SQLExpressOne instance.
3.) I run the project without debug and get a warning about some blog install resources not found. I click okay and build proceeds and the DNN installwizard pops up
4.) File permissions etc everything checks out good, I select typical or custom install (tried both and they fail) and set the object qualifier to "dnntry" and continue
5.) 4.4.0 database scripts install and are a success, next button clicked
6.) 4.4.0 database scripts install and upgrade scripts to 4.4.1, 4.4.2 etc install successfully, next button enables and clicked
7.) Get the following error - "Installing Database - Version 4.4.0...Upgrading Database to Version ERROR: See D:\dotnetnuketry\Providers\DataProviders\SqlDataProvider\04.04.00.log for more information...FAILURE 400 - Conversion from string "ERROR: See D:dotnetnuketryProvid" to type 'Integer' is not valid." At this point the install hangs.
No file called "04.04.00.log" is found. In this directory, the last modified files seem to be "Dotnetnuke.Data.log" (383 KB) and "Dotnetnuke.schema.log"(745 KB) files which contain a host of statements indicating exceptions like "System.Data.SqlClient.SqlException: Table 'dnntry_RoleGroups' already has a primary key defined on it.
Could not create constraint. See previous errors." and so forth. Is this a normal sequence? Why is the install wizard trying to install the scripts and upgrade the scripts so many times?
I always clean out the database before starting a new install and have always varied the install directory name and the object qualifiers. My SQL Server collation properties are set to default values and are correct for my locale.
I'm at a complete loss right now and on the verge of giving up. Any and all opinions, thoughts, pointers are welcome since I have no clue how to proceed from here except to try a manual install or uninstall and reinstall my SQL Express 2005
Thanks for your opinions
Regards
Raj