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 31, 2018

Hey,

So I go to Get Data---SQL Server---Input servername\instance name (I have tried all formats including "/" and "//." and "\\." and "\") then I log in with my windows credentials. Would creating or setting up a mixed log in mode solve that issue? See the screenshots..

VitalieCiobanu

MCT

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.

VitalieCiobanu
MCT
Nov 01, 2018
No worries! It happened, and will happen, to everybody
Tirrell Brown
Copper Contributor
Oct 31, 2018
Wow..I feel dumb..it works now..thanks for your help hahahahahahahaha.