{"action":"created","issue":{"url":"https://api.github.com/repos/rickbergfalk/sqlpad/issues/70","labels_url":"https://api.github.com/repos/rickbergfalk/sqlpad/issues/70/labels{/name}","comments_url":"https://api.github.com/repos/rickbergfalk/sqlpad/issues/70/comments","events_url":"https://api.github.com/repos/rickbergfalk/sqlpad/issues/70/events","html_url":"https://github.com/rickbergfalk/sqlpad/issues/70","id":122986735,"number":70,"title":"MS SQL connection with named instance and specific port","user":{"login":"chandrabe","id":1850080,"avatar_url":"https://avatars.githubusercontent.com/u/1850080?v=3","gravatar_id":"","url":"https://api.github.com/users/chandrabe","html_url":"https://github.com/chandrabe","followers_url":"https://api.github.com/users/chandrabe/followers","following_url":"https://api.github.com/users/chandrabe/following{/other_user}","gists_url":"https://api.github.com/users/chandrabe/gists{/gist_id}","starred_url":"https://api.github.com/users/chandrabe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chandrabe/subscriptions","organizations_url":"https://api.github.com/users/chandrabe/orgs","repos_url":"https://api.github.com/users/chandrabe/repos","events_url":"https://api.github.com/users/chandrabe/events{/privacy}","received_events_url":"https://api.github.com/users/chandrabe/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-12-18T16:57:22Z","updated_at":"2015-12-18T17:17:47Z","closed_at":null,"body":"Hello,\r\n\r\nHow can I connect to a MS SQL Server using a named instance and a specific port ?\r\n\r\nI tried to pass the instance name in the server field as servername\\instance and the port in the port field but with no success.\r\n\r\nI saw in the Tedious driver documentation that instance and port option where mutually exclusive.\r\nDo this means this is a no go ?\r\n\r\nRegards\r\nOlivier"},"comment":{"url":"https://api.github.com/repos/rickbergfalk/sqlpad/issues/comments/165844710","html_url":"https://github.com/rickbergfalk/sqlpad/issues/70#issuecomment-165844710","issue_url":"https://api.github.com/repos/rickbergfalk/sqlpad/issues/70","id":165844710,"user":{"login":"rickbergfalk","id":303966,"avatar_url":"https://avatars.githubusercontent.com/u/303966?v=3","gravatar_id":"","url":"https://api.github.com/users/rickbergfalk","html_url":"https://github.com/rickbergfalk","followers_url":"https://api.github.com/users/rickbergfalk/followers","following_url":"https://api.github.com/users/rickbergfalk/following{/other_user}","gists_url":"https://api.github.com/users/rickbergfalk/gists{/gist_id}","starred_url":"https://api.github.com/users/rickbergfalk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rickbergfalk/subscriptions","organizations_url":"https://api.github.com/users/rickbergfalk/orgs","repos_url":"https://api.github.com/users/rickbergfalk/repos","events_url":"https://api.github.com/users/rickbergfalk/events{/privacy}","received_events_url":"https://api.github.com/users/rickbergfalk/received_events","type":"User","site_admin":false},"created_at":"2015-12-18T17:17:47Z","updated_at":"2015-12-18T17:17:47Z","body":"Hi @chandrabe \r\n\r\nInteresting. Which port are you using?\r\n\r\nI did some quick research and according to the node-mssql module, it looks like port 1444 runs the SQL Server Browser service, so that must be how it manages connections to different instances? I had no idea...\r\n\r\nCould you try connecting with servername\\instance in the server field and manually setting port to 1444? \r\n\r\nIf that doesn't help I'll have to do some experimenting with the way SQL Server connections are handled."}}