I'm having trouble getting my host (DotNetPark) to enable the full-text search features of the great Document Exchange module.
Has anyone had any success with this in a shared hosting environment?
Transcript of DNP support conversation follows:
========================================
NS:
Hi, just wondering if your Sql Server is installed on the same physical box as the webserver, I heard there was a problem using Full Text Search from the DNN module Document Exchange unless Sql Server was on the same physical box. Any advice?
DNP:
No, SQL Server is installed on different location.
NS:
I've spoken with the maker of the DNN Document Exchange module. My question and his answer are below. Would I be able to get a network share created to solve this problem as outlined below?
----------------------------
Q:
Someone mentioned in a review on Snowcovered that Doc Exchange Pro won't work if the sql server is on a separate physical box. Is this true? Is there a fix in the pipeline?
A:
Not entirely true. The full-text search does not work if the documents are stored on a different server than the SQL. However, given the fact that you can use a network share for the document repository, this can be overcome.
----------------------------
DNP:
Sorry, network share is not allowed on our servers.
NS:
Requesting Index Server. Name - DNNDMX, Path: /NSmeaton/nicholasjsmeaton.com.au/Portals/0/DMX/
DNP:
Done
NS:
[rehashed previous conversation about attaching Index Server to Sql Server]
This is a real showstopper for www.chappelldean.com and myself. As mentioned above, we'd need a network share, but we'd also need to temporarily give our Sql Server user account sys admin permissions while we attach the new Index Server catalogue to Sql Server, then remove the sa permissions.
Like I said - it's a huge ask, we'd be prepared to pay a fee to get this happening. If we can't make it happen, we'll need to look elsewhere.
DNP:
Our clients use Microsoft Full Text Search for SQL Server without problem and without network share.
NS:
How do they attach the Index Server catalogue to Sql Server without having sql server sysadmin rights?
DNP:
FullText search for tables of database, not for file-system.
NS:
Actually - the Document Exchange module requires Sql Server to 'read' from Index Server to integrate it's results.
DNP:
Sorry, it's impossible.
NS:
Impossible because it's against DNP policy, or are you saying it's not a feature of Sql Server? The command in Sql Server would be: EXEC sp_addlinkedserver '70.87.18.18', 'Index Server', 'MSIDXS', 'DNNDMX' (http://msdn2.microsoft.com/en-us/library/ms190479.aspx)
DNP:
With a view of security
NS:
Are you talking about the network share when you say "with a view of security"?
DNP:
It's our policy.
========================================