Avatar of gwarcher
gwarcher asked on

Visual Studios and SQL "A connection cannot be made. Ensure that the server is running"

I am starting the process of learning how to use dimensions and cubes in VS. I have created a dimension and when I try to browse it I get the error "A connection cannot be made. Ensure the server is running.

I am connecting to a server via LAN and using sql authentication. The SQL browser service on the server is running.

Any advice?
Microsoft SQL Server

Avatar of undefined
Last Comment
gwarcher

8/22/2022 - Mon
Abhigyan Srivastava

Can you connect to the server in "Server Explorer" of Visual Studio?
ASKER
gwarcher

I can explore the table in the data source view. Is that what you are referring to?
ASKER
gwarcher

More information:  The additional information is "No connection could be made because the target machine actively refused it 127.0.0.1:2383

No idea why it is showing a loopback ip there.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Abhigyan Srivastava

There would be another tab just below Data Source View which is Server Explorer. I am talking about that.
Abhigyan Srivastava

Hmm. Can you share a screenshot.
Abhigyan Srivastava

Also is SQL configured to connect to 2383 port?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
gwarcher

Screenshot of vs error
ASKER
gwarcher

telnet check seems to be coming back ok.
ASKER
gwarcher

netstat comes back as listening on 0.0.0.0.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Abhigyan Srivastava

That's OK but is SQL Server listening on it.

Open SQL Server Configuration Manager.

Goto SQL Native Configuration >>  Client Protocols >> TCP/IP

Right Click and select Properties.

In that change the default port to 2383 and restart SQL Server. That should do it.
ASKER
gwarcher

I access it remotely from the firewall currently on its default port 1433. Won't changing that port effect that?
ASKER CERTIFIED SOLUTION
Abhigyan Srivastava

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
gwarcher

I figured it out with a combination of your answers and my own research. I had to tell VS that the database was not local.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.