Forum Discussion

Copper Contributor

Oct 26, 2018

Solved

Connecting Excel to SQL Server 2017

Hello, I recently downloaded and installed SQL Server 2017 on my laptop and I am having trouble connecting excel with said server. I have tried a variety of trouble shooting options (TCP/IP enabl...

excel

training

VitalieCiobanu
Oct 31, 2018
As far as I can see, using SQL Management Studio you are connecting to a server name that has one R letter but in Excel, you have two R letters in TIRREL.
If you are connecting fine from SQL Management Studio, then your hostname only contains one R.

Tirrell Brown

Copper Contributor

Oct 29, 2018

Hey

Thanks for responding. So I turned windows firewall off, allowed a special rule for the port and the server and I am still receiving the same error message. Would it happen to be a security issue on the excel side? I allowed all connections under excel..

VitalieCiobanu

MCT

Oct 29, 2018

I doubt.
Do you have SQL Management Studio? If not, install it and try to connect to your local SQL server/instance from there.
Are you able to connect?

Tirrell Brown
Copper Contributor
Oct 30, 2018
Hey

I have SQL Management Studio 2017 installed and operating. I have tried running it as admin and as a regular login.
- VitalieCiobanu
  MCT
  Oct 30, 2018
  And were you able to connect? Can you share a screenshot with login screen from Management Studio?
  - Tirrell Brown
    Copper Contributor
    Oct 30, 2018
    Hey,
    
    Yes I am able to connect. The only thing that I can not do is connect my excel (externally) to the database so that I can import files into an excel document. See the attachment. I have already enabled pipes and TCP/IP connections.