dashCommerce

Hi,

I'm trying to install new dC3.0 and I've received this error installing database: 

  A critical error has occurred: Table or indexed view 'dbo.dashCommerce_Store_Product' does not have a full-text index or user does not have permission to perform this action.

 Any ideas? I did it with sa user and in localhost sqlexpress.

 Thanks

Are you using the correct version of SQL Express? You need to use SQL Server Express 2005 with Advanced Services (minimum). My guess is that the script is trying to do the full text catalog, but it can't because you don't have the correct version installed. Please check out the Technology page under Learn More.

 I'll try it, thank!

Got this error as well.  Another post reports that you need to enable Named Pipes (in Server Configuration Manager) as it's not enabled by default.  I also recreated the database as the error comes part way through the install so some of the db elements had been created.

 Happy hunting.

It's not the named pipes - if that was the case then no db objects would have been created at all b/c it wouldn't be able to connect to the database server. The error looks to be coming from the part of the script that is creating the full text index on the dashCommerce_Store_Product table. Unless it's an erroneous error I think it's the wrong version of SQL Server 2005 installed. Waiting to hear more . . .

Make sure when you create the database you enable Full Text Search.

If your database has already been created:

1. Open Server Management Studio and Connect to your database server
2. Expand Databases
3. Right Click your database and select Properties.
4. Click Files on the Left
5. Make Sure Use full-text indexing is Checked.

If you have not yet created your database:

1. Open Server Management Studio and Connect to your database server
2. Right Click Databases and Select New Database
3. Make sure Use full-text indexing is check

 Of coarse you have to have SQL Server Express 2005 with advanced Services Installed.

If you do not you can find the download here:
http://www.microsoft.com/downloads/details.aspx?familyid=5b5528b9-13e1-4db9-a3fc-82116d598c3d&displaylang=en

 If you are upgrading its alittle more of a pain.  You need to either remove the files in Template Data directory under your install or uninstall the standard SQL 2005 express verison and do a full install of 2005 with AS.

-- Luke

chriscyvas:

It's not the named pipes - if that was the case then no db objects would have been created at all b/c it wouldn't be able to connect to the database server.

I beg to differ - this did happen for me.

ndycrlr:

chriscyvas:

It's not the named pipes - if that was the case then no db objects would have been created at all b/c it wouldn't be able to connect to the database server.

I beg to differ - this did happen for me.

hmmm . . . from my understanding you can connect via TCP/IP, Named Pipes, or both. So, how did you connect? Maybe there is something farther down the line - something the full text search is dependent on that wasn't configured for named pipes?

By default, SQL Express uses the 'Shared Memory' protocol and doesn't enable Named Pipes or TCP/IP.  With this default, the install script did get as far as creating the tables but couldn't create the indexes as found by albertarranz.

Very nice - thank you!

I have to say, so far this is the most difficult install I've ever encountered for a database.

 Fist I encounter this error, and I seem to get past it. I have pipes enabled, I've checked full text index for the database but then I get one error after another.

 Errors I get:

Invalid locale ID was specified. Please verify that the locale ID is correct and corresponding language resource has been installed. Informational: No full-text supported languages found. Informational: No full-text supported languages found

A full-text catalog named 'dashCommerce_Catalog' already exists in this database. Use a different name.

Table or indexed view 'dbo.dashCommerce_Store_Product' does not have a full-text index or user does not have permission to perform this action.

 Gee what to do now?

Since you get "A full-text catalog named 'dashCommerce_Catalog' already exists in this database. Use a different name." you've got a partially created database which is what happened to me.  I deleted the database and started again and since I had all the other stuff in place - i.e. named pipes - I was away.

Ok, here is the solution.

After getting the Invalid ID for the language error, clicking Next on the wizard is what produced the "'dashCommerce_Catalog' already exists" error. Even though I could delete the db to fix the second error I was never addressing the first error.

 To Fix:

 In the SQL Express Configuration Manager, I had to change both the Full Text Search and SQL Server Service "Log On As" to Local System instead of Network Service.

It sounds like we a need a detailed install instruction sheet for SQL Server Express with Advanced Services. Who can make that happen? I'll put it up in the documentation section.

Hi everybody,

After install  SQL Server Express 2005 with Advanced Services, I've follow steps ASI said in his post and it works fine for me.

Please, note that Sql Server Express with Advanced Services instalation requires Full-Text Search feature to be selected, by default it's excluded.

Thanks