Instance Names not supported

[thewilli]

I can connect to the server "myServer", but a connection to a named server instance (e.g. "myServer\SQLExpress") results in a "connection failed" error.

[pekim]

It looks like the ports for all instances can be obtained with a UDP request to port 1434. This relies on SQL Server Browser running. If it's not, the port for an instance name will not be obtainable.

I will probably implement the lookup at the weekend.

A workaround, until the lookup is implemented, is to configure the instances to run on specific ports and connect based on the port instead of an instance name.

[pekim]

I'm afraid that I've been working on #16 this weekend, and haven't had a chance to work on this yet.

[pekim]

This is now supported.

The documentation has not been updated yet, but the gist of the changes are that in config.options either port or instanceName (but not both) may be specified.

So instead of something like this

var config = {
    userName: 'test',
    password: 'test',
    server: 'hostname',
    options: {
        port: 1433
    }
};

you can use something like this

var config = {
    userName: 'test',
    password: 'test',
    server: 'hostname',
    options: {
        instanceName: 'MYINSTANCENAME'
    }
};

[pekim]

Documentation updated.

[pekim]

Included in v0.0.4.

[jpolvora]

How connect with Integrated Secuirity = true? I mean no username and no password (windows authentication)

[pekim]

Tedious does not support Windows authentication (#68 (comment)).