Skip to content

Problem when connecting with SSMS #159

Open
@rafales

Description

@rafales

So I wrote a simple SQL Server Browser which works with docker to discover mssql-server-linux instances which have port bind to the host interface.

SSMS is able to connect to the instance with port provided (10.50.3.203,32777) without a problem.

When connecting with instance name (10.50.3.203\elo) it is able to properly translate instance name to connection params (this is what my server sends: ServerName;10.50.3.203;InstanceName;elo;IsClustered;No;Version;14.0.900.75;tcp;32777).

SSMS then establishes connection to 10.50.3.203:32777 and starts pre-login but it fails for some reason and results in cryptic Instance failure. (System.Data) error.

There is nothing in the server log happening at the time of the attempted login.

I attach a dump of the connection from wireshark.
sqlserver-linux-conn.pcapng.zip

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions