Note: This applies to any version with SQL.
Note: Instructions listed below require the use of the SQL Server Configuration Manager and the SQL Server Management Studio.
Verify the following SQL Settings:
Note: You must be a Windows Administrator to perform this solution.
1. Verify the SQL version and edition.
a. Open the SQL Management Studio and Connect to SQL Server.
b. Select New Query button.
c. Type SELECT @@version and then click the !Execute button.
d. The results will list the version and edition of SQL you are running.
e. Verify that the version listed is supported with the version of DocuShare you will be connecting it to.
Note: The Latest System requirements are available here http://docushare.xerox.com/products/systemreqs/en/. If you are running an older version of DocuShare you can Search the Knowledge Base for the System Requirements for the version you are running and/or contact DocuShare Support.
2. Verify the Which Protocols are enabled and the TCP Port.
a. From the SQL Server, open the Microsoft SQL Server Configuration Manager.
b. Expand the SQL Server Network Configuration and Select Protocols for MSSQLSERVER.
c. Verify that Shared Memory, TCP/IP, and Named Pipes have a status as Enabled.
d. Verify that VIA is disabled.
Note: The VIA protocol must be disabled because it can cause issues in DocuShare.
e. Double-click TCP/IP. The TCP/IP Property window displays.
f. Select the IP Address tab and verify all the services are set to TCP Port 1433.
3. Verify that Login is enabled.
a. From the SQL Server, open the Microsoft SQL Server Management Studio.
b. Expand Security | Logins.
c. Right-click the sa account and select Properties.
d. From the Select a page menu select Status.
e. Verify under Login heading Enabled is selected.
f. From the Select a page menu select Server Roles.
g. Place a checkmark in the checkbox labeled sysadmin.
h. Click the OK button.
3. Verify SQL Browser is started
a. Click Start | Settings | Control Panel | Administrative Tools | Services.
b. Double-click SQL Server Browser from the list of services. The SQL Server Browser Properties window displays.
c. Select Start (if the service is stopped).
d. Click the OK button.
4. Windows and SQL Authentication Mode is enabled
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.
5. Verify Full Text Indexing is enabled
a. Click Start | Settings | Control Panel | Administrative Tools | Services
b.