June 17, 2009 at 8:02 am
I recently installed full text search onto SQL 2005 express. However, SQL shows no evidence that it is installed.
I ran:
select fulltextserviceproperty('isfulltextinstalled')
And it returned '0' or false. So, I went into the services.msc (same for SQL configuration manager) and found that full text was running on a different and unused named instance.
How would I get the other named instance to run Full text search?
June 17, 2009 at 8:11 am
If it is the right version, you'll need to rerun the setup. You can go to Add Remove programs and find SLQ express..the dialog would have a modify option so you can re-run it.
you could also uninstall that other unused version there as well.
the plain SQLExpress doesn't have full text i believe; you need to make sure you are using SQLExpress with Advanced Services; it's a larger download form Microsoft than the plain express version.
Lowell
June 17, 2009 at 8:21 am
Yeah, I have advanced services. I forgot to also mention that when I use "modify" from from the add/remove it will let me select FTS and then named instance, but after that I get this message: "None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and select features to install. To exit SQL Server Setup, click Cancel."
Can I only uninstall just the FTS feature and nothing else?
June 17, 2009 at 8:26 am
yes, you can uninstall FTS, and then re-install it;
ive done that with FTS and reporting services; it doesn't break any other part ofg your installation.
Lowell
June 17, 2009 at 8:39 am
Thanks, uninstalled it... but I still get the same message:
Details of that message gives more info:
Name: Microsoft SQL Server 2005
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Build version check:
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.
I remember getting that message before I installed FTS the first time, after several failed tries one time I tried it worked and for some reason it didn't ask for a named instance that time. I don't remember doing anything different. I do click on the "install a new component" link. I also tried the other way as well.
June 17, 2009 at 8:52 am
I rebooted tried again and it asks for the sqlrun_sql.msi. I pointed to the file, but it still complains that it's not a valid installation package.
June 17, 2009 at 9:00 am
Looks like it will only install on the other named instance. Is there some command promp method to fix just carry it over to the correct named instance?
June 17, 2009 at 9:17 am
Well, the other instance was some sort of pre-installation the webserver made. I've been using that old instance. But the newer instance can have the advanced services I installed. Would it be best to somehow transfer everything from the old instance onto the new instance?
June 17, 2009 at 10:57 am
saivko (6/17/2009)
Well, the other instance was some sort of pre-installation the webserver made. I've been using that old instance. But the newer instance can have the advanced services I installed. Would it be best to somehow transfer everything from the old instance onto the new instance?
If I understand you correctly you cannot run SQL Server Express standard and Advanced services in one box in 2005, I don't know if that changed in 2008 but you are in 2005 so you need to make all your instances either standard or Advanced.
Kind regards,
Gift Peddie
June 17, 2009 at 2:25 pm
From what I can tell, I am running both. Though I'm wondering what kind of SQL the webhost had pre-installed. It was SQL without the management studio or configuration manager. I've been using the express software to manage the database though.
We certainly haven't been paying for any non-express software they offer.
June 17, 2009 at 2:50 pm
That may be the reason fulltext which comes with the Advanced is disabled, now you know fulltext is not available in User Instance so make sure you are running server instance and check your configuration manager because fulltext is disabled by default in the Express edition. If all that does not fix it uninstall everything and read the read me and install new Advanced features instances make sure you add fulltext and enable it in configuration manager.
Kind regards,
Gift Peddie
June 18, 2009 at 8:14 am
Thanks, I actually have two different named instances, not user instances if there is a correct distinction there.
I always have had FTS working well and fine (with advanced services) on the named instance that I don't want to use.
June 18, 2009 at 10:19 am
Per Microsoft you may have to manually uninstall and reinstall that instance.
http://support.microsoft.com/kb/909967
Kind regards,
Gift Peddie
June 18, 2009 at 1:19 pm
Thanks for your patience.
As it turns out it looks like I have two different installations of SQL. The pre-installation seems to be SQL Workgroup 2005 or above along with my installation of SQL 2005 Express with advanced services.
The pre-installation, whatever it is, seems to have no features added onto it, but it does allow remote connections. Bizarre stuff.
June 18, 2009 at 1:27 pm
The pre-installation, whatever it is, seems to have no features added onto it, but it does allow remote connections. Bizarre stuff
No it is not Workgroup it is user instance because it does not allow remote connection, fulltext is not allowed and SQL authentication is also not allowed. Run search in BOL for all user instance restrictions and try all. I think it is user instance.
Kind regards,
Gift Peddie
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply