search

KarnerTh / mermerd

Create Mermaid-Js ERD diagrams from existing tables
MIT License
460 stars 35 forks source link

MSSQL with a named instance #38

Closed MarkEwer closed 1 week ago

MarkEwer commented 1 year ago

I'm trying out this tool to hook it into our documentation system but I ran into a snag. My MSSQL server uses a Named Instance that is not the default. I can't quite figure out how to put that instance name in the connection string?

Is this an unsupported scenario?

KarnerTh commented 1 year ago

Sry for the late response

I am not an expert regarding MSSQL, but according to the docs it should work like that sqlserver://username:password@host/instance?param1=value&param2=value (Source here)

Have you tried to add the instance name after the host?

KarnerTh commented 1 year ago

Any update on the issue? Does it work now?

MarkEwer commented 1 year ago

Not for me.

RafBorrelli commented 2 months ago

I managed to get it working. This is the pattern I'm using for Windows Authentication: sqlserver://[SERVER NAME]/[INSTANCE NAME]?Database=[DATABASE NAME]&Trusted_Connection=True&TrustServerCertificate=True

For example, assuming this parameters:

The connection string will be: sqlserver://DBServer.local/INSTANCE_TEST?Database=DB_Test&Trusted_Connection=True&TrustServerCertificate=True

KarnerTh commented 1 week ago

Close this for now - if anyone still has issues feel free to reopen