Unable to connect to the specified database using the provided settings.


Version: R69.1

Article ID: PE000086

Unable to connect to the specified database using the provided settings.main image

Description

New Default instances of SQL Server have TCP/IP disabled by default. When connecting PaperVision Enterprise to an instance of SQL Server using TCP/IP you must enable this function within SQL Server.

Summary

Enabling TCP/IP within SQL Server will allow you to connect PaperVision Enterprise using TCP/IP.

To resolve this follow the steps below:

  1. Open the SQL Server Configuration Manager and select Protocols for <Server Name> | TCP/IP | Properties.
  2. On the Protocol tab choose Yes for the Enabled property.
  3. Select OK and be sure to restart the service so that the changes take effect.

Note: If you are using a Named Instance of SQL Server (the default named instance for SQL Express is “<Server Name>/SQLExpress”) rather than a Default Instance, the TCP Port will be blank by default.

To specify the TCP Port, open the SQL Server Configuration Manager and select Protocols for <Server Name> | TCP/IP | Properties. On the IP Addresses tab specify the TCP Port number in the IP All section | TCP Port property. Be sure to select a port number not already in use on that system. Select OK and be sure to restart the service so that the changes take effect.