Forum Discussion
Connecting Excel to SQL Server 2017
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.
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.
- Open Windows Firewall with Advanced Security
- Right click Inbound Rules and select New rule
- In the New Inbound Rule Wizard window make the following modifications:
- Rule Type – Port
- Protocol and Ports – TCP, Specific local ports: 1433, 4022
- Action – Allow the connection
- Profile – no modification
- Name – SQL TCP ports
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..
- 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?Hey
I have SQL Management Studio 2017 installed and operating. I have tried running it as admin and as a regular login.
- And were you able to connect? Can you share a screenshot with login screen from Management Studio?