We’ve encountered this error attached . Please help.
were you able to connect before?
with the same version of pymedphys?
the one thing that can probably be ruled out is “wrong credentials” because that is supposed to provide a different error.
Does a dnslookup of MOSAIQSQL return an appropriate IP address (to the MOSAIQ SQL Server)?
We are using version 0.37.1. It was working before tech refresh with SQL 2008. We are now using SQL 2019.
The nslookup to the host name gives a correct ip address with 2 second timed out. In the config csv file , both hostname and ip address gives same results.
Any suggestions? Thank you.
let’s step back a bit.
How about confirming the ability to connect:
The example from Microsoft shows:
conn = pymssql.connect(server=‘yourserver.database.windows.net’, user=‘yourusername@yourserver’, password=‘yourpassword’, database=‘AdventureWorks’)
so… substitute accordingly (start python from the command line), and see if you get a connection or not.
That way we separate pymedphys code from the pymssql code, and from the content of the parameters to pymssql.connect(…).
Is it possible that your SQL Server got hosted on a different IP address?
We deleted the user and recreated it as db_reader with login to database permission. It’s now working.
The db_reader no longer valid as we moved from old SQL 2008 to SQL 2019.
Thank you so much @sjswerdloff for all of your help on these forums while I was away!