(localdb) support?

[sant123]

Hi, is there any support to connect to a localdb SQL Server instance? I have tried:

var config = {
    server: 'localhost\\ProjectsV12'
};

var config = {
    server: '(localdb)\\ProjectsV12'
}

var config = {
    server: '(localdb)',
    options: {
         instanceName : "ProjectsV12"
    }
}

None of them work 😞

Thank you!

[tracker1]

You need to configure your local sql to support socket connections, I don't have access to a windows machine with sql at work or I'd give more detailed instructions on adjusting that setting, you should be able to do it via the sql configuration app. You'll want to configure your firewall to only allow local connections to SQL. Also, apparently UDP port 1444 is apparently used for establishing an instance connection (in addition to tcp 1433).

iirc that's the only interface supported by tedious, then you can connect via tcp to localhost.

var config = {
    server: 'localhost',
    options: {
         instanceName : "ProjectsV12"
    }
}

[sant123]

Hi @tracker1, thanks for your answer. I just realized is possible to connect to this DB server using C#. Why is it not the same in Node.js? That's the part I do not get, I read this issue tediousjs/tedious#348 and it seems Tedious does not support a connection with named pipes. Is there a way to implement it? Why can I make connections with other named servers and not this? It'd be helpful your answer.

Thanks.

[pedropedro0325]

Hi, @sant123, did you find a solution for connecting with node to a LocalDB instance?

[sant123]

Hi @pedropedro0325, unfortunately I could'nt do it 😢. What I did is install SQL Server as a service and then connect to it. It seems for now localdb is not going to be supported.

[armand1m]

:(

[dhensby]

this looks to be a driver issue and not for us to solve.