[MSSQL] Unable to connect MsSql named instance

nocodb / nocodb

🔥 🔥 🔥 Open Source Airtable Alternative

https://nocodb.com

GNU Affero General Public License v3.0

49.83k stars 3.41k forks source link

[MSSQL] Unable to connect MsSql named instance #597

Open seb49 opened 3 years ago

seb49 commented 3 years ago

Hello,

I can't connect to a MSSQL named instance

NocoDB used as docker : false NocoDB version : 0.11.40 Database used in NC_DB URL : mssql Project was created by clicking : New Project by connecting to external database Database on which spreadsheet is created : mssql OS on which NocoDB is running : Windows 10 Node.js version if running as node : 14.5.4 Database version : Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64)

Screenshots

o1lab commented 3 years ago

We 're using knexjs to connect to mssql.

Can you help us to understand how knexjs connects to named instances

Here is an issue that might help : https://github.com/tediousjs/node-mssql/issues/155

rreagandr commented 2 years ago

I had this issue using the Node Application setup (setup by cloning https://github.com/nocodb/nocodb-seed) on Windows 10 with a named instance. I resolved it by starting the SQL Server Browser service.

sqlbrowser

Found this from some discussion here: https://github.com/tediousjs/node-mssql/issues/155

nikhilbkolhe commented 2 years ago

Hii I would like to work on this issue. Can you assign it to me

nick2432 commented 1 year ago

can i work on this?

manya-m commented 1 month ago

I want to work on this. Could you please assign it to me?