Oct 26 2018 02:37 PM
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 enabled, checking that browser is active, named pipes is enabled, shared memory enabled, making sure that outside connections are allowed in Microsoft Excel, etc.) and every time I receive one of the following messages: error 40 or error 26. I even adjusted the string and made sure my instance and server name were correct (NE-SF-T******\\SQLSERVER and ".....\\mssqlserver) and I am still running into the same error. Any help on this would be appreciated.
Oct 28 2018 10:26 AM - edited Oct 28 2018 10:27 AM
Hi Tirrell,
How are you trying to connect? If you installed SQL using default instance, then you only need to specify your hostname, without instance name. See screenshots attached, my hostname is called SQL2017 so I'm connecting to it with no issues.
If you still have issues, either disable firewall or open 1433 and 4022 TCP ports.
Oct 29 2018 07:55 AM
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..
Oct 29 2018 08:00 AM
Oct 30 2018 08:42 AM
Hey
I have SQL Management Studio 2017 installed and operating. I have tried running it as admin and as a regular login.
Oct 30 2018 08:45 AM
Oct 30 2018 08:54 AM
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.
Oct 30 2018 11:47 PM
Oct 31 2018 01:19 PM
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..
Oct 31 2018 01:44 PM - edited Oct 31 2018 01:44 PM
SolutionAs 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.
Oct 31 2018 03:20 PM
Wow..I feel dumb..it works now..thanks for your help hahahahahahahaha.
Nov 01 2018 01:00 AM
Oct 31 2018 01:44 PM - edited Oct 31 2018 01:44 PM
SolutionAs 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.