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 Power Pick 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:

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port

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:

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/timeout-expired-error?source=recommendations#typical-causes-and-resolutions-for-the-error

Typical issues include:

Incorrect port of the SQL database
Permission issues for the SQL user
SQL server is set up for Windows authentication, not SQL user

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.

Book a Sales Demo

Power Pick Connections

How do I set up the Power Pick 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 Power Pick.This is something your network team will need to set ...

Power Pick Connections

How do I fix a 504 error saying "The connection to an upstream server timed out"?

You can check your Power Pick 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 ...