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:
- Open the SQL Server Configuration Manager and select Protocols for <Server Name> | TCP/IP | Properties.
- On the Protocol tab choose Yes for the Enabled property.
- 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.