I have had users create test databases on their desktops and then manually delete the 6 files that sit outside of content server. (eg.files with extenstions cac,cba,cbs,ini,log,slt)

However, the test textbases still show up in the List Textbases command. Does anyone know how to fully delete these ones so they are not in the msde sql server and not listed under List Textbases?

Thanks, Jennifer

One should always use Manage Textbases>Delete Textbases to delete Content Server textbases.

To clean up when only the external files were deleted:

A) Use Manage Textbases>List Textbases to determine the SQL Database name:

Textbase: d:\data\catalog
SQL Database: '_InmTB_200'

B) Use a tool like SQL Server Enterprise Manager to delete that table name. This step releases most of the disk space used by the textbase.

C) Again in Enterprise Manager, click on _InmTextbases to open it, and select Tables.

D) Right click on the _InmTextbaseMap table and choose Open Table>Return All Rows.

E) Delete the entire row for the textbases for which the external files were deleted. This step removes the textbases from List Textbases.

If you don't have SQL Server Enterprise Manager, there are lots of similar utilities available for download.

Thanks for the quick reply. Is there a way to turn off the New textbase function so that users cannot create new textbases. I would prefer that only the administrator be able to do that and then we will not run into this situation again.

If you're using Windows Authentication (with Content Server Standard), only users with the Content Server Administrator role in Set Security on SQL Server can create new textbases.

We are using Content Server Standard. When I open the CS Administration software the open to Set Security on the SQL Server is grayed out.

Then you're using SQL Authentication instead of Windows Authentication. If you're using a current version of Content Server, your INMCSRV.INI file has the following:

[Inmagic Content Server]
WindowsAuthentication=0

Users often select SQL Authentication if they have to go through a firewall to get to their SQL Server or Web Server, or if they don't want to deal with setting security for specific users.

Using Windows Authentication also means that Windows Administrator or SQL sysadmin access (and/or a specific SQL Server role) is required for several of the operations in INMCSADMIN.EXE like Back Up Textbases, Restore Textbases and Delete Textbase.

Then I am assuming that INMCSRV.INI has
WindowsAuthentication=0 set by default when the software in installed. I do not remember getting an option in the installation notes for setting user adminstrator access.

All our databases are on our Intranet so no firewall is in effect. To change it to Windows Authentication would you just put WindowsAuthentication=1?

No, Content Server Standard defaults to using Windows Authentication. Those who want to use SQL Authentication must manually set WindowsAuthentication=0 in the INMCSRV.INI file.

Note that version 1.0 only supported SQL Authentication, but very few people got that version.

If you're really using Content Server Standard (your serial number on Help>About CS/TextWorks in CS/TextWorks would start with CS2x, not CS1x, which is for Workgroup), then yes, you can set WindowsAuthentication=1.

However, I would recommend backing up all of your textbases (using Back Up & Restore>Back Up Textbase) before making this change, just to be safe.

Okay by Standard I thought you meant Workgroup... so now my question is can we set security in workgroup?

No, Content Server Workgroup only supports SQL Authentication.

With Workgroup, the only way I can think of to prevent users from creating textbases is to remove the db_creator role for the _Inmagic_Content_Server login (using a tool like Enterprise Manager), then add it back whenever you want to do anything that creates a textbase (New Textbase, Copy Textbase, Recover Textbase, Upgrade Textbases from DB/Text, etc.).

quote:

Originally posted by CDale:
B) Use a tool like SQL Server Enterprise Manager to delete that table name. This step releases most of the disk space used by the textbase.

CDale, in this post, did you mean "Use a tool like SQL Server Enterprise Manager to delete that database name." ? I need to do this but just want to make sure you are referring to the database and not a table.

Thank you,
Zoe