14,494 questions
ServerNAME,1434 works!!
SQL Server 2014 Not Accepting Remote Connections
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 69%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Anthony C
46
Reputation points
Hello Forum
I have just built a new default installation of SQL Server 2014, listening on Port 1434. I can connect to the Database Server locally but not remotely.
Remote Connections are configured.
Authentication is mixed
Can connect locally with my AD account and a SQL Server Account
Cannot connect from my laptop
Can anyone offer any advice?
SQL Server Other
{count} votes
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff2022-01-05T03:14:56.173+00:00 Hi @Anthony C ,
I am so glad to hear that your issue has been resolved. Please mark your solution as answer. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
By the way, even though the connection worked. Still suggest you checking the information that Erland mentioned. That may be the root cause of this issue.
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2022-01-05T22:13:34.507+00:00 I am so glad to hear that your issue has been resolved. Please mark your solution as answer
I don't think it is possible for posters to accept your their own Answer any more, but they have removed that possibility.
Sign in to comment
5 answers
Sort by: Most helpful
-
Anthony C 46 Reputation points
2022-01-04T14:50:04.027+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tom Phillips 17,771 Reputation points2022-01-04T19:49:01.963+00:00 TCP port 1434 is the dedicated administrator port. You should not use that to connect to the instance.
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
2022-01-04T22:48:25.403+00:00 That suggests that you have a problem with the Browser service. Either it is not running, or port UDP 1434 is blocked in the firewall.
-
Olaf Helper 47,436 Reputation points2022-01-05T06:55:41.52+00:00 TCP port 1434 is the dedicated administrator port.
Rigth, forget that, it's the default port for DAC = Dedicated Admin Connection, but on the other hand the port is assigned dynamically on startup.
Sign in to comment -
-
Olaf Helper 47,436 Reputation points
2022-01-04T13:22:09.643+00:00 listening on Port 1434
Really IP port 1434, not default 1433? In this case the SQL Server-Browser service must be running to provide the used IP port to clients.
Have you tried to pass the port in the server name to connect to, for exampletcp:servername, 1434or with the IP address.
-
Anthony C 46 Reputation points
2022-01-04T13:26:02.703+00:00 Browser is running (sorry I should have mentioned that). Also before it was running on Port 1433 and it still would not allow remote connections...
-
Olaf Helper 47,436 Reputation points
2022-01-04T14:11:44.3+00:00 Is TCP/IP network protocoll enabled? Enable or Disable a Server Network Protocol
Otherwise see MS Support: Solving Connectivity errors to SQL Server-
Anthony C 46 Reputation points
2022-01-04T14:33:06.877+00:00 TCP/IP and Shared Memory Protocols are enabled
Sign in to comment -
-
Tom Phillips 17,771 Reputation points
2022-01-04T19:47:01.28+00:00 What exactly is the error message?
What application is unable to connect? Is this SSMS or something else?
I suggest you start here:
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-ver15