Azure Data Studio Cannot Connect to SQL Server Browser. Ensure SQL Browser has been started

Asked Apr 06 '20 at 21:18

Active Apr 06 '20 at 22:52

Viewed 2,116 times

Context: On my Windows 10 workstation I've recently installed Ubuntu via VirtualBox. Within Ubuntu, I've installed Azure Data Studio and I am trying to connect ADS to the SQL Server instance I have installed locally (on Windows). I'm getting this error:

Cannot Connect to SQL Server Browser. Ensure SQL Browser has been started.

At first I thought this meant the SQL Server browser wasn't running, but when I check Services.msc I see clearly it is running.

I've also enabled TCP connections in the SQL Server Config manager as suggested here: Unable to connect to SQL Server from Virtualbox

Questions: Can someone please help me understand why this is happening and how I can fix it? Below is how I'm trying to connect ADS in Ubunutu to my local SQL Server instance on Windows.

edited Apr 06 '20 at 22:52

asked Apr 06 '20 at 21:18

emalcolmb

1,585
4
18
43

I assume SQL server is a named instance? Make sure UDP port 1434 is reachable from the Ubuntu machine. You could specify a port number instead of instance name to avoid the need for the browser service. – Dan Guzman Apr 06 '20 at 21:52
I tried that and its not working. – emalcolmb Apr 06 '20 at 22:08
Could you edit your question to show how you're connecting from ADS? Trying to connect to 127.0.0.1, for example, won't work because that's internal to the Ubuntu guest. – AlwaysLearning Apr 06 '20 at 22:25
Edited the question – emalcolmb Apr 06 '20 at 22:39

Azure Data Studio Cannot Connect to SQL Server Browser. Ensure SQL Browser has been started

0 Answers0