-
Support
- How do I set up the Power Pick database (SQL Server) to accept remote connections via IP?
Business
-
Account & Licensing
-
Installing & Updating
-
Power Pick Connections
-
Data Push & Data Pull
-
API
-
Reports
-
Snapshots & Dashboard
-
Workflows
How do I set up the Power Pick database (SQL Server) to accept remote connections via IP?
Setting up SQL Server to accept remote connections via TCP/IP is a requirement for ItemPath to connect to Power Pick (if your Power Pick database is hosted using Microsoft's SQL Server).
This is something your network team will need to set up for you using SQL Server Configuration Manager. By default, the SQL Server Database Engine listens on TCP port 1433, so be sure to make a note if the port number is changed.
For details on how to set this up, visit the SQL Server documentation:
- To open SQL Server Configuration Manager: https://learn.microsoft.com/en-us/sql/tools/configuration-manager/sql-server-configuration-manager
- To configure the server to listen on a specific port: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port