Share via

Unable to connect to external database from sql server python script-Python Services

Anonymous
2023-01-27T13:28:06+00:00

Trying to connect to an external database using python in an SQL stored procedure but seems like sqlalchemy is unable to connect to the external database. But we i run the script outside SQL server(SSMS) it works perfectly.

I have granted app containers and the launchpad account full rights and disabled outbound firewall rules but it is still failing.

It returns an error: [WinError 10013] An attempt was made to access a socket in a way forbidden by its access permissions'))

Which other permissions do have to grant for it to work.

I am using windows server 2022, sql server 2019

Thanks.

Windows for home | Other | Performance and system failures

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2023-01-27T13:43:13+00:00

    Your question is outside the scope of this Community.

    The following forum(s) have migrated to Microsoft Q&A: All English SQL Server forums!
    Visit Microsoft Q&A to post new questions.

    https://docs.microsoft.com/en-us/answers/products/sql-server

    The following forum(s) have migrated to Microsoft Q&A: All English Windows Server forums!
    Visit Microsoft Q&A to post new questions.

    https://docs.microsoft.com/en-us/answers/products/windows

    Windows Server General

    Was this answer helpful?

    0 comments No comments