I have been writing a few python scripts using pyodbc. So far, its been fine…until I tried this server thats using a named instance. Windows 10 workstation to Windows 2019 server and SQL 2019
connStr = 'Driver={ODBC Driver 17 for SQL Server};Server=MyServerHere\InstanceName;Database=MyDb;Trusted_Connection=True;'
print(connStr)
conn = odbc.connect(connStr)
This fails
However:
I can connect with SSMS from my workstation, as Im a local admin on the server Im connecting to
I can not create a system or user DSN using the ODBC Driver 17 from my PC. When I get to the end of configuring it and try to test, I get a very similar error as when using Python.
I see nothing in the SQL logs
What can I check?