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
Avatar of Abhigyan Srivastava
Abhigyan Srivastava
Flag of India image

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

ASKER

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

ASKER

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.
There would be another tab just below Data Source View which is Server Explorer. I am talking about that.
Hmm. Can you share a screenshot.
Also is SQL configured to connect to 2383 port?
Avatar of gwarcher
gwarcher

ASKER

User generated image
Avatar of gwarcher
gwarcher

ASKER

telnet check seems to be coming back ok.
Avatar of gwarcher
gwarcher

ASKER

netstat comes back as listening on 0.0.0.0.
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.
Avatar of gwarcher
gwarcher

ASKER

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

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of gwarcher
gwarcher

ASKER

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.
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo