Issue
I am not able to connect to a SQL Server 2016 instance on a remote system/server.
My Existing Environment
- Windows Server 2012
- SQL Server 2012 and 2016 installed on same server
I tried to enable a firewall rule for SQL Server 2016 with port 1433. But it is not working.
Same thing I tried with SQL Server 2012 it is all working fine.
Settings I Have Tried
- Enabled remote connection in SQL server.
- Created Firewall rule to browse SQL Server.
- Enabled TCP Port.
- Enabled default port 1433.
Error Message I Am Receiving
It would be great if anybody could help me with this.
SQL Server Browser
service as well, otherwise you'll have to specify different ports during installation