Note: This solution is applies to DocuShare 6.5.x and 7.
Warning: DocuShare 6.5.x and 6.6.x use SQL Express 2005; therefore, moving to SQL 2000 Server is not supported.
Note: The words MSDE and SQL Express are used interchangeably.
Note: This solution should only be performed by an Administrator.
Note: The steps provided below should be followed in order.
1. Backup the DocuShare Database Files on SQL Express
Note: The backup of the database files and the documents directory must be done at the same time so that the information contained is in sync.
Note: Please contact Microsoft for additional information on backing up the database.
From the DocuShare Server that has SQL Express (MSDE),
a. Stop DocuShare
b. Stop the SQL Express service (usually listed as SQL Server (DocuShare) in Services)
c. Use your standard backup procedure to back up the Docushare.mdf and the Docushare_log.LDF files that are contained in the Xerox\Docushare\SQLExpress\MSSQL.1\MSSQL\Data directory.
Note: The installation path to SQL Express (MSDE) may vary depending on your installation environment.
2. Verify TCP/IP Enabled on the SQL Server
From SQL Server,
a. Open the Microsoft SQL Server Configuration Manager
b. Expand the SQL Server Network Configuration and Select Protocols for MSSQLSERVER
c. Verify that TCP/IP status is Enabled
3. Enable Windows and SQL Authentication Mode on the SQL Server
From the SQL Server,
a. Open the Microsoft SQL Server Manager
b. Highlight your SQL Server and right-click on Properties
c. Select Security, under the Server Authentication Heading
d. Select SQL Server and Windows Authentication Mode (Sometimes labeled Dual or Mixed Mode depending on the version of SQL)
e. Click the OK Button to apply the changes.
4. Attach the Database files to the SQL Server
a. On the new SQL Server, attach the Docushare.mdf and the Docushare_log.LDF files that you backed up in Step 1.
5. Verify Full Text Indexing is Enabled
From the SQL Server,
a. Open the Microsoft SQL Server Manager.
b. Highlight your database, right-click and select Properties.
c. Select Files, under the Place a Check Mark in the Use full-text indexing checkbox.
d. Click the OK Button to apply the changes.
6. Manual OSQL (Check Database)
Note: This test is mimicking what DocuShare is trying to do when it connects to SQL. It is very important that you are able to successfully log into SQL using the OSQL command before you proceed to Step 7, because if you proceed to Step 7 without the proper login information for DocuShare it will not be able to connect to the database and DocuShare will not start.
From the DocuShare Server,
a. Click Start | Run. The Run window will be displayed.
b. In the Open: field type cmd. The cmd.exe window will be displayed.
c. Type OSQL -S servername -Usa -Psa then press Enter.
d. Where servername = the host name of the computer, -U = database User name, -P = database Password
Note: If you installed an instance in SQL for DocuShare you will need to use the following command OSQL –S servername\instancename –Usa -Psa
e. If you have logged into SQL successfully then 1> prompt will be displayed.
7. Connect to New Database Type.
For DocuShare 6.5.x Servers:
a. Follow the workaround instructions listed in the Unable To Change Some of the Database Information Using the dssetup Command solution listed at the bottom of the page.
For DocuShare 6.6.x and 7 Servers:
a. Stop DocuShare.
b. Open the Command Prompt Window.
c. Change into the <dshome>\bin directory.
Where <dshome>is replaced with the installation directory for DocuShare. The default installation path is C:\Xerox\Docushare. Depending on your installation environment the path may vary.
d. Type dssetup and press Enter.
Note: Configurations displayed may vary depending on the version of DocuShare installed and how the site was installed, licensed, and configured.
e. Make your appropriate changes to the following database configuration.
• Database host current database host name
• Database port number 1433
• Database link chunk size 100
• Database search result chunk size 100
• Database user sa
• Database name Docushare
• Database is a named instance true
• Database instance name docushare
f. Start DocuShare.
8. Change the Pool Size
a. Log into DocuShare as admin.
b. Click Admin Home | Services and Components | Database. The Database page will display.
c. In the Pool Size field change the value to 35.
d. Click the Apply button.
Solution Updated: January 27, 2014
Solution ID: 616