Installation error, invalid object name tblPageType

Vote:
 

I'm trying to install Episerver R2 on my workstation, but I get the following errormessage during the installation process :

Error - Invalid object name 'tblPageType'.

--

An unhandled error has occured:
Invalid object name 'tblPageType'.
When executing
At C:\Program Files\EPiServer\CMS\5.2.375.236\Install\System Scripts\Install Da
tabase (SqlServer).ps1:149 char:30
+ Set-EPiBuiltInPageTypePaths <<<<  -SqlServerName $wizard.Database.DatabaseS
erverName -SqlServerPort $wizard.Database.DatabaseServerPort -DatabaseName $wiz
ard.Database.DatabaseName -LoginName $wizard.Database.InstallerDatabaseLoginNam
e -LoginPassword $wizard.Database.InstallerDatabaseLoginPassword -UiPath "~$uiP
ath" -AvoidDbTransaction
An unhandled error has occured:Invalid object name 'tblPageType'.When executing
At C:\Program Files\EPiServer\CMS\5.2.375.236\Install\System Scripts\Install Database (SqlServer).ps1:149 char:30+ Set-EPiBuiltInPageTypePaths <<<<  -SqlServerName $wizard.Database.DatabaseServerName -SqlServerPort $wizard.Database.DatabaseServerPort -DatabaseName $wizard.Database.DatabaseName -LoginName $wizard.Database.InstallerDatabaseLoginName -LoginPassword $wizard.Database.InstallerDatabaseLoginPassword -UiPath "~$uiPath" -AvoidDbTransaction

--

I have an existing empty database that I'm trying to use.

 

Thanks for any tips on how to solve this.

#37628
Mar 15, 2010 13:16
Rob
Vote:
 

I've started getting the same error. Windows Server 2008 R2 + SQL Server Enterprise 2008.

#39055
Apr 29, 2010 15:42
Rob
Vote:
 

I raised a case with technical support and the official response I received was that the EPiServer Deployment Center has a minor bug in it that causes installation of the database to fail if you have already pre-created the database on your database server.

My quick solution was to remove the database I'd created but left the user and security I'd created in place, and then let the EPiServer Deployment Center recreate the database for me as part of the installation.

Hey presto, solved. Hopefully EPiServer will fix this bug soon.

#39808
Jun 02, 2010 11:18
Vote:
 

Hi Rob, did you get a bug number from support? I am trying to look up the status of this bug..

#39820
Jun 02, 2010 13:00
Rob
Vote:
 

Hi Per, I wasn't given one no, however you're welcome to the case number (192691) if that'll help you track down the right people to talk to internally.

#39821
Jun 02, 2010 13:04
Vote:
 

Found it (22282), the behaviour was determined as "by design" and hence split into a fix and an feature request. The fix is already done and warns you when trying to install into an existing empty database and a feature request to support this scenario.

#39823
Jun 02, 2010 13:50