MSSQL LocalDB with Tedious / TDS

Question

does anybody know how to configure Tedious (https://github.com/pekim/tedious) to connect against a Microsoft SQL EXPRESS LocalDB? I don't get it to work.

Since Tedious uses the TDS protocol, I guess the question needs to be: does MSSQL LocalDB support TDS?

thanks a lot Juergen

Searching for JDBC for LocalDB, I found that LocalDB only supports Named Pipes (and no Ports). However since jTDS supports LocalDB via Named Pipes, it's obviously not a limitation of the TD protocol. If Tedious supports Named Pipes, it should word. But I don't know yet whether it does or not. — Juergen, Jun 06 '15 at 16:16

score 1 · Answer 1 · answered Dec 07 '15 at 01:31

To answer your question, no. From reading a bit on the specification, it is a "used to transfer data between a database server and a client". My gut says localdb doesn't use this same protocol. I've opened an issue on GitHub just to verify.

https://github.com/pekim/tedious/issues/348

score -1 · Answer 2 · edited Feb 21 '21 at 04:44

server = 'localhost' (tedious doesn't like windows strings)
INSTANCENAME = 'SQLEXPRESS' (OR can put port in)
SQL Server Browser must be running

var config = {  
      server: 'localhost',  

  authentication: {
          type: 'default',
          options: {
              userName: 'itsME',
              password: 'SecreStuff'
          }
      },
      options: {
        
          instanceName: 'SQLEXPRESS',
          encrypt: false,
          database: 'pilotChecks'
      }

MSSQL LocalDB with Tedious / TDS

2 Answers2