Failed to install CS2007.1 express edition on server 2003
sp2 box

I tryied to install CS2007.1 (build 3.1.20917) expression version in my local
box but failed for some reason. the installation logs are attached below. I
could not figure out what is wrong. any help will be appreciated.

thanks,

huajun

 Starting Installation
    Action Start: PreConditions - 11/1/2007 9:55:02 AM
    Action Finished: PreConditions - 11/1/2007 9:55:02 AM
    Action Start: DatabaseInstall - 11/1/2007 9:55:02 AM
    Action Finished: DatabaseInstall - 11/1/2007 9:55:03 AM
    Action Start: DatabaseUsersCreation - 11/1/2007 9:55:03 AM
    Action Finished: DatabaseUsersCreation - 11/1/2007 9:55:03 AM
    Action Start: DatabaseStructureCreation - 11/1/2007 9:55:03 AM
        ---------------------------------
        ApplicationException:
            System.ApplicationException: Error creating the database structure
using the script file C:\Program Files\Telligent\Community Server
2007\Web\Installer\SQLScripts\cs_schema.sql --->
System.Data.SqlClient.SqlException: Foreign key 'FK__cs_Folder__UserI__39237A9A'
references invalid column 'UserId' in referenced table 'cs_Users'.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
   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.SqlCommand.RunExecuteNonQueryTds(String methodName,
Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at
CommunityServerInstall.WebApplicationInstaller.Helpers.SqlConfig.ExecuteSqlScrip
t(IDictionary bag, String pathToScriptFile)
   at
CommunityServerInstall.WebApplicationInstaller.Actions.DatabaseStructureCreation
.Do(IDictionary bag)
   --- End of inner exception stack trace ---
   at
CommunityServerInstall.WebApplicationInstaller.Actions.DatabaseStructureCreation
.Do(IDictionary bag)
   at
CommunityServerInstall.WebApplicationInstaller.InstallerController.Install()
        ---------------------------------
    Action Start: WebSiteInstall - 11/1/2007 9:55:15 AM
    Action Finished: WebSiteInstall - 11/1/2007 9:55:15 AM
    Action Start: CustomDataInsert - 11/1/2007 9:55:15 AM
        ---------------------------------
        ApplicationException:
            System.ApplicationException: Error creating community using exec
cs_system_CreateCommunity
'localhost/cs/','dev','hluo@microsoft.com','admin','officelabs',0,1 --->
System.Data.SqlClient.SqlException: Could not find stored procedure
'cs_system_CreateCommunity'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
   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.SqlCommand.RunExecuteNonQueryTds(String methodName,
Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at
CommunityServerInstall.WebApplicationInstaller.Helpers.SqlConfig.ExecuteSql(IDic
tionary bag, String sql)
   at
CommunityServerInstall.WebApplicationInstaller.Helpers.SiteConfig.SetCommunity(I
Dictionary bag, String url, String appname, String adminemail, String adminname,
String adminpwd, String createsample)
   --- End of inner exception stack trace ---
   at
CommunityServerInstall.WebApplicationInstaller.Helpers.SiteConfig.SetCommunity(I
Dictionary bag, String url, String appname, String adminemail, String adminname,
String adminpwd, String createsample)
   at
CommunityServerInstall.WebApplicationInstaller.Actions.CustomDataInsert.Do(IDict
ionary bag)
   at
CommunityServerInstall.WebApplicationInstaller.InstallerController.Install()
        ---------------------------------
    Action Start: WebConfigUpdate - 11/1/2007 9:55:15 AM
    Action Finished: WebConfigUpdate - 11/1/2007 9:55:15 AM
    Action Start: GrantPermission - 11/1/2007 9:55:15 AM
    Action Finished: GrantPermission - 11/1/2007 9:55:15 AM
Installation Complete.

Try deleting all the tables, stored procedures and views from the db. Then run
the SQL script (create full database) manually.