Microsoft SQL Server diagnostics

If there's a problem communicating with Microsoft SQL Server, there will usually be error indicators on the PDXpert Application Server console's Information tab.

These instructions have been generalized to address all versions of Microsoft SQL Server (2008, 2008R2, 2012; 32bit and 64bit; Express and other editions). If you encounter any discrepancy, refer to Microsoft's documentation for your specific configuration.

Installation error

The PDXpert System Setup downloads and installs Microsoft SQL Server. If you see a Setup Failed message with a  log file  link, the most common problem is that your computer's antivirus software has blocked installation of the SQL Server database.

To verify, click on the  log file  link, and scroll to the bottom of the log file. SQL Server setup is blocked if you see text similar to:

[xxxx:xxxx][date]e000: Error 0x8xxxxxxx: Process returned error: 0x8xxxxxxx

[xxxx:xxxx][date]e000: Error 0x8xxxxxxx: Failed to execute EXE package.

[xxxx:xxxx][date]e000: Error 0x8xxxxxxx: Failed to configure per-machine EXE package.

[xxxx:xxxx][date]i319: Applied execute package: SQLEXPR_x64_ENU.exe, result: 0x8xxxxxxx, restart: None

[xxxx:xxxx][date]e000: Error 0x8xxxxxxx: Failed to execute EXE package.

Other errors may include one or more of these:

The SQL Server service failed to start

Wait on the Database Engine recovery handle failed

The request failed or the service did not respond in a timely fashion

CREATE DATABASE failed. Some file names listed could not be created.

0x84be0bc2 - Unspecified error

Solution: Assuming that you have administrator rights to your computer, and are the only user logged into Windows, there is one main source, and a few less common sources, of this error:

  • Most likely, your computer's antivirus and/or firewall (AV/FW) is blocking the SQL Server installation or service startup. Disable the AV/FW and re-run the installation. If the installation works, then configure the AV and/or open the FW to allow communications between SQL Server and the PDXpert Application Server, and between the PDXpert server and client application.

  • Windows Update may have a system restart pending, which is blocking SQL Server from starting. Restart your computer to install the update and allow the SQL Server service to start.

  • If you've installed SQL Server on a compressed volume, the system won't attach the PDXpert database. Uninstall SQL Server, decompress the entire volume and re-install; or, use a system that doesn't have a compressed volume.

  • Rarely, the SQL Server service refuses to start, even after disabling the antivirus/firewall and restarting the computer. There appears to be a bug in Microsoft's installers for SQL Server 2008 and 2008R2. Uninstall SQL 2008R2 and manually install SQL Server 2012 or 2014, and then run the PDXpert system setup.

Do you have exclusive administrator access to Windows?

During the installation of PDXpert, you must have administrator rights to your computer, and be the only user logged into Windows.

If you see the error message Service 'PDXpert Server' (PDXpertServer) could not be installed. Verify that you have sufficient privileges to install system services, then it's possible that:

  • Another user is currently logged into your Windows system; or

  • You aren't logged into Windows using an administrator account.

Is the TCP/IP protocol enabled?

The PDXpert System Setup installer automatically enables the TCP/IP protocol for you. However, if you've installed your own copy of SQL Server, then the TCP/IP is not enabled by Microsoft's SQL installers. This may be a source of client connection errors.

To enable the TCP/IP protocol:

  1. From the Start menu, choose All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager.

    If you don't see this menu option, you can open the Configuration Manager by right-clicking My Computer (XP) or Computer (Windows 7) in the Start menu and choosing Manage. In the Computer Management window, expand Services and Applications, expand SQL Server Configuration Manager.

  2. Expand SQL Server Network Configuration and then select Protocols for PDXPERT

  3. In the list of protocols displayed in the central panel, the TCP/IP protocol should be enabled. If you see that the TCP/IP protocol is disabled: click the TCP/IP protocol to select it, and then select Enable from the Action menu or context menu. The status column and icon for the protocol will change to show that the protocol is now enabled. Close the SQL Server Configuration Manager window.

    Enable TCP/IP in SQL Configuration Manager.

  4. Your change will become effective after you (a) restart the "SQL Server (PDXPERT)" service in the Control Panel > Administrative Tools > Services console, or (b) reboot your computer.

Is the firewall allowing communications?

For the Windows firewall, verify that the Windows firewall has an exception. (Refer to the supplier's instructions for all other firewalls.)

To get current details for your operating system, search the web for Windows firewall allow application

To enable the firewall exception in Windows 7 or later (including Windows 10):

  1. Click Start, and then click Control Panel.

    1. In Category view, open System and Security; on the right panel, click Windows Firewall.

    2. In Icon view, open Windows Firewall.

  2. On the left side of the Windows Firewall, click on the Allow a program or feature through Windows Firewall link.

  3. In the Allowed apps (programs) and features: list, you may see that "MS SQL Server" is listed, but it may not be selected. If necessary, mark the check box.

    Alternatively, if "MS SQL Server" is not listed, do the following:

    1. Click the Allow another program or Change settings button.

    2. Click Browse... or Allow another app... button.

    3. Browse to (for example):

      drive:\Program Files\Microsoft SQL Server\MSSQL12.PDXPERT\MSSQL\Binn\

    4. Select the file sqlservr.exe and click the Open button to add to the list of exceptions.

To enable the firewall exception in Windows XP or Vista:

  1. Click Start, click Control Panel, and then open Security Center.

  2. Near the bottom of the window (XP) or along the left side (Vista), click Windows Firewall. In Vista, then click on the Allow a program through Windows Firewall link.

  3. On the Exceptions tab, in the Programs and Services list, you will probably see that "MS SQL Server" is listed, but it may not be selected as an exception. Mark the check box to enable the 1433 port for TCP requests.

    Alternatively, if "MS SQL Server" is not listed, do the following:

    1. Click Add Program.

    2. Click Browse.

    3. Navigate to (n is a numbered folder, usually 1, with today's date):

      drive:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\BINN

    4. Select the file sqlservr.exe and click the Open button to add to the list of exceptions.

Is your anti-virus software allowing communications?

To determine if your AV software is blocking SQL/PDXpert communications, disable it entirely. Test whether the system is now working and, if so, determine from your AV supplier how to enable communications between SQL Server and the PDXpert server and between the PDXpert server and client applications.

Is the SQL Server database on a compressed volume?

Microsoft SQL Server cannot be installed on a compressed volume. Use an uncompressed volume instead. See support.microsoft.com/kb/231347/en-us

If you see any of the following errors, you may have installed a new database, or moved or restored an existing database, onto a compressed disk volume:

  • CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 5118)
  • System.Data.SqlClient.SqlException (0x80131904) The file "[path]\PDXpertDB.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
  • Create failed for Database 'PDXpertDB'. (Microsoft.SqlServer.Smo) An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
  • Restore failed for Server '<servername>'. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: The file "[path]\PDXpertDB.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. (Microsoft.SqlServer.Smo)
  • Database 'PDXpertDB' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945)

If your Windows Explorer shows folder or files names in blue rather than black, then these are compressed.

Compressed folders in Windows Explorer

If you've attempted to install into a compressed location: Uninstall the PDXpert server and SQL Server, uncompress the installation location, and then run the PDXpert installer. When uncompressing the installation location, ensure that all subfolders and files are uncompressed.

Advanced attributes for uncompressing folders

Is the SQL Server Browser service exposed?

The SQL Server Browser service lets users connect to instances of the SQL Server database engine that are not listening on port 1433 (which may occur, for example, if another named SQL Server instance has been previously installed). Depending on your Windows configuration, you may need to open UDP port 1434 to expose the SQL Server Browser service.

Using the same general approach as described immediately above:

  1. Click Start, click Control Panel, and then open Security Center.

  2. Near the bottom of the window (XP) or along the left side (Win7/Vista), click Windows Firewall. In Windows 7, click on the Advanced Settings link. In Vista, then click on the Allow a program through Windows Firewall link.

  3. For Windows 7. In the Windows Firewall with Advanced Security window

    1. In the left panel, click on Inbound Rules, and on the right Actions panel, click on the New Rule...

    2. Select Port as the Rule Type. Click Next.

    3. Apply the rule to UDP and specify the local port as 1434. Click Next.

    4. Set the action to Allow the connection. Click Next.

    5. Enable the appropriate profiles. Click Next.

    6. Type SQL Server Browser in the Name text box, and click Finish.

    7. Repeat these steps for the left panel Outbound Rules.

    For Windows XP and Vista. On the Exceptions tab, in the Programs and Services list:

    1. You may see that SQL Server Browser is already listed, but it may not be selected as an exception. Mark the check box to enable the 1434 port for UDP requests.

    2. More likely you will not see any reference to SQL Server Browser. In this case, click Add Port, type SQL Server Browser in the Name text box, type 1434 in the Port Number text box, select UDP, and then click OK.

Is "SQL Server (PDXPERT)" missing from the Services panel?

If "SQL Server (PDXPERT)" is not listed in the Services panel, or you suspect that the installation is not correct, you should reinstall Microsoft SQL Server.

  1. Try to remove Microsoft SQL Server by opening to Windows Start menu, selecting the Control Panel, then Add or Remove Programs. If the list shows "Microsoft SQL Server" then click on the Remove button. When you're asked for an instance, select "PDXPERT: Database Engine". Follow any other instructions on the uninstaller program.
  2. Run the PDXpert system installer again, and reboot the computer.

If the PDXpert Application Server service still cannot be started because there are errors in communication with Microsoft SQL Server, send to us the available Microsoft SQL Server log file(s).

Learn More
Install Guide Contents