FileCabinet CS: There is a problem accessing the SQL server

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.

Characters left:

When using FileCabinet CS with the optional database file format (rather than the default flat-file format), if the application cannot communicate with the database server (Microsoft SQL Server) due to environmental, network connectivity, or configuration issues, the program will not function.

While the error that is generated most often is "There is a problem accessing the SQL server", the particular error message can sometimes vary based upon the context in which the connectivity issue arises.

  • A transport-level error has occurred when sending the request to the server, (provider: Shared Memory Provider, error: 0 - Shared Memory Provider:)
  • An error has occurred while establishing a connection to the server. When connecting to SQL Server 20xx, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
  • "SQL Server has been paused. No new connections will be allowed. Login failed for user 'CreativeSolutionsFileCabinetCsDatabaseOwner'.
  • A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

We have provided suggested troubleshooting steps for resolving these errors below:

These errors represent that there is something environmental and not unique to the CS Professional Suite applications that is not allowing the program to connect to the MS SQL Server instance it uses. Due to this and the advanced systems steps provided that are unique to your network's environment, while Thomson Reuters support may be able to provide some general guidance, you should consult with your qualified IT professional familiar with SQL and your environment for assistance in resolving this issue. For more information, see SQL Server best practices for CS Professional Suite applications.

Common Fixes on a New Installation

If this is a new installation of FileCabinet CS, and the program is failing at multiple workstations, then usually the problem is a result of settings on the SQL server. Additionally, if you have installed the FileCabinet CS program on the SQL server (during Step #3 of the installation), you will usually find that FileCabinet CS works properly when accessed from the server itself. In this instance, the errors can usually be resolved by checking for and updating the following:

(Note that you may need the assistance of your IT consultant or network technician to complete the below steps)

The SQL Server Browser Service is not running

  1. At the machine where the SQL Server instance resides, click the Start button. Choose Run and type Services.msc and click OK.
  2. In the list of services, find SQL Server Browser.
  3. Double-click that item and make sure the Startup type is "Automatic" and that the Service Status is "Started".
  4. If the SQL Browser is not started, then click the Start button to start the service and click OK.

TCP/IP Connections are not enabled for SQL Server

  1. At the machine where the SQL Server instance resides, go to Start / All Programs / Microsoft SQL Server 20xx / Configuration Tools / SQL Server Configuration Manager.
  2. Select SQL Server 20xx Network Configuration / Protocols for <InstanceName>.
  3. Verify that TCP/IP is "Enabled".
  4. If the status is "Disabled", right click and select Enable.

Named Pipes are not enabled for SQL Server

  1. At the machine where the SQL Server resides, go to Start / All Programs / Microsoft SQL Server 20xx / Configuration Tools / SQL Server Configuration Manager.
  2. On the left-hand pane, expand SQL Server 20xx Network Configuration and then click Protocols for <instancename>.
  3. In the right-hand pane, verify that Named Pipes is "Enabled". If it is not, right-click on Named Pipes and choose Enable.
  4. On the left-hand pane, expand SQL Native Client Configuration and then click Client Protocols.
  5. In the right-hand pane, verify that Named Pipes is "Enabled". If it is not, right-click on Named Pipes and choose Enable.

Note: After enabling TCP/IP and Named Pipes, stop and restart the SQL Instance and the SQL Browser. This can be done either in the SQL Server Services section of the Configuration manager, or in Services.msc under the name SQL Server (instancename)

The FileCabinet CS Database Server machine is running a Firewall

If you are currently running a firewall (such as Windows Firewall) on the machine where the MS SQL instance resides, this can prevent workstations from properly connecting to it. Temporarily disabling the firewall can be done to test if this is the case, and if so, proper exceptions should be added for SQL specific ports and executables. For a list of exceptions, see Firewall guidelines for CS Professional Suite applications.

Eliminating FileCabinet CS Related Causes

The above steps fix most occurrences of this problem. If, after doing the above, the problem is still occurring, the next step in determining the cause of the connection issue is to determine if it is caused by a configuration issue within FileCabinet CS. Do any of the following, as necessary / appropriate:

Error occurs at one or a few workstations but works at others

Uninstall FileCabinet CS and reinstall using the FileCabinet CS desktop setup process on each of the affected workstations. If you have multiple WinCSI directories, you may need to confirm the directory you are using for this install is indeed the active location for FileCabinet CS.

Note: It is strongly recommended that any antivirus program be completely disabled before reinstalling the FileCabinet CS desktop.

Error occurs at all workstations (including fails at server)

  1. Browse to the ZFCDB.DAT file in the X:\WINCSI\fcabdatadb\ServerName_InstanceName.fcabdatadb folder (where X:\ represents your server drive).
  2. Check that the dbmsServerInstance is correct and the the dbname is listed as fcabdatadb.
  3. If the information is incorrect, a reinstall of the FileCabinet to your SQL instance, or the creation of a new SQL instance, may be necessary. Instructions can be found at FileCabinet CS: Installing FileCabinet CS on a SQL Server.

Troubleshooting Other Causes

If the above steps have all been tested and eliminated as causes of the issue, you may want your qualified IT professional to check for the following less common issues:

The SQL Server is not started or responding

  1. Try to start or restart the instance of SQL Server used by FileCabinet CS: On the SQL Server, go to Control Panel / Administrative Tools / Services.
  2. If you receive an error attempting this, the server will need to be rebooted.

Note: Also check for additional SQL Services to ensure they are also started, however, the SQL Server Agent service is not required. Be aware that stopping and starting the SQL service will affect any other applications utilizing that instance.

Domain Name System (DNS) services in the network environment are unreliable

Replace the MACHINENAME of your database server in the dbmsServerInstance of the ZFCDB.DAT file with the IP address of the SQL Server. ZFCDB.DAT is located in the X:\WINCSI\fcabdatadb\ServerName_InstanceName.fcabdatadb folder where "X" is your network drive letter.

You can determine the server's IP address by doing the following:

  1. In Start/Run enter "cmd" and click OK.
  2. Enter the command: ping MACHINENAME.

    Note: If you need the IPV4 IP address, enter ping MACHINENAME -4.

  3. The response should include the following text:

    "Pinging MACHINENAME [] with 32 bytes of data:"

  4. represents the valid IP address for MACHINENAME.

Note: If using the IP address instead of the machine name resolves this issue, this means your network's DNS is not functioning properly. As this represents an issue that can continue to affect the performance of many network based applications and services (including outside of the CS Professional Suite), using the IP address should only seen as temporary solution and this issue should be addressed promptly by your qualified IT professional.

Trend Micro Worry Free Business Security was installed on database server machine after the SQL Data Location was created.

You will need to run the setup.exe file in X:\WINCSI\CABINET\sql and choose to install a new instance (if you are using a paid version of SQL, create a new instance of the version of SQL before running this). Restore a backup of the databases in the original instance into the new instance.

Note: Do not uninstall Trend Micro Worry Free Business Security.

A third-party application or service is interfering with SQL Server database connectivity

  1. Reboot the workstation and boot in Safe Mode with Networking.
  2. Retest for problem.
  3. If FileCabinet CS now works, disable all non-Microsoft services and startup items using MSCONFIG.EXE.
  4. Enable small numbers of items and retest until the specific item that is causing the interference is identified.
  5. Disable or uninstall the interfering application, service, or startup item.

Verify the settings for the SQL instance in Microsoft SQL Management Studio

Note: Microsoft SQL Management Studio is Microsoft's application for managing and maintaining SQL instances. These steps require you to have the appropriate version of Management Studio for your SQL instance installed on the database's server as well as a working knowledge of this utility. Please contact your qualified IT professional if you need assistance.

Authentication Mode
  1. Once connected to the proper database instance in Microsoft SQL Management Studio, right-click on the instance name and choose Properties.
  2. Click on Security and make sure the box for SQL Server and Windows Authentication Mode is checked.
Database Owner
  1. Open Microsoft SQL Management Studio on the SQL server and connect to your SQL Server instance.
  2. Expand the Security folder then the Logins folder to see if CreativeSolutionsFileCabinetCsDatabaseOwner and CreativeSolutionsFileCabinetCsApplication are listed.
  3. If they are not listed, verify that your database instance is set to SQL Server and Windows Authentication Mode (see the steps above) and rerun the SQL setup.exe file found within X:\WINCSI\Cabinet\sql. During Step #2 of the install, select your existing instance of SQL in order for this Login to get created.

Make sure Microsoft data compression and encryption is not enabled for SQL files

The FileCabinet SQL database is initially made up of four files, fcs_fcabdatadb.mdf, fcsd_fcabdatadb.mdf, fcs_fcabdatadb_log.LDF, and fcsd_fcabdatadb_log.LDF, that by default are installed to the X:\Program Files\Microsoft SQL Server folder on the server (where X:\ represents your server's hard drive). These files cannot be compressed or encrypted. In Windows Explorer, compressed folders/files will appear in blue, and encrypted folders/files will appear in green. To turn off compression and/or encryption, right-click on the Program Files (or Program Files (x86) ) folder on the server and choose Properties. On the General tab, click the Advanced button and unmark the options for Compress contents to save disk space and/or Encrypt contents to secure data.

Symantec Endpoint Protection 11.0 is installed on the Workstation

We have found some circumstances in which Symantec Endpoint Protection 11.0 has prevented workstations from connecting to the SQL Server. Additionally, Symantec no longer supports version 11 as of January 2015. Uninstall or update Symantec Endpoint Protection 11.0 from the Workstation and retest.

Still receiving error?

The above represent the known issues that will cause and fix these errors. If, after troubleshooting and resolving the above, you are still receiving errors when connecting to the SQL Server, then you should test SQL connectivity outside the software. The following steps will use tools built into Windows (and completely independent of FileCabinet CS) to attempt to establish a connection between a computer and your SQL Server:

Create an ODBC connection

  1. Go to the Microsoft Windows Control Panel
  2. Choose Administrative Tools, then Data Sources (ODBC)
  3. Click Add.
  4. Choose SQL Server and click Finish.
  5. Enter a Name and Description (anything will do), then enter the Server\Instance name of the SQL instance used by FileCabinet CS (e.g.: ServerName\CREATIVESOLUTION).
  6. Click Next until you can click Finish on the setup wizard.
  7. You should get a pop-up window showing the ODBC MS SQL Server Setup screen.
  8. Click the Test Data Source button.
  9. You should see a successful connection to the SQL server, and it should indicate that the "test completed successfully".
  10. Once you have the results, you can close all of the open windows and exit the Administrative Tools.

A failure of the ODBC connection test would indicate that the Microsoft Windows workstation was unsuccessful at connecting to Microsoft SQL Server, and while this may only be manifesting itself with FileCabinet CS, the issue is being caused by something environmental outside of the program. For further assistance in troubleshooting this issue on your firm's computers, you would need to contact a qualified IT professional who is proficient with SQL Server and your network. Once the ODBC connection test is successful, it is highly likely that our CS Professional Suite applications will also be able to make a connection and operate successfully on your system.

Related Topics

Share This