search

RADar-AZDelta / Rabbit-in-a-Blender

An ETL pipeline to transform your EMP data to OMOP.
https://radar-azdelta.github.io/Rabbit-in-a-Blender/
GNU General Public License v3.0
11 stars 3 forks source link

SQL Server: can't connect to named instance with RiaB #91

Open rgoesseye opened 1 month ago

rgoesseye commented 1 month ago

When using a named instance I can't connect to the database server in RiaB, this could be due to using a python module in RiaB which doesn't support named instances connections.

riab_instance_sql_no_conn

In the image above you can see the error that RiaB gives about being unable to connect. I tried different ways to write the server and the named instance -> (server//named_instance, server/named_instance, server\named_instance, ...) but it didn't work.

JensCardon commented 1 month ago

Riab connects to the database server using a sql authentication connection string, I don't think named instances are supported.

pjlammertyn commented 2 weeks ago

This seems to be an issue with the pymssql package.

My tests confirm this: image

pjlammertyn commented 2 weeks ago

A possible solution could be not setting the port, when it is a named instance. The downside for this, is that named instances can only sit on port 1433.