1. Support arrow-right
  2. Why am I getting an error from my MSSQL connection?

Why am I getting an error from my MSSQL connection?

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