Issue with connecting to SQL Server 2017 for Linux
I have installed SQL Server 2017 on Linux Ubuntu together with SQL Command Line Tools.
Instantly after setting up and normal configuration I am unable to connect to it using the command line tools.
I am getting the following error:
How can I fix this issue?
sql-server linux asked Nov 11 at 7:41
Alex
174211
add a comment |
I have installed SQL Server 2017 on Linux Ubuntu together with SQL Command Line Tools.
Instantly after setting up and normal configuration I am unable to connect to it using the command line tools.
I am getting the following error:
How can I fix this issue?
sql-server linux asked Nov 11 at 7:41
Alex
174211
add a comment |
I have installed SQL Server 2017 on Linux Ubuntu together with SQL Command Line Tools.
Instantly after setting up and normal configuration I am unable to connect to it using the command line tools.
I am getting the following error:
How can I fix this issue?
sql-server linux asked Nov 11 at 7:41
Alex
174211
I have installed SQL Server 2017 on Linux Ubuntu together with SQL Command Line Tools.
Instantly after setting up and normal configuration I am unable to connect to it using the command line tools.
I am getting the following error:
How can I fix this issue?
sql-server linux sql-server linux asked Nov 11 at 7:41
Alex
174211
asked Nov 11 at 7:41
Alex
174211
asked Nov 11 at 7:41
Alex
174211
asked Nov 11 at 7:41
Alex
174211
asked Nov 11 at 7:41
Alex
174211
174211
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
I finally managed to fix the issue by reinstalling the SQL Server 2017 on my Debian machine.
Microsoft instructions are for Ubuntu not Debian but the only error I was getting on Debian was about OpenSSL which I solved it using the following answer:
https://askubuntu.com/questions/930712/installation-problems-with-ms-sql-server-for-linux
Now it works perfectly on my Debian machine.
answered 4 hours ago
Alex
174211
add a comment |
Look here:
Configure a Windows Firewall for Database Engine Access
Configure a Server to Listen on a Specific TCP Port
Specifically:
Can not connect to MS SQL from Ubuntu sqlcmd
client
The fix for letting the Ubuntu client connect was to set "Listen to
All" to No in the SQL Server Configuration Manager > SQL Server
Network Configuration > Protocols for [instance name]. And under IP
Address change 127.0.0.1 to the [ip] used to connect. Don't forget to
restart the SQL Server!
Other tip: check your firewall (or temporaly disable it for testing).
Also allow remote connections in SQL Server properties > Connections.
See above posts.
answered Nov 11 at 7:56
paulsm4
76.8k999126
My SQL Server is on Linux not the client. I am using SQL Server 2017 for Linux and it doesn't allow me to connect to it due to the mentioned error.
– Alex
Dec 9 at 18:52
OK: look here: github.com/Microsoft/msphpsql/issues/252. It appears to be the same Error 0x2746, the problem was TLS 1.2 support. The workaround was to use a different driver (Sybase driver, instead of MSSQL). See also Troubleshoot SQL Server on Linux
– paulsm4
Dec 9 at 19:01
Thanks for that. Seems that I can connect using JDBC. Is there anyway we can make other apps working without using JDBC? Such as Azure Data Studio. ?
– Alex
Dec 18 at 6:11
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53246761%2fissue-with-connecting-to-sql-server-2017-for-linux%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
I finally managed to fix the issue by reinstalling the SQL Server 2017 on my Debian machine.
Microsoft instructions are for Ubuntu not Debian but the only error I was getting on Debian was about OpenSSL which I solved it using the following answer:
https://askubuntu.com/questions/930712/installation-problems-with-ms-sql-server-for-linux
Now it works perfectly on my Debian machine.
answered 4 hours ago
Alex
174211
add a comment |
I finally managed to fix the issue by reinstalling the SQL Server 2017 on my Debian machine.
Microsoft instructions are for Ubuntu not Debian but the only error I was getting on Debian was about OpenSSL which I solved it using the following answer:
https://askubuntu.com/questions/930712/installation-problems-with-ms-sql-server-for-linux
Now it works perfectly on my Debian machine.
answered 4 hours ago
Alex
174211
add a comment |
I finally managed to fix the issue by reinstalling the SQL Server 2017 on my Debian machine.
Microsoft instructions are for Ubuntu not Debian but the only error I was getting on Debian was about OpenSSL which I solved it using the following answer:
https://askubuntu.com/questions/930712/installation-problems-with-ms-sql-server-for-linux
Now it works perfectly on my Debian machine.
answered 4 hours ago
Alex
174211
I finally managed to fix the issue by reinstalling the SQL Server 2017 on my Debian machine.
Microsoft instructions are for Ubuntu not Debian but the only error I was getting on Debian was about OpenSSL which I solved it using the following answer:
https://askubuntu.com/questions/930712/installation-problems-with-ms-sql-server-for-linux
Now it works perfectly on my Debian machine.
answered 4 hours ago
Alex
174211
answered 4 hours ago
Alex
174211
answered 4 hours ago
Alex
174211
answered 4 hours ago
Alex
174211
174211
add a comment |
add a comment |
Look here:
Configure a Windows Firewall for Database Engine Access
Configure a Server to Listen on a Specific TCP Port
Specifically:
Can not connect to MS SQL from Ubuntu sqlcmd
client
The fix for letting the Ubuntu client connect was to set "Listen to
All" to No in the SQL Server Configuration Manager > SQL Server
Network Configuration > Protocols for [instance name]. And under IP
Address change 127.0.0.1 to the [ip] used to connect. Don't forget to
restart the SQL Server!
Other tip: check your firewall (or temporaly disable it for testing).
Also allow remote connections in SQL Server properties > Connections.
See above posts.
answered Nov 11 at 7:56
paulsm4
76.8k999126
My SQL Server is on Linux not the client. I am using SQL Server 2017 for Linux and it doesn't allow me to connect to it due to the mentioned error.
– Alex
Dec 9 at 18:52
OK: look here: github.com/Microsoft/msphpsql/issues/252. It appears to be the same Error 0x2746, the problem was TLS 1.2 support. The workaround was to use a different driver (Sybase driver, instead of MSSQL). See also Troubleshoot SQL Server on Linux
– paulsm4
Dec 9 at 19:01
Thanks for that. Seems that I can connect using JDBC. Is there anyway we can make other apps working without using JDBC? Such as Azure Data Studio. ?
– Alex
Dec 18 at 6:11
add a comment |
Look here:
Configure a Windows Firewall for Database Engine Access
Configure a Server to Listen on a Specific TCP Port
Specifically:
Can not connect to MS SQL from Ubuntu sqlcmd
client
The fix for letting the Ubuntu client connect was to set "Listen to
All" to No in the SQL Server Configuration Manager > SQL Server
Network Configuration > Protocols for [instance name]. And under IP
Address change 127.0.0.1 to the [ip] used to connect. Don't forget to
restart the SQL Server!
Other tip: check your firewall (or temporaly disable it for testing).
Also allow remote connections in SQL Server properties > Connections.
See above posts.
answered Nov 11 at 7:56
paulsm4
76.8k999126
My SQL Server is on Linux not the client. I am using SQL Server 2017 for Linux and it doesn't allow me to connect to it due to the mentioned error.
– Alex
Dec 9 at 18:52
OK: look here: github.com/Microsoft/msphpsql/issues/252. It appears to be the same Error 0x2746, the problem was TLS 1.2 support. The workaround was to use a different driver (Sybase driver, instead of MSSQL). See also Troubleshoot SQL Server on Linux
– paulsm4
Dec 9 at 19:01
Thanks for that. Seems that I can connect using JDBC. Is there anyway we can make other apps working without using JDBC? Such as Azure Data Studio. ?
– Alex
Dec 18 at 6:11
add a comment |
Look here:
Configure a Windows Firewall for Database Engine Access
Configure a Server to Listen on a Specific TCP Port
Specifically:
Can not connect to MS SQL from Ubuntu sqlcmd
client
The fix for letting the Ubuntu client connect was to set "Listen to
All" to No in the SQL Server Configuration Manager > SQL Server
Network Configuration > Protocols for [instance name]. And under IP
Address change 127.0.0.1 to the [ip] used to connect. Don't forget to
restart the SQL Server!
Other tip: check your firewall (or temporaly disable it for testing).
Also allow remote connections in SQL Server properties > Connections.
See above posts.
answered Nov 11 at 7:56
paulsm4
76.8k999126
Look here:
Configure a Windows Firewall for Database Engine Access
Configure a Server to Listen on a Specific TCP Port
Specifically:
Can not connect to MS SQL from Ubuntu sqlcmd
client
The fix for letting the Ubuntu client connect was to set "Listen to
All" to No in the SQL Server Configuration Manager > SQL Server
Network Configuration > Protocols for [instance name]. And under IP
Address change 127.0.0.1 to the [ip] used to connect. Don't forget to
restart the SQL Server!
Other tip: check your firewall (or temporaly disable it for testing).
Also allow remote connections in SQL Server properties > Connections.
See above posts.
answered Nov 11 at 7:56
paulsm4
76.8k999126
answered Nov 11 at 7:56
paulsm4
76.8k999126
answered Nov 11 at 7:56
paulsm4
76.8k999126
answered Nov 11 at 7:56
paulsm4
76.8k999126
76.8k999126
My SQL Server is on Linux not the client. I am using SQL Server 2017 for Linux and it doesn't allow me to connect to it due to the mentioned error.
– Alex
Dec 9 at 18:52
OK: look here: github.com/Microsoft/msphpsql/issues/252. It appears to be the same Error 0x2746, the problem was TLS 1.2 support. The workaround was to use a different driver (Sybase driver, instead of MSSQL). See also Troubleshoot SQL Server on Linux
– paulsm4
Dec 9 at 19:01
Thanks for that. Seems that I can connect using JDBC. Is there anyway we can make other apps working without using JDBC? Such as Azure Data Studio. ?
– Alex
Dec 18 at 6:11
add a comment |
My SQL Server is on Linux not the client. I am using SQL Server 2017 for Linux and it doesn't allow me to connect to it due to the mentioned error.
– Alex
Dec 9 at 18:52
OK: look here: github.com/Microsoft/msphpsql/issues/252. It appears to be the same Error 0x2746, the problem was TLS 1.2 support. The workaround was to use a different driver (Sybase driver, instead of MSSQL). See also Troubleshoot SQL Server on Linux
– paulsm4
Dec 9 at 19:01
Thanks for that. Seems that I can connect using JDBC. Is there anyway we can make other apps working without using JDBC? Such as Azure Data Studio. ?
– Alex
Dec 18 at 6:11
My SQL Server is on Linux not the client. I am using SQL Server 2017 for Linux and it doesn't allow me to connect to it due to the mentioned error.
– Alex
Dec 9 at 18:52
My SQL Server is on Linux not the client. I am using SQL Server 2017 for Linux and it doesn't allow me to connect to it due to the mentioned error.
– Alex
Dec 9 at 18:52
OK: look here: github.com/Microsoft/msphpsql/issues/252. It appears to be the same Error 0x2746, the problem was TLS 1.2 support. The workaround was to use a different driver (Sybase driver, instead of MSSQL). See also Troubleshoot SQL Server on Linux
– paulsm4
Dec 9 at 19:01
OK: look here: github.com/Microsoft/msphpsql/issues/252. It appears to be the same Error 0x2746, the problem was TLS 1.2 support. The workaround was to use a different driver (Sybase driver, instead of MSSQL). See also Troubleshoot SQL Server on Linux
– paulsm4
Dec 9 at 19:01
Thanks for that. Seems that I can connect using JDBC. Is there anyway we can make other apps working without using JDBC? Such as Azure Data Studio. ?
– Alex
Dec 18 at 6:11
Thanks for that. Seems that I can connect using JDBC. Is there anyway we can make other apps working without using JDBC? Such as Azure Data Studio. ?
– Alex
Dec 18 at 6:11
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53246761%2fissue-with-connecting-to-sql-server-2017-for-linux%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
