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.
4. 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.
5. 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.
6. Verify Full Text Indexing is enabled
a. Click Start | Settings | Control Panel | Administrative Tools | Services
b. Scroll down the list of Services and look for SQL Server Full Text Search
c. Verify that the Status is Started. If the Status is listed as Stopped, then Start the Service.
Note: In SQL 2008 all user created databases have full text indexing enabled by default. However, you can verify that the service that is used for Full Text Indexing is started in Services. The service is labeled SQL Full-Text Filter Daemon Launcher or FDHOST Launcher.
Note: To verify that Full Text Indexing is Enabled you can run the following query.
SELECT FULLTEXTSERVICEPROPERTY(‘IsFullTextInstalled’). If the result is a 0 then it is not enabled, if the result is a 1 then Full Text Indexing is enabled.
Note: The full-text indexing configuration is also displayed by selecting the Database | Properties | Files. The Use full-text indexing checkbox should have a checkmark.
7. Try manually logging into the Database.
Note: Check KB article for detailed steps on How To Manually Log Into the SQL Database To Test the Connection
How To Manually Log Into the SQL Database To Test the Connection
Solution Updated: April 1st, 2014
Solution ID: 1037
External reference: https://learn.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver16