We help IT Professionals succeed at work.

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

gwarcher
gwarcher asked
on
1,512 Views
Last Modified: 2016-01-21
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?
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Can you connect to the server in "Server Explorer" of Visual Studio?

Author

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

Author

Commented:
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.
CERTIFIED EXPERT

Commented:
There would be another tab just below Data Source View which is Server Explorer. I am talking about that.
CERTIFIED EXPERT

Commented:
Hmm. Can you share a screenshot.
CERTIFIED EXPERT

Commented:
Also is SQL configured to connect to 2383 port?

Author

Commented:
Screenshot of vs error

Author

Commented:
telnet check seems to be coming back ok.

Author

Commented:
netstat comes back as listening on 0.0.0.0.
CERTIFIED EXPERT

Commented:
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.

Author

Commented:
I access it remotely from the firewall currently on its default port 1433. Won't changing that port effect that?
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.