- Support
- Why am I getting an error from my MSSQL connection?
-
Account & Licensing
-
Installing & Updating
-
PowerPick Connections
-
Data Push & Data Pull
-
API
-
Reports
-
Snapshots & Dashboard
-
Workflows
Why am I getting an error from my MSSQL connection?
Issue:
MSSQL connection is failing or getting a "Login timeout" message.
Resolution:
Check TCP/IP ports and network protocols.
If you're unable to connect to your PowerPick SQL Server, check that the server is set up to accept remote connections via IP. For more details on how to set this up, visit the SQL server documentation:
If the error you're getting has a "Login timeout" message, take a look at this article from Microsoft about common causes and resolutions for this error:
Resources
To learn more about ItemPath and see it in action, please book a demo with our sales team. In the meantime, here are some of our popular articles and key topics.
PowerPick Connections
How do I set up the PowerPick SQL server to accept remote connections via IP?
Setting up the SQL server to accept remote connections via IP is a requirement for ItemPath to connect to PowerPick. This is something your network team will need to set up ...
PowerPick Connections
Connecting to Power Pick
ItemPath connects to Power Pick in two ways: with the rule engine, and directly to the MSSQL server. Pictured below is the technical overview of these connections and ports. ...
PowerPick Connections
How do I fix a 504 error saying "The connection to an upstream server timed out"?
You can check your PowerPick connections' configuration details in ItemPath's settings, in the Kardex tab. Testing the connection will confirm which connections are failing (the MSSQL server and/or the CEU ...