In the first episode, I tried to install SQL Server 2008 RC0 Advanced Express (with only the database engine and Management Studio)...but the result was "Error 1814" during service starting.
First action : "Repair"...but not possible because the program can only repair a well performed installation.
In this second episode, I tried to uninstall the database engine service that previously failed and then try to reinstall it !!!
Uninstalling...
Reinstalling...
This time, the installation succeeded !
To resume the differences between the first and the second installation (before --> after) :
- Selected features : Database only --> Database + Full text search
- Account for database service : NETWORK SERVICE --> SYSTEM
- Collation : French_CI_AS --> Latin1_CI_AI
I have operated this change for the following reasons :
- Full text search : the error's description was talking about "dependency problem"...I tried to add the classical service associated with SQL Server
- System Account instead of Network Service : the error's description was talking about "file write or access problem"
- Collation : this is a Release Candidate and recurrent problem with beta versions are associated with language problem (being full English is always better !). For information, I have installed SQL Server on a French Windows Vista system.
I will try to find the real root cause...