Full text indexing wasn't enabled during installation.
It says to go to add/remove programs. Going that route when it goes to install FTI it says that it can't find the installation files in what looks to be the origonal "TEMP" folder created and removed during installation.
If I run the program installer from the download again it states that SQL is already installed and to use "add/remove programs".
We are stuck at this point. Is there an ISO available that could be burned to disk?
Thanks in advance.
We've seen this error a few times during Express reinstalls and I haven't heard of a nice solution. One option is to backup your databases, uninstall your Express instance and reinstall it with FTI enabled.
Thanks,
Sam Lester (MSFT)
What you should be able to do is run the original program installer from a command line with the "\X" switch. This will display a dialog that will allow you to extract the files inside the package to wherever you want. You should be able to put them anywhere you like on you local hard drive. Then when you use Add/Remove programs to maintain your Express instance, and it asks for the files, make sure you browse to the "Setup" directory underneath where you extracted the bits. That should work without you having to uninstall your existing instance.
|||This will also be documented in the requirementssqlexp2005.htm file located at the root of the folder where you extracted out the bits. It is under the section titled "Modifying SQL Server Express Installed Components".|||After unpackaging using /x I get the following error, when trying to add FTI via the "add remove programs"."The file G:\myfilepath is not a valid installation package for the product Microsoft SQL Server 2005 (SQLEXPRESS). Try to find the installation package 'sqlrun_sql.msi' in a folder in which you can install Microsoft SQL Server 2005 (SQLEXPRESS)."
The file is there in the folder.
Any other ideas short of uninstalling/reinstalling?|||
You need to make sure to browse to the "Setup" folder underneath where you extracted. If the setup folder is not there, than the extraction may not be correct. G:\myfilepath should contain a setup.exe file, and then a setup folder. In the setup folder there should be a bunch of MSIs, one of which is sqlrun_sql.msi.
Also, make sure the Sqlexpr.exe you are running to extract is the same as what was used initially to install. If the editions don't match than you could see that error as well. For example, don't mix and match SQL Express with SQL Express with Advanced Services.
|||I did point to the file in the setup folder (it was there).This is the same .exe that was downloaded one month ago.|||I just tried this out myself and it does appear to work, so hopefully this should be easy to resolve. Could you post two logs so I can see what might be failing for you? Both the latest *_WI.log and *_SQL.log files would be needed (located in %programfiles%\microsoft sql server\90\setup bootstrap\log), thank you!|||
Sorry, I'm new here and didn't realize you can't post attachments. Here is what I need from the *_WI.log. Search for this string:
Doing action: ResolveSource
And then copy and paste the contents of the log up until this string:
ResolveSource. Return value
Let's just start with that, and then see if I need the *_SQL.log.
