Error attaching catalog - Bring2mind

Bring2mind Forums

Prev Go to previous topic

Go to next topic

Last Post 05/24/2006 11:14 AM by Daniel Steinmann

Error attaching catalog

5 Replies

Sort:


You are not authorized to post a reply.

Author

Messages

Daniel Steinmann

New Member
Posts:17

05/23/2006 9:37 AM
Hello Peter I've a problem with den DocExch Pro 3.2.1 on DNN 3.2.1 with SQL 2000 MSDE. The index is working fine, I checked direct on the server. Following error message if I attach my index, in the DMX options: Sql Server could not attach to the named Indexing Service catalog Is it possible to work with the SQL MSDE? You mentioned nothing about in the doc. Thank's and best regards Daniel

Peter Donker

Veteran Member
Posts:4536

05/23/2006 9:54 AM
Daniel, Yes, MSDE is fine. But the DNN account used to access the database needs sa priveliges to attach the indexing service. You set this in SQL. Peter

Daniel Steinmann

New Member
Posts:17

05/23/2006 10:15 AM
Hi Peter, Thank's for this very prompt response. It was the trick. But now I'm running in the next problem: Error: Invalid object name 'DMX_Entries'. The same error as allready posted, I'm searching the source of problem on SQL. Best regards Daniel

Daniel Steinmann

New Member
Posts:17

05/23/2006 10:33 AM
It's a problem with the dbowner. On my database the dbowner of dnn tables is the user used for the sql connection. I think in the sql statement the {databaseowner} is missing, only the {objectQualifier} is there: An error occurred in the following search: SELECT {objectQualifier}DMX_Entries., ParentEntries.Description AS CollectionName, {objectQualifier}DMX_Extensions.Icon16, 1 AS Rank FROM {objectQualifier}DMX_Entries, {objectQualifier}DMX_Entries AS ParentEntries, {objectQualifier}DMX_Extensions WHERE (({objectQualifier}DMX_Entries.CollectionId = ParentEntries.EntryId) AND ({objectQualifier}DMX_Entries.PortalId = 0) AND ({objectQualifier}DMX_Entries.EntryType = {objectQualifier}DMX_Extensions.ExtensionKey) AND ({objectQualifier}DMX_Extensions.PortalId = 0) AND ({objectQualifier}DMX_Entries.EntryId = {objectQualifier}DMX_Entries.LastVersionId)) AND (({objectQualifier}DMX_Entries.Description LIKE '%ziel%')) Error: Invalid object name 'DMX_Entries'. Invalid object name 'DMX_Entries'. Invalid object name 'DMX_Extensions'. Daniel<!-- End_Module_398 -->

Peter Donker

Veteran Member
Posts:4536

05/23/2006 2:53 PM
dbowner is missing, yes. But I have the same setup here: the dnn sql account has owner rights on the dnn db. And this solution was tested on installations with and without obect qualifier ... Do you use an object qualifier? Peter

Daniel Steinmann

New Member
Posts:17

05/24/2006 11:14 AM
Dear Peter, Thank you for your effort. We finally detected the problem. You've to add this to your documentation. 1. Create the indexing catalog on the server 2. Set the dnn db user to sysadmin 3. Attach the indexing catalog to the sql server (function within docexch options) 4. Remove the sysadmin from dnn db user 5. Do an iisreset Now it's working fine. This procedure is logic, when dnn db user is changed to sysadmin, the user is of type "system" but finally he needs to be of type "user". Best regards Daniel

You are not authorized to post a reply.